VIEW: APPS.PO_PRICE_DIFF_MERGE_V

Source

View Text - Preformatted

SELECT DFT.owner_user_id, DFT.owner_role, DFT.status, DFT.draft_id, PPDD.change_accepted_flag, PPDD.delete_flag, PPDD.price_differential_id, PPDD.price_differential_num, PPDD.entity_type, PPDD.entity_id, PPDD.price_type, PPDD.multiplier, PPDD.min_multiplier, PPDD.max_multiplier, PPDD.enabled_flag, PPDD.created_by, PPDD.creation_date, PPDD.last_updated_by, PPDD.last_update_date, PPDD.last_update_login FROM PO_PRICE_DIFF_DRAFT PPDD, PO_DRAFTS DFT WHERE PPDD.draft_id = DFT.draft_id AND NVL(PPDD.delete_flag, 'N') = 'N' AND DFT.owner_role = PO_GLOBAL.role AND DFT.status <> 'COMPLETED' UNION ALL SELECT TO_NUMBER (NULL), NULL, NULL, TO_NUMBER (NULL), NULL, NULL, PPD.price_differential_id, PPD.price_differential_num, PPD.entity_type, PPD.entity_id, PPD.price_type, PPD.multiplier, PPD.min_multiplier, PPD.max_multiplier, PPD.enabled_flag, PPD.created_by, PPD.creation_date, PPD.last_updated_by, PPD.last_update_date, PPD.last_update_login FROM PO_PRICE_DIFFERENTIALS PPD WHERE NOT EXISTS ( SELECT 1 FROM PO_PRICE_DIFF_DRAFT PPDD1, PO_DRAFTS DFT1 WHERE PPD.price_differential_id = PPDD1.price_differential_id AND PPDD1.draft_id = DFT1.draft_id AND DFT1.owner_role = PO_GLOBAL.role AND DFT1.status <> 'COMPLETED')

View Text - HTML Formatted

SELECT DFT.OWNER_USER_ID
, DFT.OWNER_ROLE
, DFT.STATUS
, DFT.DRAFT_ID
, PPDD.CHANGE_ACCEPTED_FLAG
, PPDD.DELETE_FLAG
, PPDD.PRICE_DIFFERENTIAL_ID
, PPDD.PRICE_DIFFERENTIAL_NUM
, PPDD.ENTITY_TYPE
, PPDD.ENTITY_ID
, PPDD.PRICE_TYPE
, PPDD.MULTIPLIER
, PPDD.MIN_MULTIPLIER
, PPDD.MAX_MULTIPLIER
, PPDD.ENABLED_FLAG
, PPDD.CREATED_BY
, PPDD.CREATION_DATE
, PPDD.LAST_UPDATED_BY
, PPDD.LAST_UPDATE_DATE
, PPDD.LAST_UPDATE_LOGIN
FROM PO_PRICE_DIFF_DRAFT PPDD
, PO_DRAFTS DFT
WHERE PPDD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PPDD.DELETE_FLAG
, 'N') = 'N'
AND DFT.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT.STATUS <> 'COMPLETED' UNION ALL SELECT TO_NUMBER (NULL)
, NULL
, NULL
, TO_NUMBER (NULL)
, NULL
, NULL
, PPD.PRICE_DIFFERENTIAL_ID
, PPD.PRICE_DIFFERENTIAL_NUM
, PPD.ENTITY_TYPE
, PPD.ENTITY_ID
, PPD.PRICE_TYPE
, PPD.MULTIPLIER
, PPD.MIN_MULTIPLIER
, PPD.MAX_MULTIPLIER
, PPD.ENABLED_FLAG
, PPD.CREATED_BY
, PPD.CREATION_DATE
, PPD.LAST_UPDATED_BY
, PPD.LAST_UPDATE_DATE
, PPD.LAST_UPDATE_LOGIN
FROM PO_PRICE_DIFFERENTIALS PPD
WHERE NOT EXISTS ( SELECT 1
FROM PO_PRICE_DIFF_DRAFT PPDD1
, PO_DRAFTS DFT1
WHERE PPD.PRICE_DIFFERENTIAL_ID = PPDD1.PRICE_DIFFERENTIAL_ID
AND PPDD1.DRAFT_ID = DFT1.DRAFT_ID
AND DFT1.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT1.STATUS <> 'COMPLETED')