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_LINES_TMP

Line 289: -- Insert a line into the qp_npreq_lines_tmp table for the other item

285: x_return_status OUT NOCOPY VARCHAR2,
286: x_return_status_txt OUT NOCOPY VARCHAR2) AS
287:
288: -- Get the Related Modifier id from qp_rltd_modifiers table
289: -- Insert a line into the qp_npreq_lines_tmp table for the other item
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

Line 338: FROM qp_npreq_lines_tmp

334: AND a.ARITHMETIC_OPERATOR = qp_preq_grp.G_UNIT_PRICE;
335:
336: CURSOR get_request_type_code_cur IS
337: SELECT REQUEST_TYPE_CODE
338: FROM qp_npreq_lines_tmp
339: WHERE LINE_INDEX = p_line_index;
340:
341: CURSOR get_max_line_index_cur IS
342: SELECT MAX(LINE_INDEX)

Line 343: FROM qp_npreq_lines_tmp;

339: WHERE LINE_INDEX = p_line_index;
340:
341: CURSOR get_max_line_index_cur IS
342: SELECT MAX(LINE_INDEX)
343: FROM qp_npreq_lines_tmp;
344:
345: --removed rownum=1 spgopal to create relation for multiple buys/gets
346: --for linegroup prg against each qualified line
347: CURSOR get_rltd_line_detail_index IS

Line 351: -- qp_npreq_lines_tmp to check the process_status for string FREEGOOD

347: CURSOR get_rltd_line_detail_index IS
348: -- Bug 2979447 - also selected related_list_line_id needed by order capture
349: -- Bug 2998770 - removed LINE_INDEX and also added distinct, code merged from trunk version 115.66
350: -- Bug 3074630 - ignore the relationships passed by calling application for free good line, join to
351: -- qp_npreq_lines_tmp to check the process_status for string FREEGOOD
352: --SELECT RELATED_LINE_DETAIL_INDEX,LINE_INDEX,RELATED_LINE_INDEX
353: SELECT distinct RELATED_LINE_DETAIL_INDEX,RELATED_LINE_INDEX -- fix bug 2998770
354: ,related_list_line_id -- bug 2979447
355: FROM qp_npreq_rltd_lines_tmp a, qp_npreq_lines_tmp b

Line 355: FROM qp_npreq_rltd_lines_tmp a, qp_npreq_lines_tmp b

351: -- qp_npreq_lines_tmp to check the process_status for string FREEGOOD
352: --SELECT RELATED_LINE_DETAIL_INDEX,LINE_INDEX,RELATED_LINE_INDEX
353: SELECT distinct RELATED_LINE_DETAIL_INDEX,RELATED_LINE_INDEX -- fix bug 2998770
354: ,related_list_line_id -- bug 2979447
355: FROM qp_npreq_rltd_lines_tmp a, qp_npreq_lines_tmp b
356: WHERE a.LIST_LINE_ID = p_list_line_id
357: AND b.line_index = a.related_line_index
358: AND (instr(b.PROCESS_STATUS,'FREEGOOD')=0)
359: AND a.RELATIONSHIP_TYPE_CODE = qp_preq_grp.G_GENERATED_LINE

Line 521: INSERT INTO qp_npreq_lines_tmp

517: v_benefit_exists := TRUE;
518:
519: -- begin shu, side fix bug 2491158,
520: -- insert price_list_header_id for generated line
521: INSERT INTO qp_npreq_lines_tmp
522: (LINE_INDEX
523: , PRICE_LIST_HEADER_ID
524: , LINE_TYPE_CODE
525: , PRICING_EFFECTIVE_DATE

Line 564: FROM qp_npreq_lines_tmp

560: , v_rounding_factor
561: , qp_preq_grp.G_YES
562: , qp_preq_grp.G_STATUS_NEW
563: , LINE_CATEGORY
564: FROM qp_npreq_lines_tmp
565: WHERE LINE_INDEX = p_line_index;
566:
567: IF l_debug = FND_API.G_TRUE THEN
568: qp_preq_grp.engine_debug('New Line Created');

Line 787: -- Insert a line into the qp_npreq_lines_tmp table for the other item

783: x_return_status OUT NOCOPY VARCHAR2,
784: x_return_status_txt OUT NOCOPY VARCHAR2) AS
785:
786: -- Get the Related Modifier id from qp_rltd_modifiers table
787: -- Insert a line into the qp_npreq_lines_tmp table for the other item
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

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 845: FROM qp_npreq_lines_tmp

841: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW);
842:
843: CURSOR get_request_type_code_cur IS
844: SELECT REQUEST_TYPE_CODE
845: FROM qp_npreq_lines_tmp
846: WHERE LINE_INDEX = p_line_index;
847:
848: v_detail_line_index NUMBER;
849: v_other_item_list_price NUMBER;

Line 1110: qp_npreq_lines_tmp a,

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
1114: AND b.VALUE_FROM = c.PRODUCT_ATTR_VALUE

Line 1111: qp_npreq_lines_tmp d

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
1114: AND b.VALUE_FROM = c.PRODUCT_ATTR_VALUE
1115: AND b.ATTRIBUTE_TYPE = qp_preq_grp.G_PRODUCT_TYPE

Line 1135: qp_npreq_lines_tmp d,

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
1139: AND b.ATTRIBUTE = a.PRODUCT_ATTRIBUTE

Line 1137: qp_npreq_lines_tmp e

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
1141: AND b.ATTRIBUTE_TYPE = qp_preq_grp.G_PRODUCT_TYPE