DBA Data[Home] [Help]

VIEW: APPS.PSB_DEFAULTS_V

Source

View Text - Preformatted

SELECT D.ROWID ,D.DEFAULT_RULE_ID ,D.NAME ,D.GLOBAL_DEFAULT_FLAG ,D.DATA_EXTRACT_ID ,DE.DATA_EXTRACT_NAME ,D.BUSINESS_GROUP_ID ,D.ENTITY_ID ,D.OVERWRITE ,D.PRIORITY ,D.LAST_UPDATE_DATE ,D.LAST_UPDATED_BY ,D.LAST_UPDATE_LOGIN ,D.CREATED_BY ,D.CREATION_DATE from PSB_DEFAULTS D, PSB_DATA_EXTRACTS DE where D.DATA_EXTRACT_ID = DE.DATA_EXTRACT_ID
View Text - HTML Formatted

SELECT D.ROWID
, D.DEFAULT_RULE_ID
, D.NAME
, D.GLOBAL_DEFAULT_FLAG
, D.DATA_EXTRACT_ID
, DE.DATA_EXTRACT_NAME
, D.BUSINESS_GROUP_ID
, D.ENTITY_ID
, D.OVERWRITE
, D.PRIORITY
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
, D.CREATED_BY
, D.CREATION_DATE
FROM PSB_DEFAULTS D
, PSB_DATA_EXTRACTS DE
WHERE D.DATA_EXTRACT_ID = DE.DATA_EXTRACT_ID