--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 oap. period_name = upper('&period_name')
AND OAP. ORGANIZATION_ID = OOD. ORGANIZATION_ID
order by ood. organization_code
SELECT OOD. ORGANIZATION_CODE, OAP. PERIOD_NAME, OPEN_FLAG, OAP. SUMMARIZED_FLAG
FROM APPS. ORG_ACCT_PERIODS OAP,
apps. org_organization_definitions ood where oap. period_name = upper('&period_name')
AND OAP. ORGANIZATION_ID = OOD. ORGANIZATION_ID
order by ood. organization_code
No comments:
Post a Comment