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_PREQ_PUB dependencies on QP_LIST_LINES

Line 287: qp_list_lines qpl WHERE qpl.list_line_id = to_number(attr.value_from))

283: --fix for bug 2374591 ask for promotions not getting applied
284: --updating the list_header_id in the attribute where list_line_id is passed
285: UPDATE qp_npreq_line_attrs_tmp attr SET attr.list_header_id =
286: (SELECT qpl.list_header_id FROM
287: qp_list_lines qpl WHERE qpl.list_line_id = to_number(attr.value_from))
288: WHERE attr.context = 'MODLIST'
289: AND attribute = 'QUALIFIER_ATTRIBUTE2'
290: AND pricing_status_code = 'X';
291:

Line 792: p_list_line_type_code IN QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE

788: null;
789: END Determine_svc_item_quantity;
790:
791: PROCEDURE CALCULATE_BUCKET_PRICE(
792: p_list_line_type_code IN QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE
793: , p_price IN NUMBER
794: , p_priced_quantity NUMBER := 1
795: , p_operand_calculation_code IN QP_LIST_LINES.ARITHMETIC_OPERATOR%TYPE
796: , p_operand_value IN NUMBER

Line 795: , p_operand_calculation_code IN QP_LIST_LINES.ARITHMETIC_OPERATOR%TYPE

791: PROCEDURE CALCULATE_BUCKET_PRICE(
792: p_list_line_type_code IN QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE
793: , p_price IN NUMBER
794: , p_priced_quantity NUMBER := 1
795: , p_operand_calculation_code IN QP_LIST_LINES.ARITHMETIC_OPERATOR%TYPE
796: , p_operand_value IN NUMBER
797: , x_calc_adjustment OUT NOCOPY NUMBER
798: , x_return_status OUT NOCOPY VARCHAR2 --DEFAULT FND_API.G_RET_STS_SUCCESS
799: , x_return_status_text OUT NOCOPY VARCHAR2)

Line 2878: qp_list_lines ql

2874: qp_price_req_sources req,
2875: qp_list_headers_b lhdr,
2876: qp_npreq_line_attrs_tmp lattr,
2877: qp_pricing_attributes qpa,
2878: qp_list_lines ql
2879: WHERE lattr.line_index = line.line_index
2880: AND lattr.pricing_status_code IN
2881: (G_STATUS_NEW, G_STATUS_UNCHANGED)
2882: AND lattr.attribute_type = G_PRODUCT_TYPE

Line 2923: qp_list_lines ql

2919: qp_price_req_sources_v req,
2920: qp_list_headers_b lhdr,
2921: qp_npreq_line_attrs_tmp lattr,
2922: qp_pricing_attributes qpa,
2923: qp_list_lines ql
2924: WHERE lattr.line_index = line.line_index
2925: AND lattr.pricing_status_code IN
2926: (G_STATUS_NEW, G_STATUS_UNCHANGED)
2927: AND lattr.attribute_type = G_PRODUCT_TYPE

Line 4204: FROM qp_list_lines

4200: WHERE pricing_status_code = G_STATUS_NEW;
4201:
4202: CURSOR l_net_amount_flag_cur (p_list_line_id NUMBER) IS
4203: SELECT net_amount_flag
4204: FROM qp_list_lines
4205: WHERE list_line_id = p_list_line_id;
4206:
4207:
4208: Calculate_Exc EXCEPTION;

Line 4560: -- obtain net_adj_amount_flag from qp_list_lines table if null,

4556: WHILE J IS NOT NULL
4557: LOOP
4558:
4559: -- begin 2892848
4560: -- obtain net_adj_amount_flag from qp_list_lines table if null,
4561: -- since it may not be passed from calling application
4562: IF l_adj_tbl(j).net_amount_flag IS NULL THEN -- get it from setup just in case
4563: OPEN l_net_amount_flag_cur(l_adj_tbl(j).created_from_list_line_id);
4564: FETCH l_net_amount_flag_cur INTO l_adj_tbl(j).net_amount_flag;

Line 5366: -- obtain net_adj_amount_flag from qp_list_lines table if null,

5362: END IF; --G_pbhvolattr_attribute.exists
5363: END IF; --modifier level code
5364:
5365: /* out 2892848
5366: -- obtain net_adj_amount_flag from qp_list_lines table if null,
5367: -- since it may not be passed from calling application
5368: -- net_amount_new 2720717
5369: IF l_adj_tbl(j).net_amount_flag IS NULL THEN
5370: OPEN l_net_amount_flag_cur(l_adj_tbl(j).created_from_list_line_id);

Line 7275: FROM qp_list_lines

7271:
7272: -- net_amount 2720717
7273: CURSOR l_net_amount_flag_cur (p_list_line_id NUMBER) IS
7274: SELECT net_amount_flag
7275: FROM qp_list_lines
7276: WHERE list_line_id = p_list_line_id;
7277:
7278: l_bucket_price_rec l_bucket_price_cur%ROWTYPE;
7279: l_line_rec l_line_cur%ROWTYPE;

Line 7521: -- obtain net_adj_amount_flag from qp_list_lines table if null,

7517: EXIT WHEN l_bucket_price_cur%NOTFOUND;
7518:
7519: -- begin 2892848
7520: -- ASK PRIYA see if there is a way to tell if line is from calling application???
7521: -- obtain net_adj_amount_flag from qp_list_lines table if null,
7522: -- since it may not be passed from calling application
7523: IF l_bucket_price_rec.net_amount_flag IS NULL THEN -- get it from setup just in case
7524: OPEN l_net_amount_flag_cur(l_bucket_price_rec.created_from_list_line_id);
7525: FETCH l_net_amount_flag_cur INTO l_bucket_price_rec.net_amount_flag;

Line 8135: -- obtain net_adj_amount_flag from qp_list_lines table if null,

8131: || l_pbh_pricing_attr ||' l_total_value '|| l_total_value
8132: ||' l_req_value_per_unit '|| l_req_value_per_unit);
8133: END IF; --l_debug
8134:
8135: -- obtain net_adj_amount_flag from qp_list_lines table if null,
8136: -- since it may not be passed from calling application
8137: -- net_amount_new 2720717
8138: IF l_bucket_price_rec.net_amount_flag IS NULL THEN
8139: OPEN l_net_amount_flag_cur(l_bucket_price_rec.created_from_list_line_id);

Line 9129: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_LINES_PK,LIST_LINE_ID,1

9125: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_TYPE_CODE,3
9126: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,SOURCE_SYSTEM_CODE,4
9127: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,LIST_HEADER_ID,5
9128: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_HEADERS_B_N1,GSA_INDICATOR,6
9129: INDX,QP_PREQ_PUB.calculate_price.upd5,QP_LIST_LINES_PK,LIST_LINE_ID,1
9130: */
9131: IF l_debug = FND_API.G_TRUE THEN
9132: QP_PREQ_GRP.engine_debug('Pub GSA attr_mgr_installed '
9133: || G_ATTR_MGR_INSTALLED);

Line 9160: qp_list_lines ql

9156: FROM qp_npreq_line_attrs_tmp lattr,
9157: qp_pricing_attributes qpa,
9158: qp_list_headers_b lhdr, --7323912
9159: qp_price_req_sources req, --7323912
9160: qp_list_lines ql
9161: WHERE lattr.line_index = line.line_index
9162: AND lattr.attribute_type = G_PRODUCT_TYPE
9163: AND lattr.context = qpa.product_attribute_context
9164: AND lattr.attribute = qpa.product_attribute

Line 9214: qp_list_lines ql

9210: FROM qp_npreq_line_attrs_tmp lattr,
9211: qp_pricing_attributes qpa,
9212: qp_list_headers_b lhdr, --7323912
9213: qp_price_req_sources_v req, --7323912
9214: qp_list_lines ql
9215: WHERE lattr.line_index = line.line_index
9216: AND lattr.attribute_type = G_PRODUCT_TYPE
9217: AND lattr.context = qpa.product_attribute_context
9218: AND lattr.attribute = qpa.product_attribute

Line 12367: FROM qp_npreq_ldets_tmp ldet, qp_npreq_line_attrs_tmp lattr, qp_list_lines qpl

12363: , ldet.accrual_flag
12364: , qpl.accrual_conversion_rate
12365: , qpl.estim_accrual_rate
12366: -- , qpl.benefit_qty
12367: FROM qp_npreq_ldets_tmp ldet, qp_npreq_line_attrs_tmp lattr, qp_list_lines qpl
12368: WHERE ldet.pricing_phase_id > 1
12369: AND ldet.pricing_status_code = G_STATUS_NEW
12370: AND ldet.line_index > -1
12371: AND ldet.created_from_list_line_type IN ('DIS', 'SUR', 'FREIGHT_CHARGE',

Line 12518: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1

12514: ORDER_UOM_SELLING_PRICE
12515: FROM QP_INT_LINES;
12516:
12517: /*
12518: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
12519: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_INT_LDETS_N4,PRICING_STATUS_CODE,1
12520: INDX,QP_PREQ_GRP.populate_output_int.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
12521: */
12522: CURSOR l_ldets_cur(p_line_index NUMBER) IS

Line 12581: QP_LIST_LINES b

12577: b.COMMENTS,
12578: a.ORDER_QTY_OPERAND,
12579: a.ORDER_QTY_ADJ_AMT
12580: FROM QP_INT_LDETS a,
12581: QP_LIST_LINES b
12582: WHERE a.line_index = p_line_index
12583: AND a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
12584: AND a.PRICING_STATUS_CODE = G_STATUS_NEW;
12585:

Line 12758: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1

12754: ORDER_UOM_SELLING_PRICE
12755: FROM qp_npreq_lines_tmp;
12756:
12757: /*
12758: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
12759: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
12760: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
12761: */
12762: CURSOR l_ldets_cur(p_line_index NUMBER) IS

Line 12821: QP_LIST_LINES b

12817: b.COMMENTS,
12818: a.ORDER_QTY_OPERAND,
12819: a.ORDER_QTY_ADJ_AMT
12820: FROM qp_npreq_ldets_tmp a,
12821: QP_LIST_LINES b
12822: WHERE a.line_index = p_line_index
12823: AND a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
12824: AND a.PRICING_STATUS_CODE = G_STATUS_NEW;
12825:

Line 13024: QP_LIST_LINES A

13020: --3169430
13021: CURSOR modifier_exists IS
13022: SELECT 'X'
13023: FROM
13024: QP_LIST_LINES A
13025: WHERE A.PRICING_PHASE_ID >1
13026: AND modifier_level_code IN ('LINE', 'LINEGROUP', 'ORDER')
13027: AND ROWNUM = 1;
13028:

Line 14490: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_LINES_PK,LIST_LINE_ID,1

14486: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14487: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
14488: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
14489: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
14490: INDX,QP_PREQ_PUB.Raise_GSA_Error.sel2,QP_LIST_LINES_PK,LIST_LINE_ID,1
14491: */
14492: SELECT MIN(qpll.operand) INTO l_operand
14493: FROM
14494: QP_QUALIFIERS qpq,

Line 14496: QP_LIST_LINES qpll,

14492: SELECT MIN(qpll.operand) INTO l_operand
14493: FROM
14494: QP_QUALIFIERS qpq,
14495: QP_PRICING_ATTRIBUTES qppa,
14496: QP_LIST_LINES qpll,
14497: QP_LIST_HEADERS_B qplh,
14498: QP_PRICE_REQ_SOURCES_V qpprs
14499: WHERE
14500: qpq.qualifier_context = 'CUSTOMER' AND