VIEW: APPS.PSB_FTE_RULES_V

Source

View Text - Preformatted

SELECT A.ROWID ,A.DEFAULT_RULE_ID ,A.NAME ,A.GLOBAL_DEFAULT_FLAG ,A.DATA_EXTRACT_ID ,A.BUSINESS_GROUP_ID ,A.ENTITY_ID ,A.PRIORITY ,A.LAST_UPDATE_DATE ,A.LAST_UPDATED_BY ,A.LAST_UPDATE_LOGIN ,A.CREATED_BY ,A.CREATION_DATE FROM PSB_DEFAULTS A WHERE EXISTS (SELECT 1 FROM PSB_ALLOCRULE_PERCENTS B WHERE A.ENTITY_ID = B.ALLOCATION_RULE_ID)

View Text - HTML Formatted

SELECT A.ROWID
, A.DEFAULT_RULE_ID
, A.NAME
, A.GLOBAL_DEFAULT_FLAG
, A.DATA_EXTRACT_ID
, A.BUSINESS_GROUP_ID
, A.ENTITY_ID
, A.PRIORITY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.CREATION_DATE
FROM PSB_DEFAULTS A
WHERE EXISTS (SELECT 1
FROM PSB_ALLOCRULE_PERCENTS B
WHERE A.ENTITY_ID = B.ALLOCATION_RULE_ID)