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_NPREQ_RLTD_LINES_TMP

Line 1834: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line

1830: , line.priced_quantity priced_qty
1831: , line.catchweight_qty catchweight_qty
1832: , line.actual_order_quantity actual_order_qty
1833: , line.PRICE_REQUEST_CODE PRICE_REQUEST_CODE --bug#12916970
1834: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line
1835: WHERE rltd.list_line_id = p_list_line_id
1836: AND rltd.line_index = p_line_index
1837: AND line.line_index = p_line_index
1838: AND rltd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 1857: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line

1853: , line.priced_quantity priced_qty
1854: , line.catchweight_qty catchweight_qty
1855: , line.actual_order_quantity actual_order_qty
1856: , line.PRICE_REQUEST_CODE PRICE_REQUEST_CODE -- bug#12916970
1857: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line
1858: WHERE QP_PREQ_GRP.G_PUBLIC_API_CALL_FLAG = QP_PREQ_GRP.G_YES
1859: AND rltd.line_index = p_line_index
1860: AND line_detail_index = p_list_line_id
1861: AND line.line_index = p_line_index

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 2348: FROM qp_npreq_rltd_lines_tmp

2344: , relationship_type_detail price_break_type
2345: , setup_value_from value_from
2346: , setup_value_to value_to
2347: , qualifier_value
2348: FROM qp_npreq_rltd_lines_tmp
2349: WHERE QP_PREQ_GRP.G_PUBLIC_API_CALL_FLAG = QP_PREQ_GRP.G_NO
2350: AND list_line_id = p_list_line_id
2351: AND line_index = p_line_index
2352: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 2369: FROM qp_npreq_rltd_lines_tmp

2365: , relationship_type_detail price_break_type
2366: , setup_value_from value_from
2367: , setup_value_to value_to
2368: , qualifier_value
2369: FROM qp_npreq_rltd_lines_tmp
2370: WHERE QP_PREQ_GRP.G_PUBLIC_API_CALL_FLAG = QP_PREQ_GRP.G_YES
2371: AND line_index = p_line_index
2372: AND line_detail_index = p_list_line_id
2373: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

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