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, ppdd.change_status FROM po_price_diff_draft ppdd, po_drafts dft WHERE ppdd.draft_id = dft.draft_id AND Nvl(ppdd.delete_flag,'N') = 'N' UNION ALL SELECT To_number(NULL), NULL, NULL, To_number(-1), 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, NULL FROM po_price_differentials ppd UNION ALL SELECT To_number(NULL), NULL, NULL, dft.draft_id, 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, NULL FROM po_price_differentials ppd, po_lines_draft_all pld, po_drafts dft WHERE pld.po_line_id = ppd.entity_id AND pld.draft_id = dft.draft_id AND NOT EXISTS (SELECT 1 FROM po_price_diff_draft ppdd WHERE ppd.price_differential_id = ppdd.price_differential_id And ppdd.draft_id = dft.draft_id AND Nvl(ppdd.delete_flag,'N') = 'N')

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
, PPDD.CHANGE_STATUS
FROM PO_PRICE_DIFF_DRAFT PPDD
, PO_DRAFTS DFT
WHERE PPDD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PPDD.DELETE_FLAG
, 'N') = 'N' UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(-1)
, 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
, NULL
FROM PO_PRICE_DIFFERENTIALS PPD UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, DFT.DRAFT_ID
, 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
, NULL
FROM PO_PRICE_DIFFERENTIALS PPD
, PO_LINES_DRAFT_ALL PLD
, PO_DRAFTS DFT
WHERE PLD.PO_LINE_ID = PPD.ENTITY_ID
AND PLD.DRAFT_ID = DFT.DRAFT_ID
AND NOT EXISTS (SELECT 1
FROM PO_PRICE_DIFF_DRAFT PPDD
WHERE PPD.PRICE_DIFFERENTIAL_ID = PPDD.PRICE_DIFFERENTIAL_ID
AND PPDD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PPDD.DELETE_FLAG
, 'N') = 'N')