eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_NPREQ_LINE_ATTRS_TMP

Line 13: FROM qp_npreq_line_attrs_tmp

9: x_return_status OUT NOCOPY VARCHAR2,
10: x_return_status_txt OUT NOCOPY VARCHAR2) IS
11: CURSOR determine_context_cur IS
12: SELECT CONTEXT , ATTRIBUTE
13: FROM qp_npreq_line_attrs_tmp
14: WHERE LINE_INDEX = p_line_index
15: AND ATTRIBUTE_TYPE = qp_preq_grp.G_PRICING_TYPE
16: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW
17: AND LIST_HEADER_ID = p_list_header_id

Line 23: FROM qp_npreq_line_attrs_tmp a

19: AND CONTEXT = qp_preq_grp.G_PRIC_VOLUME_CONTEXT;
20:
21: /*CURSOR get_total_qty_cur(p_pricing_attribute VARCHAR2) IS
22: SELECT a.VALUE_FROM,a.GROUP_QUANTITY,a.GROUP_AMOUNT
23: FROM qp_npreq_line_attrs_tmp a
24: WHERE a.LINE_INDEX = p_line_index
25: AND a.CONTEXT = qp_preq_grp.G_PRIC_VOLUME_CONTEXT
26: AND a.ATTRIBUTE = p_pricing_attribute
27: AND a.ATTRIBUTE_TYPE = qp_preq_grp.G_PRICING_TYPE

Line 39: FROM qp_npreq_line_attrs_tmp a , qp_npreq_ldets_tmp b

35: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;
36:
37: CURSOR get_base_qty_cur(p_pricing_attribute VARCHAR2) IS
38: SELECT a.SETUP_VALUE_FROM , b.CREATED_FROM_LIST_LINE_TYPE,b.OPERAND_VALUE,b.BENEFIT_QTY
39: FROM qp_npreq_line_attrs_tmp a , qp_npreq_ldets_tmp b
40: WHERE a.LINE_INDEX = p_line_index
41: AND a.LINE_INDEX = b.LINE_INDEX
42: AND a.LIST_LINE_ID = b.CREATED_FROM_LIST_LINE_ID
43: AND a.CONTEXT = qp_preq_grp.G_PRIC_VOLUME_CONTEXT

Line 294: -- Insert a line into qp_npreq_line_attrs_tmp

290: -- Insert a line into qp_npreq_rltd_lines_tmp
291: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line
292:
293: -- Insert a line into qp_npreq_rltd_lines_tmp
294: -- Insert a line into qp_npreq_line_attrs_tmp
295:
296:
297: CURSOR get_related_modifier_id_cur IS
298: SELECT distinct a.PRICE_BREAK_TYPE_CODE , b.FROM_RLTD_MODIFIER_ID,b.TO_RLTD_MODIFIER_ID,c.LINE_DETAIL_INDEX ,

Line 710: -- Insert into Line Attributes table qp_npreq_line_attrs_tmp

706: IF l_debug = FND_API.G_TRUE THEN
707: qp_preq_grp.engine_debug('New Related Line Detail-Line Detail Created');
708: END IF;
709:
710: -- Insert into Line Attributes table qp_npreq_line_attrs_tmp
711: INSERT INTO qp_npreq_line_attrs_tmp
712: (LIST_LINE_ID
713: ,LINE_INDEX
714: ,line_detail_index

Line 711: INSERT INTO qp_npreq_line_attrs_tmp

707: qp_preq_grp.engine_debug('New Related Line Detail-Line Detail Created');
708: END IF;
709:
710: -- Insert into Line Attributes table qp_npreq_line_attrs_tmp
711: INSERT INTO qp_npreq_line_attrs_tmp
712: (LIST_LINE_ID
713: ,LINE_INDEX
714: ,line_detail_index
715: ,CONTEXT

Line 756: UPDATE qp_npreq_line_attrs_tmp

752: AND CREATED_FROM_LIST_LINE_ID = p_list_line_id
753: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;
754:
755: -- This statement can be commented out
756: UPDATE qp_npreq_line_attrs_tmp
757: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
758: WHERE LINE_INDEX = p_line_index
759: AND LIST_LINE_ID = p_list_line_id
760: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;

Line 792: -- Insert a line into qp_npreq_line_attrs_tmp

788: -- Insert a line into qp_npreq_rltd_lines_tmp
789: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line
790:
791: -- Insert a line into qp_npreq_rltd_lines_tmp
792: -- Insert a line into qp_npreq_line_attrs_tmp
793:
794:
795: CURSOR get_related_modifier_id_cur IS
796: SELECT distinct a.LIST_LINE_TYPE_CODE,b.FROM_RLTD_MODIFIER_ID,b.TO_RLTD_MODIFIER_ID , c.LINE_DETAIL_INDEX,

Line 829: FROM qp_npreq_lines_tmp b , qp_npreq_line_attrs_tmp a

825: index(b qp_preq_lines_tmp_n2)
826: index(a qp_preq_line_attrs_tmp_n2)
827: get_benefit_line_index_cur */
828: distinct a.LINE_INDEX,nvl(b.PRICED_QUANTITY,b.LINE_QUANTITY) LINE_QUANTITY
829: FROM qp_npreq_lines_tmp b , qp_npreq_line_attrs_tmp a
830: WHERE a.LINE_INDEX = b.LINE_INDEX
831: AND a.CONTEXT = p_context
832: AND a.ATTRIBUTE = p_attribute
833: AND a.VALUE_FROM = p_value

