Home/Oracle E-Business Suite/Oracle EBS Queries/Page 2
  1. Asked: February 4, 2021In:

    Query to get all inventory periods for a specific organization

    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    This answer was edited.

    Hello @Waqas, You can use the following query to get inventory periods with it's status for one or more inventory organization also there is a condition hashed for period name if you want to query about particular period. you just need to un hash the condition. SELECT OOD.ORGANIZATION_CODE,OAP.PERIORead more

    Hello Waqas,

    You can use the following query to get inventory periods with it’s status for one or more inventory organization also there is a condition hashed for period name if you want to query about particular period. you just need to un hash the condition.

    SELECT OOD.ORGANIZATION_CODE
    ,OAP.PERIOD_NAME
    ,OAP.OPEN_FLAG
    ,X.MEANING
    FROM ORG_ACCT_PERIODS OAP, ORG_ORGANIZATION_DEFINITIONS OOD, MFG_LOOKUPS X
    WHERE OAP.ORGANIZATION_ID = OOD.ORGANIZATION_ID
    AND OOD.ORGANIZATION_CODE = ('&ORG_CODE')
    --AND UPPER (OAP.PERIOD_NAME) = UPPER ('&PERIOD_NAME')
    AND X.LOOKUP_TYPE(+) = 'MTL_ACCT_PERIOD_STATUS'
    AND X.ENABLED_FLAG(+) = 'Y'
    AND X.LOOKUP_CODE(+) =
    DECODE (NVL (OAP.PERIOD_CLOSE_DATE, SYSDATE), OAP.PERIOD_CLOSE_DATE, DECODE (OAP.OPEN_FLAG, 'N', DECODE (OAP.SUMMARIZED_FLAG, 'N', 65, 66), 'Y', 4, 'P', 2, 4), 3)
    ORDER BY OOD.ORGANIZATION_CODE;

     

    See less
    • 0