VIEW: APPS.PO_PRICE_ADJ_ATTRIBS_V

Source

View Text - Preformatted

SELECT DFT.DRAFT_ID,PPD.PO_HEADER_ID,PPD.PO_LINE_ID,ATTRD.PRICE_ADJUSTMENT_ID,ATTRD.PRICING_CONTEXT,ATTRD.PRICING_ATTRIBUTE,ATTRD.CREATION_DATE,ATTRD.CREATED_BY,ATTRD.LAST_UPDATE_DATE,ATTRD.LAST_UPDATED_BY,ATTRD.LAST_UPDATE_LOGIN,ATTRD.PROGRAM_APPLICATION_ID,ATTRD.PROGRAM_ID,ATTRD.PROGRAM_UPDATE_DATE,ATTRD.REQUEST_ID,ATTRD.PRICING_ATTR_VALUE_FROM,ATTRD.PRICING_ATTR_VALUE_TO,ATTRD.COMPARISON_OPERATOR,ATTRD.FLEX_TITLE,ATTRD.PRICE_ADJ_ATTRIB_ID,PPD.APPLIED_FLAG,PPD.AUTOMATIC_FLAG,PPD.UPDATE_ALLOWED,PPD.UPDATED_FLAG,ATTRD.LOCK_CONTROL FROM PO_PRICE_ADJ_ATTRIBS_DRAFT ATTRD,PO_PRICE_ADJUSTMENTS_DRAFT PPD,PO_PRICE_ADJUSTMENTS_DRAFT RPPD,PO_DRAFTS DFT WHERE attrd.draft_id = dft.draft_id AND attrd.price_adjustment_id = ppd.price_adjustment_id AND NVL(ppd.delete_flag,'N') = 'N' AND ppd.parent_adjustment_id = rppd.price_adjustment_id (+) AND ppd.draft_id = rppd.draft_id (+) AND NVL(rppd.delete_flag (+),'N') = 'N' AND dft.owner_role = po_global.ROLE AND dft.status <> 'COMPLETED' UNION ALL SELECT TO_NUMBER(NULL), ppa.po_header_id, ppa.po_line_id, attr.price_adjustment_id, attr.pricing_context, attr.pricing_attribute, attr.creation_date, attr.created_by, attr.last_update_date, attr.last_updated_by, attr.last_update_login, attr.program_application_id, attr.program_id, attr.program_update_date, attr.request_id, attr.pricing_attr_value_from, attr.pricing_attr_value_to, attr.comparison_operator, attr.flex_title, attr.price_adj_attrib_id, ppa.applied_flag, ppa.automatic_flag, ppa.update_allowed, ppa.updated_flag, attr.lock_control FROM po_price_adj_attribs attr, po_price_adjustments ppa WHERE attr.price_adjustment_id = ppa.price_adjustment_id AND NOT EXISTS (SELECT 1 FROM po_price_adj_attribs_draft attrd1, po_drafts dft1 WHERE ppa.price_adjustment_id = attrd1.price_adjustment_id AND attr.price_adj_attrib_id = attrd1.price_adj_attrib_id AND attrd1.draft_id = dft1.draft_id AND dft1.owner_role = po_global.ROLE AND dft1.status <> 'COMPLETED') AND NOT EXISTS (SELECT 1 FROM po_price_adj_attribs_draft attrd2, po_drafts dft2 WHERE ppa.parent_adjustment_id = attrd2.price_adjustment_id AND attr.price_adj_attrib_id = attrd2.price_adj_attrib_id AND attrd2.draft_id = dft2.draft_id AND dft2.owner_role = po_global.ROLE AND dft2.status <> 'COMPLETED')

View Text - HTML Formatted

SELECT DFT.DRAFT_ID
, PPD.PO_HEADER_ID
, PPD.PO_LINE_ID
, ATTRD.PRICE_ADJUSTMENT_ID
, ATTRD.PRICING_CONTEXT
, ATTRD.PRICING_ATTRIBUTE
, ATTRD.CREATION_DATE
, ATTRD.CREATED_BY
, ATTRD.LAST_UPDATE_DATE
, ATTRD.LAST_UPDATED_BY
, ATTRD.LAST_UPDATE_LOGIN
, ATTRD.PROGRAM_APPLICATION_ID
, ATTRD.PROGRAM_ID
, ATTRD.PROGRAM_UPDATE_DATE
, ATTRD.REQUEST_ID
, ATTRD.PRICING_ATTR_VALUE_FROM
, ATTRD.PRICING_ATTR_VALUE_TO
, ATTRD.COMPARISON_OPERATOR
, ATTRD.FLEX_TITLE
, ATTRD.PRICE_ADJ_ATTRIB_ID
, PPD.APPLIED_FLAG
, PPD.AUTOMATIC_FLAG
, PPD.UPDATE_ALLOWED
, PPD.UPDATED_FLAG
, ATTRD.LOCK_CONTROL
FROM PO_PRICE_ADJ_ATTRIBS_DRAFT ATTRD
, PO_PRICE_ADJUSTMENTS_DRAFT PPD
, PO_PRICE_ADJUSTMENTS_DRAFT RPPD
, PO_DRAFTS DFT
WHERE ATTRD.DRAFT_ID = DFT.DRAFT_ID
AND ATTRD.PRICE_ADJUSTMENT_ID = PPD.PRICE_ADJUSTMENT_ID
AND NVL(PPD.DELETE_FLAG
, 'N') = 'N'
AND PPD.PARENT_ADJUSTMENT_ID = RPPD.PRICE_ADJUSTMENT_ID (+)
AND PPD.DRAFT_ID = RPPD.DRAFT_ID (+)
AND NVL(RPPD.DELETE_FLAG (+)
, 'N') = 'N'
AND DFT.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT.STATUS <> 'COMPLETED' UNION ALL SELECT TO_NUMBER(NULL)
, PPA.PO_HEADER_ID
, PPA.PO_LINE_ID
, ATTR.PRICE_ADJUSTMENT_ID
, ATTR.PRICING_CONTEXT
, ATTR.PRICING_ATTRIBUTE
, ATTR.CREATION_DATE
, ATTR.CREATED_BY
, ATTR.LAST_UPDATE_DATE
, ATTR.LAST_UPDATED_BY
, ATTR.LAST_UPDATE_LOGIN
, ATTR.PROGRAM_APPLICATION_ID
, ATTR.PROGRAM_ID
, ATTR.PROGRAM_UPDATE_DATE
, ATTR.REQUEST_ID
, ATTR.PRICING_ATTR_VALUE_FROM
, ATTR.PRICING_ATTR_VALUE_TO
, ATTR.COMPARISON_OPERATOR
, ATTR.FLEX_TITLE
, ATTR.PRICE_ADJ_ATTRIB_ID
, PPA.APPLIED_FLAG
, PPA.AUTOMATIC_FLAG
, PPA.UPDATE_ALLOWED
, PPA.UPDATED_FLAG
, ATTR.LOCK_CONTROL
FROM PO_PRICE_ADJ_ATTRIBS ATTR
, PO_PRICE_ADJUSTMENTS PPA
WHERE ATTR.PRICE_ADJUSTMENT_ID = PPA.PRICE_ADJUSTMENT_ID
AND NOT EXISTS (SELECT 1
FROM PO_PRICE_ADJ_ATTRIBS_DRAFT ATTRD1
, PO_DRAFTS DFT1
WHERE PPA.PRICE_ADJUSTMENT_ID = ATTRD1.PRICE_ADJUSTMENT_ID
AND ATTR.PRICE_ADJ_ATTRIB_ID = ATTRD1.PRICE_ADJ_ATTRIB_ID
AND ATTRD1.DRAFT_ID = DFT1.DRAFT_ID
AND DFT1.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT1.STATUS <> 'COMPLETED')
AND NOT EXISTS (SELECT 1
FROM PO_PRICE_ADJ_ATTRIBS_DRAFT ATTRD2
, PO_DRAFTS DFT2
WHERE PPA.PARENT_ADJUSTMENT_ID = ATTRD2.PRICE_ADJUSTMENT_ID
AND ATTR.PRICE_ADJ_ATTRIB_ID = ATTRD2.PRICE_ADJ_ATTRIB_ID
AND ATTRD2.DRAFT_ID = DFT2.DRAFT_ID
AND DFT2.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT2.STATUS <> 'COMPLETED')