Line 923: /* UPDATE qp_npreq_line_attrs_tmp

919: AND CREATED_FROM_LIST_LINE_ID = j.FROM_RLTD_MODIFIER_ID
920: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;
921:
922: --This statement is not needed
923: /* UPDATE qp_npreq_line_attrs_tmp
924: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
925: WHERE LIST_LINE_ID = j.FROM_RLTD_MODIFIER_ID
926: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW; */
927:

Line 1050: /* UPDATE qp_npreq_line_attrs_tmp

1046: AND CREATED_FROM_LIST_LINE_ID = p_list_line_id
1047: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;
1048:
1049: -- This statement is not needed
1050: /* UPDATE qp_npreq_line_attrs_tmp
1051: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1052: WHERE LINE_INDEX = p_line_index
1053: AND LIST_LINE_ID = p_list_line_id
1054: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;

Line 1109: FROM qp_npreq_line_attrs_tmp b,

1105: AND EXISTS
1106: (SELECT /*+ ORDERED NO_UNNEST index(b qp_preq_line_attrs_tmp_n2)
1107: index(a qp_preq_lines_tmp_u1)
1108: index(d qp_preq_lines_tmp_u1) */ 'X'
1109: FROM qp_npreq_line_attrs_tmp b,
1110: qp_npreq_lines_tmp a,
1111: qp_npreq_lines_tmp d
1112: WHERE b.CONTEXT = c.PRODUCT_ATTRIBUTE_CONTEXT
1113: AND b.ATTRIBUTE = c.PRODUCT_ATTRIBUTE

Line 1134: FROM qp_npreq_line_attrs_tmp b,

1130: (SELECT /*+ ORDERED NO_UNNEST index(b qp_preq_line_attrs_n2)
1131: index(d qp_preq_lines_tmp_u1)
1132: index(c qp_preq_line_attrs_tmp_n2)
1133: index(e qp_preq_lines_tmp_u1) */ 'X'
1134: FROM qp_npreq_line_attrs_tmp b,
1135: qp_npreq_lines_tmp d,
1136: qp_npreq_line_attrs_tmp c,
1137: qp_npreq_lines_tmp e
1138: WHERE b.CONTEXT = a.PRODUCT_ATTRIBUTE_CONTEXT

Line 1136: qp_npreq_line_attrs_tmp c,

1132: index(c qp_preq_line_attrs_tmp_n2)
1133: index(e qp_preq_lines_tmp_u1) */ 'X'
1134: FROM qp_npreq_line_attrs_tmp b,
1135: qp_npreq_lines_tmp d,
1136: qp_npreq_line_attrs_tmp c,
1137: qp_npreq_lines_tmp e
1138: WHERE b.CONTEXT = a.PRODUCT_ATTRIBUTE_CONTEXT
1139: AND b.ATTRIBUTE = a.PRODUCT_ATTRIBUTE
1140: AND b.VALUE_FROM = a.PRODUCT_ATTR_VALUE

Line 1272: /* UPDATE qp_npreq_line_attrs_tmp a

1268: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1269: WHERE CREATED_FROM_LIST_LINE_ID = p_list_line_id;
1270:
1271: -- This statement is not needed
1272: /* UPDATE qp_npreq_line_attrs_tmp a
1273: SET a.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1274: WHERE a.LINE_DETAIL_INDEX IN (SELECT b.LINE_DETAIL_INDEX
1275: FROM qp_npreq_ldets_tmp b
1276: WHERE b.CREATED_FROM_LIST_LINE_ID = p_list_line_id); */

Line 1396: /* UPDATE qp_npreq_line_attrs_tmp

1392: AND CREATED_FROM_LIST_LINE_ID = i.CREATED_FROM_LIST_LINE_ID
1393: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;
1394:
1395: -- This statement is not needed
1396: /* UPDATE qp_npreq_line_attrs_tmp
1397: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1398: WHERE LIST_LINE_ID = i.CREATED_FROM_LIST_LINE_ID
1399: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW; */
1400: END IF;