VIEW: APPS.PSBFV_DATA_EXTRACTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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