Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSBFV_DATA_EXTRACTS |
SELECT PDE.DATA_EXTRACT_NAME
, PDE.DATA_EXTRACT_METHOD
, GSB.NAME
, PBG.NAME
, FST.ID_FLEX_STRUCTURE_NAME
, PDE.POPULATE_INTERFACE_FLAG
, PDE.POPULATE_DATA_FLAG
, PDE.COPY_DEFAULTS_FLAG
, PDE.VALIDATE_DATA_FLAG
, PDE.DEFAULT_DATA_FLAG
, PDE.POPULATE_INTERFACE_STATUS
, PDE.POPULATE_DATA_STATUS
, PDE.COPY_DEFAULTS_STATUS
, PDE.VALIDATE_DATA_STATUS
, PDE.DEFAULT_DATA_STATUS
, PDE.DATA_EXTRACT_STATUS
, PDE.REQ_DATA_AS_OF_DATE
, PDE.DATA_EXTRACT_ID
, PDE.SET_OF_BOOKS_ID
, PDE.BUSINESS_GROUP_ID
, PDE.POSITION_ID_FLEX_NUM
, PDE.COPY_DEFAULTS_EXTRACT_ID
, PDE.CREATION_DATE
, PDE.CREATED_BY
, PDE.LAST_UPDATE_DATE
, PDE.LAST_UPDATED_BY
FROM PSB_DATA_EXTRACTS PDE
, GL_SETS_OF_BOOKS GSB
, PER_BUSINESS_GROUPS PBG
, FND_ID_FLEX_STRUCTURES_VL FST
WHERE PDE.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID
AND PDE.BUSINESS_GROUP_ID = PBG.BUSINESS_GROUP_ID
AND PDE.POSITION_ID_FLEX_NUM = FST.ID_FLEX_NUM
AND FST.APPLICATION_ID = 8401
AND ID_FLEX_CODE = 'BPS' WITH READ ONLY