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 293: -- Insert a line into the qp_npreq_lines_tmp table for the other item

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

Line 343: FROM qp_npreq_lines_tmp

339: AND a.LIST_HEADER_ID = b.LIST_HEADER_ID;
340:
341: CURSOR get_request_type_code_cur IS
342: SELECT REQUEST_TYPE_CODE
343: FROM qp_npreq_lines_tmp
344: WHERE LINE_INDEX = p_line_index;
345:
346: --service project
347: CURSOR get_parent_list_price_cur IS

Line 349: FROM qp_npreq_lines_tmp

345:
346: --service project
347: CURSOR get_parent_list_price_cur IS
348: SELECT UNIT_PRICE
349: FROM qp_npreq_lines_tmp
350: WHERE LINE_INDEX = p_line_index;
351: --service project
352:
353: CURSOR get_max_line_index_cur IS

Line 355: FROM qp_npreq_lines_tmp;

351: --service project
352:
353: CURSOR get_max_line_index_cur IS
354: SELECT MAX(LINE_INDEX)
355: FROM qp_npreq_lines_tmp;
356:
357: --removed rownum=1 spgopal to create relation for multiple buys/gets
358: --for linegroup prg against each qualified line
359: CURSOR get_rltd_line_detail_index IS

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

359: CURSOR get_rltd_line_detail_index IS
360: -- Bug 2979447 - also selected related_list_line_id needed by order capture
361: -- Bug 2998770 - removed LINE_INDEX and also added distinct, code merged from trunk version 115.66
362: -- Bug 3074630 - ignore the relationships passed by calling application for free good line, join to
363: -- qp_npreq_lines_tmp to check the process_status for string FREEGOOD
364: --SELECT RELATED_LINE_DETAIL_INDEX,LINE_INDEX,RELATED_LINE_INDEX
365: SELECT distinct RELATED_LINE_DETAIL_INDEX,RELATED_LINE_INDEX -- fix bug 2998770
366: ,related_list_line_id -- bug 2979447
367: FROM qp_npreq_rltd_lines_tmp a, qp_npreq_lines_tmp b

Line 367: FROM qp_npreq_rltd_lines_tmp a, qp_npreq_lines_tmp b

363: -- qp_npreq_lines_tmp to check the process_status for string FREEGOOD
364: --SELECT RELATED_LINE_DETAIL_INDEX,LINE_INDEX,RELATED_LINE_INDEX
365: SELECT distinct RELATED_LINE_DETAIL_INDEX,RELATED_LINE_INDEX -- fix bug 2998770
366: ,related_list_line_id -- bug 2979447
367: FROM qp_npreq_rltd_lines_tmp a, qp_npreq_lines_tmp b
368: WHERE a.LIST_LINE_ID = p_list_line_id
369: AND b.line_index = a.related_line_index
370: AND (instr(b.PROCESS_STATUS,'FREEGOOD')=0)
371: AND a.RELATIONSHIP_TYPE_CODE = qp_preq_grp.G_GENERATED_LINE

Line 557: INSERT INTO qp_npreq_lines_tmp

553: v_benefit_exists := TRUE;
554:
555: -- begin shu, side fix bug 2491158,
556: -- insert price_list_header_id for generated line
557: INSERT INTO qp_npreq_lines_tmp
558: (LINE_INDEX
559: , PRICE_LIST_HEADER_ID
560: , LINE_TYPE_CODE
561: , PRICING_EFFECTIVE_DATE

Line 604: FROM qp_npreq_lines_tmp

600: , v_rounding_factor
601: , qp_preq_grp.G_YES
602: , qp_preq_grp.G_STATUS_NEW
603: , LINE_CATEGORY
604: FROM qp_npreq_lines_tmp
605: WHERE LINE_INDEX = p_line_index;
606:
607: IF l_debug = FND_API.G_TRUE THEN
608: qp_preq_grp.engine_debug('New Line Created');

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

823: x_return_status OUT NOCOPY VARCHAR2,
824: x_return_status_txt OUT NOCOPY VARCHAR2) AS
825:
826: -- Get the Related Modifier id from qp_rltd_modifiers table
827: -- Insert a line into the qp_npreq_lines_tmp table for the other item
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

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

881: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW);
882:
883: CURSOR get_request_type_code_cur IS
884: SELECT REQUEST_TYPE_CODE
885: FROM qp_npreq_lines_tmp
886: WHERE LINE_INDEX = p_line_index;
887:
888: v_detail_line_index NUMBER;
889: v_other_item_list_price NUMBER;

Line 1150: qp_npreq_lines_tmp a,

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

Line 1151: qp_npreq_lines_tmp d

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

Line 1175: qp_npreq_lines_tmp d,

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

Line 1177: qp_npreq_lines_tmp e

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