View: PO_PRICE_DIFF_MERGE_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_PRICE_DIFF_MERGE_V

View Text

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 PPDD.DELETE_FLAG IS NULL
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')

Columns