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 712: FROM qp_list_lines

708:
709: -- 4061138, 5183755 continuous price breaks
710: CURSOR get_continuous_flag_cur IS
711: SELECT nvl(continuous_price_break_flag, 'N')
712: FROM qp_list_lines
713: WHERE list_line_id = p_list_line_id;
714:
715: l_continuous_flag VARCHAR2(1) := 'N';
716: l_prorated_flag VARCHAR2(1) := 'N';

Line 1470: v_list_line_no QP_LIST_LINES.LIST_LINE_NO%TYPE;

1466: l_accum NUMBER; -- accumulated value
1467: l_accum_context VARCHAR2(30);
1468: l_accum_attrib VARCHAR2(240);
1469: l_accum_flag VARCHAR2(1);
1470: v_list_line_no QP_LIST_LINES.LIST_LINE_NO%TYPE;
1471: v_price_eff_date DATE;
1472: v_line_id NUMBER;
1473: l_req_attrs_tbl QP_RUNTIME_SOURCE.accum_req_line_attrs_tbl;
1474: l_accum_rec QP_RUNTIME_SOURCE.accum_record_type;

Line 1542: FROM qp_list_lines

1538: ELSE
1539: BEGIN
1540: SELECT accum_context, accum_attribute, accum_attr_run_src_flag, list_line_no
1541: INTO l_accum_context, l_accum_attrib, l_accum_flag, v_list_line_no
1542: FROM qp_list_lines
1543: WHERE list_line_id = p_list_line_id;
1544: -- from qp_npreq_ldets_tmp
1545: -- where created_from_list_line_id = p_list_line_id
1546: -- and rownum = 1;

Line 1909: FROM qp_list_lines qpll, qp_npreq_rltd_lines_tmp rltd

1905:
1906: -- 4061138, 5183755 continuous price breaks
1907: CURSOR get_continuous_flag_cur IS
1908: SELECT nvl(qpll.continuous_price_break_flag, 'N')
1909: FROM qp_list_lines qpll, qp_npreq_rltd_lines_tmp rltd
1910: WHERE rltd.line_index = p_line_index
1911: AND rltd.line_detail_index = p_list_line_id
1912: AND rltd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1913: AND rltd.list_line_id = qpll.list_line_id

Line 2403: FROM qp_list_lines

2399:
2400: -- 4061138, 5183755 continuous price breaks
2401: CURSOR get_continuous_flag_cur IS
2402: SELECT nvl(continuous_price_break_flag, 'N')
2403: FROM qp_list_lines
2404: WHERE QP_PREQ_GRP.G_PUBLIC_API_CALL_FLAG = QP_PREQ_GRP.G_NO
2405: AND list_line_id = p_list_line_id
2406: AND ROWNUM = 1
2407: UNION

Line 2409: FROM qp_list_lines qpll, qp_npreq_rltd_lines_tmp rltd

2405: AND list_line_id = p_list_line_id
2406: AND ROWNUM = 1
2407: UNION
2408: SELECT nvl(qpll.continuous_price_break_flag, 'N')
2409: FROM qp_list_lines qpll, qp_npreq_rltd_lines_tmp rltd
2410: WHERE QP_PREQ_GRP.G_PUBLIC_API_CALL_FLAG = QP_PREQ_GRP.G_YES
2411: AND rltd.line_index = p_line_index
2412: AND rltd.line_detail_index = p_list_line_id
2413: AND rltd.list_line_id = qpll.list_line_id

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

2661:
2662: CURSOR get_list_details_cur(p_source_system_code VARCHAR2) IS
2663: SELECT /*+ ORDERED USE_NL(a b c d e) */ c.LIST_LINE_ID, c.OPERAND
2664: FROM
2665: qp_npreq_line_attrs_tmp a, QP_PRICING_ATTRIBUTES b, QP_LIST_LINES c, QP_LIST_HEADERS_B d, QP_QUALIFIERS e
2666: WHERE a.LINE_INDEX = p_line_index
2667: AND a.CONTEXT = b.PRODUCT_ATTRIBUTE_CONTEXT
2668: AND a.ATTRIBUTE = b.PRODUCT_ATTRIBUTE
2669: AND a.VALUE_FROM = b.PRODUCT_ATTR_VALUE