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;