Skip to main content

Posts

Showing posts with the label INV Technical

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