APPS.QP_PREQ_GRP dependencies on QP_RLTD_MODIFIERS

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

11697: x_status_code OUT NOCOPY VARCHAR2,
11698: x_status_text OUT NOCOPY VARCHAR2) AS
11699:
11700: /*
11701: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,QP_RLTD_MODIFIERS_N1,FROM_RLTD_MODIFIER_ID,1
11702:
11703: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
11704: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
11705: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3

Line 11771: qp_rltd_modifiers qprm,

11767: qplines.contract_end_date -- R12 partial period pricing
11768: FROM
11769: qp_npreq_line_attrs_tmp qplat_pricing,
11770: qp_npreq_lines_tmp qplines,
11771: qp_rltd_modifiers qprm,
11772: qp_pricing_attributes qppa,
11773: qp_list_lines qpll
11774: ,qp_list_headers_b qph /* Vivek */
11775: ,qp_currency_details qcdt /* Vivek */

Line 11904: qp_rltd_modifiers qprm,

11900: qplines.contract_end_date -- R12 partial period pricing
11901: FROM
11902: qp_npreq_line_attrs_tmp qplat_pricing,
11903: qp_npreq_lines_tmp qplines,
11904: qp_rltd_modifiers qprm,
11905: qp_pricing_attributes qppa,
11906: qp_list_lines qpll
11907: WHERE qprm.from_rltd_modifier_id = p_list_line_id
11908: AND qprm.to_rltd_modifier_id = qppa.list_line_id

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

13576: -- same list line id and line index can be there in the temp table more than once. Combination of Context and Attribute's
13577: -- distinctness is what is looked for
13578:
13579: /*
13580: INDX,QP_PREQ_GRP.perform_grouping.product_level_attrs_cur,QP_RLTD_MODIFIERS_N2,TO_RLTD_MODIFIER_ID,1
13581: */
13582:
13583: /*
13584: INDX,QP_PREQ_GRP.Perform_Grouping.product_level_attrs_cur,qp_npreq_line_attrs_tmp_N5,PRICING_PHASE_ID,1

Line 13606: FROM QP_RLTD_MODIFIERS b

13602: AND a.PRICING_STATUS_CODE = G_STATUS_NEW
13603: AND a.LINE_DETAIL_INDEX = b.LINE_DETAIL_INDEX
13604: AND b.PRICING_STATUS_CODE = G_STATUS_NEW
13605: AND NOT EXISTS (SELECT 'X'
13606: FROM QP_RLTD_MODIFIERS b
13607: WHERE a.LIST_LINE_ID = b.TO_RLTD_MODIFIER_ID
13608: and b.rltd_modifier_grp_type <> 'COUPON') -- 5439022
13609: GROUP BY a.LIST_HEADER_ID , a.LIST_LINE_ID,a.LINE_INDEX;
13610: