APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on PO_PRICE_ADJ_ATTRIBS_V

Line 645: FROM PO_PRICE_ADJ_ATTRIBS_V ATTRV

641: ,ATTRV.pricing_attr_value_to "VALUE_TO"
642: ,ATTRV.comparison_operator "COMPARISON_OPERATOR_TYPE"
643: ,DECODE(ATTRV.flex_title
644: ,'QP_ATTR_DEFNS_QUALIFIER', 'Y', 'N') "VALIDATED_FLAG"
645: FROM PO_PRICE_ADJ_ATTRIBS_V ATTRV
646: WHERE ATTRV.po_header_id = p_order_header_id --ATTRV.draft_id = p_draft_id --sometimes draft_id may be passed as null
647: AND ATTRV.po_line_id = p_order_line_id
648: AND NVL(ATTRV.applied_flag,'Y') = 'Y' --To avoid applying manual modifiers selected and cancelled by the user
649: AND (ATTRV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual

Line 2990: FROM PO_PRICE_ADJ_ATTRIBS_V ATTRV

2986: */
2987:
2988: SELECT COUNT(1)
2989: INTO l_src_attr_count
2990: FROM PO_PRICE_ADJ_ATTRIBS_V ATTRV
2991: WHERE ATTRV.po_line_id = p_src_po_line_id --ADJV.draft_id = p_draft_id AND ATTRV.draft_id = ADJV.draft_id --the draft id may not have been initialized when copy event was triggered
2992: AND (l_auto_manual_flag IS NULL OR ATTRV.automatic_flag = l_auto_manual_flag)
2993: AND (l_override_allowed_flag IS NULL OR ATTRV.update_allowed = l_override_allowed_flag)
2994: AND (l_overridden_flag IS NULL OR ATTRV.updated_flag = l_overridden_flag);

Line 3163: FROM PO_PRICE_ADJ_ATTRIBS_V ATTRV

3159: , ATTRV.comparison_operator
3160: , ATTRV.FLEX_TITLE
3161: , PO_PRICE_ADJ_ATTRIBS_S.nextval
3162: , 1
3163: FROM PO_PRICE_ADJ_ATTRIBS_V ATTRV
3164: WHERE ATTRV.price_adjustment_id = l_src_price_adjustment_id); --ATTRV.draft_id = p_draft_id --draft_id may not have been initialized when copy event was triggered
3165: l_dest_attr_count := l_dest_attr_count + SQL%ROWCOUNT;
3166:
3167: --Get the source and dest price adjustment id mapping, will be used later to update the parent adjustment ids