View: CSTFV_MFG_ACCTG_PERIOD

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTFV_MFG_ACCTG_PERIOD

View Text

SELECT /* REGULAR ATTRIBUTE */ OAP.ORGANIZATION_ID
, OAP.ACCT_PERIOD_ID
, OAP.PERIOD_SET_NAME
, OAP.PERIOD_NAME
, OAP.PERIOD_YEAR
, OAP.PERIOD_NUM
, /* ID */ OAP.PERIOD_START_DATE
, OAP.PERIOD_CLOSE_DATE
, OAP.SCHEDULE_CLOSE_DATE
, OAP.OPEN_FLAG
, MP.ORGANIZATION_CODE
, HAOU.NAME
, /* WHO */ OAP.CREATION_DATE
, OAP.CREATED_BY
, OAP.LAST_UPDATE_DATE
, OAP.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, ORG_ACCT_PERIODS OAP
WHERE OAP.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = OAP.ORGANIZATION_ID
AND '_SEC:OAP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns