APPS.QP_PREQ_GRP dependencies on QP_RLTD_MODIFIERS

Line 11421: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,QP_RLTD_MODIFIERS_N1,FROM_RLTD_MODIFIER_ID,1

11417: x_status_code OUT NOCOPY VARCHAR2,
11418: x_status_text OUT NOCOPY VARCHAR2) AS
11419:
11420: /*
11421: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,QP_RLTD_MODIFIERS_N1,FROM_RLTD_MODIFIER_ID,1
11422:
11423: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
11424: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
11425: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3

Line 11489: qp_rltd_modifiers qprm,

11485: qplines.contract_end_date -- R12 partial period pricing
11486: FROM
11487: qp_npreq_line_attrs_tmp qplat_pricing,
11488: qp_npreq_lines_tmp qplines,
11489: qp_rltd_modifiers qprm,
11490: qp_pricing_attributes qppa,
11491: qp_list_lines qpll
11492: ,qp_list_headers_b qph /* Vivek */
11493: ,qp_currency_details qcdt /* Vivek */

Line 11620: qp_rltd_modifiers qprm,

11616: qplines.contract_end_date -- R12 partial period pricing
11617: FROM
11618: qp_npreq_line_attrs_tmp qplat_pricing,
11619: qp_npreq_lines_tmp qplines,
11620: qp_rltd_modifiers qprm,
11621: qp_pricing_attributes qppa,
11622: qp_list_lines qpll
11623: WHERE qprm.from_rltd_modifier_id = p_list_line_id
11624: AND qprm.to_rltd_modifier_id = qppa.list_line_id

Line 13284: INDX,QP_PREQ_GRP.perform_grouping.product_level_attrs_cur,QP_RLTD_MODIFIERS_N2,TO_RLTD_MODIFIER_ID,1

13280: -- same list line id and line index can be there in the temp table more than once. Combination of Context and Attribute's
13281: -- distinctness is what is looked for
13282:
13283: /*
13284: INDX,QP_PREQ_GRP.perform_grouping.product_level_attrs_cur,QP_RLTD_MODIFIERS_N2,TO_RLTD_MODIFIER_ID,1
13285: */
13286:
13287: /*
13288: INDX,QP_PREQ_GRP.Perform_Grouping.product_level_attrs_cur,qp_npreq_line_attrs_tmp_N5,PRICING_PHASE_ID,1

Line 13310: FROM QP_RLTD_MODIFIERS b

13306: AND a.PRICING_STATUS_CODE = G_STATUS_NEW
13307: AND a.LINE_DETAIL_INDEX = b.LINE_DETAIL_INDEX
13308: AND b.PRICING_STATUS_CODE = G_STATUS_NEW
13309: AND NOT EXISTS (SELECT 'X'
13310: FROM QP_RLTD_MODIFIERS b
13311: WHERE a.LIST_LINE_ID = b.TO_RLTD_MODIFIER_ID
13312: and b.rltd_modifier_grp_type <> 'COUPON') -- 5439022
13313: GROUP BY a.LIST_HEADER_ID , a.LIST_LINE_ID,a.LINE_INDEX;
13314: