View: ORG_ACCT_PERIODS_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.ORG_ACCT_PERIODS_V

View Text

SELECT Z.ROWID
, 'ORG_PERIOD'
, Z.ORGANIZATION_ID
, Z.ACCT_PERIOD_ID
, NULL
, NULL
, X.MEANING
, Z.PERIOD_NAME
, Z.PERIOD_NUM
, Z.PERIOD_YEAR
, Z.PERIOD_START_DATE
, Z.SCHEDULE_CLOSE_DATE
, Z.PERIOD_CLOSE_DATE
, Z.LAST_UPDATE_DATE
, Z.LAST_UPDATED_BY
, Z.CREATION_DATE
, Z.CREATED_BY
, Z.LAST_UPDATE_LOGIN
FROM ORG_ACCT_PERIODS Z
, MFG_LOOKUPS X
WHERE X.LOOKUP_TYPE(+) = 'MTL_ACCT_PERIOD_STATUS'
AND X.ENABLED_FLAG(+) = 'Y'
AND X.LOOKUP_CODE(+) = DECODE(NVL(Z.PERIOD_CLOSE_DATE
, SYSDATE)
, Z.PERIOD_CLOSE_DATE
, DECODE(Z.OPEN_FLAG
, 'N'
, DECODE(SUMMARIZED_FLAG
, 'N'
, 65
, 66)
, 'Y'
, 4
, 'P'
, 2
, 4)
, 3 ) UNION ALL SELECT Y.ROWID
, 'GL_PERIOD'
, 0
, 0
, Y.PERIOD_TYPE
, Y.PERIOD_SET_NAME
, X.MEANING
, Y.PERIOD_NAME
, Y.PERIOD_NUM
, Y.PERIOD_YEAR
, Y.START_DATE
, Y.END_DATE
, TO_DATE(NULL)
, Y.LAST_UPDATE_DATE
, Y.LAST_UPDATED_BY
, Y.CREATION_DATE
, Y.CREATED_BY
, Y.LAST_UPDATE_LOGIN
FROM GL_PERIODS Y
, MFG_LOOKUPS X
WHERE ( Y.ADJUSTMENT_PERIOD_FLAG = 'N' )
AND X.LOOKUP_TYPE(+) = 'MTL_ACCT_PERIOD_STATUS'
AND X.ENABLED_FLAG(+) = 'Y'
AND X.LOOKUP_CODE (+)= 67

Columns