EBS R12 QUERY TO GET ALL INVENTORY ORGANIZATIONS IN OPERATING UNITS

QUERY TO GET ALL INVENTORY ORGANIZATIONS IN OPERATING UNITS

SELECT  LGR.NAME "Ledger"           ,
  XLE.NAME "Legal Entity"           ,
  HOU1.NAME "Operating Unit"        ,
  HOU.NAME "Inventory Organization" ,
  hou.organization_id,
  MP.ORGANIZATION_CODE "Organization Code"
   FROM HR_ALL_ORGANIZATION_UNITS HOU ,
  HR_ORGANIZATION_INFORMATION HOI1    ,
  HR_ORGANIZATION_INFORMATION HOI2    ,
  MTL_PARAMETERS MP                   ,
  GL_LEDGERS LGR                      ,
  XLE_ENTITY_PROFILES XLE             ,
  HR_ALL_ORGANIZATION_UNITS HOU1
  WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID     = HOI2.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID     = MP.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1   = 'INV'
AND HOI1.ORG_INFORMATION2   = 'Y'
AND ( HOI1.ORG_INFORMATION_CONTEXT
  || '') = 'CLASS'
AND ( HOI2.ORG_INFORMATION_CONTEXT
  || '')                                                                                                             ='Accounting Information'
AND TO_NUMBER(DECODE(RTRIM(TRANSLATE(HOI2.ORG_INFORMATION1,'0123456789',' ')), NULL, HOI2.ORG_INFORMATION1,-99999))  = LGR.LEDGER_ID
AND LGR.OBJECT_TYPE_CODE                                                                                             ='L'
AND NVL(LGR.COMPLETE_FLAG,'Y')                                                                                       ='Y'
AND DECODE(HOI2.ORG_INFORMATION_CONTEXT, 'Accounting Information', TO_NUMBER(HOI2.ORG_INFORMATION2), NULL)           =XLE.LEGAL_ENTITY_ID
AND DECODE(HOI2.ORG_INFORMATION_CONTEXT, 'Accounting Information', TO_NUMBER(HOI2.ORG_INFORMATION3), TO_NUMBER(NULL))=HOU1.ORGANIZATION_ID
--AND LGR.NAME                                                                                                         ='&NAME'
order by HOU1.NAME

Comments

Post a Comment

Popular posts from this blog

opaque schema xsd (standard file used in OIC)

 opaque schema xsd (standard file used in OIC) You can use an opaque schema in a stage file action Read File or Write File operation without concern for a schema for the file.   The only condition is that whatever is sent to the opaque element in the opaque schema must be base64-encoded data.  or in other words  it is used to decode base64 files Save the below xml as  opaqueschema.xsd  file and then you can use it in the integration. <?xml version = '1.0' encoding = 'UTF-8'?> <schema targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/opaque/" xmlns="http://www.w3.org/2001/XMLSchema" > <element name="opaqueElement" type="base64Binary" /> </schema>
Read more

DOCUMENTATION ON SANDBOX and PERSONALIZATION

Image
DOCUMENTATION ON SANDBOX PERSONALIZATION Prepared by VAMSI GOVATHOTI ROLE: ORACLE APPS TECHNICAL CONSULTANT Contents A) What is a Sandbox? 2 B) Purpose of Sandboxes 2 C) Key Features 2 D) Why Use Sandboxes? 2 1. How to Customize (Enable or Disable) the Fields/Components in the Sandbox 6 2. How to Enable Direct Access from User Interface (UI) to the Desired Destination using an URL 9 3. How to Create “Role Based Access control” to particular Fields / Components 13 4. ‘More Tasks’ Tab to be renamed to 'Create' on Purchase Requisitions page. 18 5. By using Application Composer making field required in sand box 23 6. Personalization by using application composer 27 A) By using Application Composer creating new field in sand box 27 B) Creating of currency field with fixed choice list 32 C) Creating of currency field with dynamic choice list. 36 7. Creating a button in sand box 40 8. Creating a global function for runtime mess...
Read more

API SOAP to update AR DFF (oracle fusion) includes debit memo

API SOAP to update AR DFF (oracle fusion) includes debit memo WSDL  =>    https://servername/fscmService/ErpObjectDFFUpdateService?WSDL Sample Request body <!-- WSDL https://<hostName>:443/fscmService/ErpObjectDFFUpdateService --> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/" xmlns:erp="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/">    <soapenv:Header/>    <soapenv:Body>       <typ:updateDffEntityDetailsAsync>          <!--Optional:-->          <typ:operationMode>SINGLE</typ:operationMode>          <!--Optional:-->          <typ:object>             <!--Option...
Read more