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

Line 10: l_accum_context_cache QP_LIST_LINES.ACCUM_CONTEXT%TYPE; -- accum range break

6: l_prev_list_line_id NUMBER; -- accum range break
7: l_accum_global NUMBER; -- accum range break
8: l_prev_order_id NUMBER; -- accum range break
9: l_prev_line_index NUMBER; -- accum range break
10: l_accum_context_cache QP_LIST_LINES.ACCUM_CONTEXT%TYPE; -- accum range break
11: l_accum_attrib_cache QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE; -- accum range break
12: l_accum_flag_cache QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE; -- accum range break
13: l_accum_list_line_no_cache QP_LIST_LINES.LIST_LINE_NO%TYPE; -- accum range break
14:

Line 11: l_accum_attrib_cache QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE; -- accum range break

7: l_accum_global NUMBER; -- accum range break
8: l_prev_order_id NUMBER; -- accum range break
9: l_prev_line_index NUMBER; -- accum range break
10: l_accum_context_cache QP_LIST_LINES.ACCUM_CONTEXT%TYPE; -- accum range break
11: l_accum_attrib_cache QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE; -- accum range break
12: l_accum_flag_cache QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE; -- accum range break
13: l_accum_list_line_no_cache QP_LIST_LINES.LIST_LINE_NO%TYPE; -- accum range break
14:
15:

Line 12: l_accum_flag_cache QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE; -- accum range break

8: l_prev_order_id NUMBER; -- accum range break
9: l_prev_line_index NUMBER; -- accum range break
10: l_accum_context_cache QP_LIST_LINES.ACCUM_CONTEXT%TYPE; -- accum range break
11: l_accum_attrib_cache QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE; -- accum range break
12: l_accum_flag_cache QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE; -- accum range break
13: l_accum_list_line_no_cache QP_LIST_LINES.LIST_LINE_NO%TYPE; -- accum range break
14:
15:
16: --4900095

Line 13: l_accum_list_line_no_cache QP_LIST_LINES.LIST_LINE_NO%TYPE; -- accum range break

9: l_prev_line_index NUMBER; -- accum range break
10: l_accum_context_cache QP_LIST_LINES.ACCUM_CONTEXT%TYPE; -- accum range break
11: l_accum_attrib_cache QP_LIST_LINES.ACCUM_ATTRIBUTE%TYPE; -- accum range break
12: l_accum_flag_cache QP_LIST_LINES.ACCUM_ATTR_RUN_SRC_FLAG%TYPE; -- accum range break
13: l_accum_list_line_no_cache QP_LIST_LINES.LIST_LINE_NO%TYPE; -- accum range break
14:
15:
16: --4900095
17: G_Lumpsum_Qty NUMBER;

Line 704: FROM qp_list_lines

700:
701: -- 4061138, 5183755 continuous price breaks
702: CURSOR get_continuous_flag_cur IS
703: SELECT nvl(continuous_price_break_flag, 'N')
704: FROM qp_list_lines
705: WHERE list_line_id = p_list_line_id;
706:
707: l_continuous_flag VARCHAR2(1) := 'N';
708: l_prorated_flag VARCHAR2(1) := 'N';

Line 1462: v_list_line_no QP_LIST_LINES.LIST_LINE_NO%TYPE;

1458: l_accum NUMBER; -- accumulated value
1459: l_accum_context VARCHAR2(30);
1460: l_accum_attrib VARCHAR2(240);
1461: l_accum_flag VARCHAR2(1);
1462: v_list_line_no QP_LIST_LINES.LIST_LINE_NO%TYPE;
1463: v_price_eff_date DATE;
1464: v_line_id NUMBER;
1465: l_req_attrs_tbl QP_RUNTIME_SOURCE.accum_req_line_attrs_tbl;
1466: l_accum_rec QP_RUNTIME_SOURCE.accum_record_type;

Line 1534: FROM qp_list_lines

1530: ELSE
1531: BEGIN
1532: SELECT accum_context, accum_attribute, accum_attr_run_src_flag, list_line_no
1533: INTO l_accum_context, l_accum_attrib, l_accum_flag, v_list_line_no
1534: FROM qp_list_lines
1535: WHERE list_line_id = p_list_line_id;
1536: -- from qp_npreq_ldets_tmp
1537: -- where created_from_list_line_id = p_list_line_id
1538: -- and rownum = 1;

Line 1872: FROM qp_list_lines qpll, qp_npreq_rltd_lines_tmp rltd

1868:
1869: -- 4061138, 5183755 continuous price breaks
1870: CURSOR get_continuous_flag_cur IS
1871: SELECT nvl(qpll.continuous_price_break_flag, 'N')
1872: FROM qp_list_lines qpll, qp_npreq_rltd_lines_tmp rltd
1873: WHERE rltd.line_index = p_line_index
1874: AND rltd.line_detail_index = p_list_line_id
1875: AND rltd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1876: AND rltd.list_line_id = qpll.list_line_id

Line 2347: FROM qp_list_lines

2343:
2344: -- 4061138, 5183755 continuous price breaks
2345: CURSOR get_continuous_flag_cur IS
2346: SELECT nvl(continuous_price_break_flag, 'N')
2347: FROM qp_list_lines
2348: WHERE QP_PREQ_GRP.G_PUBLIC_API_CALL_FLAG = QP_PREQ_GRP.G_NO
2349: AND list_line_id = p_list_line_id
2350: AND ROWNUM = 1
2351: UNION

Line 2353: FROM qp_list_lines qpll, qp_npreq_rltd_lines_tmp rltd

2349: AND list_line_id = p_list_line_id
2350: AND ROWNUM = 1
2351: UNION
2352: SELECT nvl(qpll.continuous_price_break_flag, 'N')
2353: FROM qp_list_lines qpll, qp_npreq_rltd_lines_tmp rltd
2354: WHERE QP_PREQ_GRP.G_PUBLIC_API_CALL_FLAG = QP_PREQ_GRP.G_YES
2355: AND rltd.line_index = p_line_index
2356: AND rltd.line_detail_index = p_list_line_id
2357: AND rltd.list_line_id = qpll.list_line_id

Line 2609: qp_npreq_line_attrs_tmp a, QP_PRICING_ATTRIBUTES b, QP_LIST_LINES c, QP_LIST_HEADERS_B d, QP_QUALIFIERS e

2605:
2606: CURSOR get_list_details_cur(p_source_system_code VARCHAR2) IS
2607: SELECT /*+ ORDERED USE_NL(a b c d e) */ c.LIST_LINE_ID, c.OPERAND
2608: FROM
2609: qp_npreq_line_attrs_tmp a, QP_PRICING_ATTRIBUTES b, QP_LIST_LINES c, QP_LIST_HEADERS_B d, QP_QUALIFIERS e
2610: WHERE a.LINE_INDEX = p_line_index
2611: AND a.CONTEXT = b.PRODUCT_ATTRIBUTE_CONTEXT
2612: AND a.ATTRIBUTE = b.PRODUCT_ATTRIBUTE
2613: AND a.VALUE_FROM = b.PRODUCT_ATTR_VALUE