DBA Data[Home] [Help]

VIEW: APPS.PSBFV_DEFAULT_RULES

Source

View Text - Preformatted

SELECT PD.NAME, PD.GLOBAL_DEFAULT_FLAG, PD.PRIORITY, PDE.DATA_EXTRACT_NAME, PD.DEFAULT_RULE_ID, PD.DATA_EXTRACT_ID, PD.LAST_UPDATE_DATE, PD.LAST_UPDATED_BY, PD.CREATED_BY, PD.CREATION_DATE FROM PSB_DEFAULTS PD, PSB_DATA_EXTRACTS PDE WHERE PD.DATA_EXTRACT_ID = PDE.DATA_EXTRACT_ID WITH READ ONLY
View Text - HTML Formatted

SELECT PD.NAME
, PD.GLOBAL_DEFAULT_FLAG
, PD.PRIORITY
, PDE.DATA_EXTRACT_NAME
, PD.DEFAULT_RULE_ID
, PD.DATA_EXTRACT_ID
, PD.LAST_UPDATE_DATE
, PD.LAST_UPDATED_BY
, PD.CREATED_BY
, PD.CREATION_DATE
FROM PSB_DEFAULTS PD
, PSB_DATA_EXTRACTS PDE
WHERE PD.DATA_EXTRACT_ID = PDE.DATA_EXTRACT_ID WITH READ ONLY