--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
No comments:
Post a Comment
Please review my topic and update your comments
Note: only a member of this blog may post a comment.