Query to check Inventory Periods status

--TO check the status of inventory period

SELECT OOD.ORGANIZATION_CODE, OAP.PERIOD_NAME, OPEN_FLAG, OAP.SUMMARIZED_FLAG

FROM APPS.ORG_ACCT_PERIODS OAP,

apps. org_organization_definitions ood where upper(oap.period_name) = upper('&period_name')

AND OAP.ORGANIZATION_ID = OOD.ORGANIZATION_ID

order by ood.organization_code