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 298: -- Insert a line into qp_npreq_line_attrs_tmp

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

Line 750: -- Insert into Line Attributes table qp_npreq_line_attrs_tmp

746: IF l_debug = FND_API.G_TRUE THEN
747: qp_preq_grp.engine_debug('New Related Line Detail-Line Detail Created');
748: END IF;
749:
750: -- Insert into Line Attributes table qp_npreq_line_attrs_tmp
751: INSERT INTO qp_npreq_line_attrs_tmp
752: (LIST_LINE_ID
753: ,LINE_INDEX
754: ,line_detail_index

Line 751: INSERT INTO qp_npreq_line_attrs_tmp

747: qp_preq_grp.engine_debug('New Related Line Detail-Line Detail Created');
748: END IF;
749:
750: -- Insert into Line Attributes table qp_npreq_line_attrs_tmp
751: INSERT INTO qp_npreq_line_attrs_tmp
752: (LIST_LINE_ID
753: ,LINE_INDEX
754: ,line_detail_index
755: ,CONTEXT

Line 796: UPDATE qp_npreq_line_attrs_tmp

792: AND CREATED_FROM_LIST_LINE_ID = p_list_line_id
793: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;
794:
795: -- This statement can be commented out
796: UPDATE qp_npreq_line_attrs_tmp
797: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
798: WHERE LINE_INDEX = p_line_index
799: AND LIST_LINE_ID = p_list_line_id
800: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;

Line 832: -- Insert a line into qp_npreq_line_attrs_tmp

828: -- Insert a line into qp_npreq_rltd_lines_tmp
829: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line
830:
831: -- Insert a line into qp_npreq_rltd_lines_tmp
832: -- Insert a line into qp_npreq_line_attrs_tmp
833:
834:
835: CURSOR get_related_modifier_id_cur IS
836: SELECT distinct a.LIST_LINE_TYPE_CODE,b.FROM_RLTD_MODIFIER_ID,b.TO_RLTD_MODIFIER_ID , c.LINE_DETAIL_INDEX,

Line 869: FROM qp_npreq_lines_tmp b , qp_npreq_line_attrs_tmp a

865: index(b qp_preq_lines_tmp_n2)
866: index(a qp_preq_line_attrs_tmp_n2)
867: get_benefit_line_index_cur */
868: distinct a.LINE_INDEX,nvl(b.PRICED_QUANTITY,b.LINE_QUANTITY) LINE_QUANTITY
869: FROM qp_npreq_lines_tmp b , qp_npreq_line_attrs_tmp a
870: WHERE a.LINE_INDEX = b.LINE_INDEX
871: AND a.CONTEXT = p_context
872: AND a.ATTRIBUTE = p_attribute
873: AND a.VALUE_FROM = p_value

Line 963: /* UPDATE qp_npreq_line_attrs_tmp

959: AND CREATED_FROM_LIST_LINE_ID = j.FROM_RLTD_MODIFIER_ID
960: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;
961:
962: --This statement is not needed
963: /* UPDATE qp_npreq_line_attrs_tmp
964: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
965: WHERE LIST_LINE_ID = j.FROM_RLTD_MODIFIER_ID
966: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW; */
967:

Line 1090: /* UPDATE qp_npreq_line_attrs_tmp

1086: AND CREATED_FROM_LIST_LINE_ID = p_list_line_id
1087: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;
1088:
1089: -- This statement is not needed
1090: /* UPDATE qp_npreq_line_attrs_tmp
1091: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1092: WHERE LINE_INDEX = p_line_index
1093: AND LIST_LINE_ID = p_list_line_id
1094: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;

Line 1149: FROM qp_npreq_line_attrs_tmp b,

1145: AND EXISTS
1146: (SELECT /*+ ORDERED NO_UNNEST index(b qp_preq_line_attrs_tmp_n2)
1147: index(a qp_preq_lines_tmp_u1)
1148: index(d qp_preq_lines_tmp_u1) */ 'X'
1149: FROM qp_npreq_line_attrs_tmp b,
1150: qp_npreq_lines_tmp a,
1151: qp_npreq_lines_tmp d
1152: WHERE b.CONTEXT = c.PRODUCT_ATTRIBUTE_CONTEXT
1153: AND b.ATTRIBUTE = c.PRODUCT_ATTRIBUTE

Line 1174: FROM qp_npreq_line_attrs_tmp b,

1170: (SELECT /*+ ORDERED NO_UNNEST index(b qp_preq_line_attrs_n2)
1171: index(d qp_preq_lines_tmp_u1)
1172: index(c qp_preq_line_attrs_tmp_n2)
1173: index(e qp_preq_lines_tmp_u1) */ 'X'
1174: FROM qp_npreq_line_attrs_tmp b,
1175: qp_npreq_lines_tmp d,
1176: qp_npreq_line_attrs_tmp c,
1177: qp_npreq_lines_tmp e
1178: WHERE b.CONTEXT = a.PRODUCT_ATTRIBUTE_CONTEXT

Line 1176: qp_npreq_line_attrs_tmp c,

1172: index(c qp_preq_line_attrs_tmp_n2)
1173: index(e qp_preq_lines_tmp_u1) */ 'X'
1174: FROM qp_npreq_line_attrs_tmp b,
1175: qp_npreq_lines_tmp d,
1176: qp_npreq_line_attrs_tmp c,
1177: qp_npreq_lines_tmp e
1178: WHERE b.CONTEXT = a.PRODUCT_ATTRIBUTE_CONTEXT
1179: AND b.ATTRIBUTE = a.PRODUCT_ATTRIBUTE
1180: AND b.VALUE_FROM = a.PRODUCT_ATTR_VALUE

Line 1312: /* UPDATE qp_npreq_line_attrs_tmp a

1308: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1309: WHERE CREATED_FROM_LIST_LINE_ID = p_list_line_id;
1310:
1311: -- This statement is not needed
1312: /* UPDATE qp_npreq_line_attrs_tmp a
1313: SET a.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1314: WHERE a.LINE_DETAIL_INDEX IN (SELECT b.LINE_DETAIL_INDEX
1315: FROM qp_npreq_ldets_tmp b
1316: WHERE b.CREATED_FROM_LIST_LINE_ID = p_list_line_id); */

Line 1436: /* UPDATE qp_npreq_line_attrs_tmp

1432: AND CREATED_FROM_LIST_LINE_ID = i.CREATED_FROM_LIST_LINE_ID
1433: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;
1434:
1435: -- This statement is not needed
1436: /* UPDATE qp_npreq_line_attrs_tmp
1437: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1438: WHERE LIST_LINE_ID = i.CREATED_FROM_LIST_LINE_ID
1439: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW; */
1440: END IF;