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.JAI_CMN_SETUP_PKG dependencies on QP_PRICING_ATTRIBUTES

Line 1264: , QP_PRICING_ATTRIBUTES QPPR

1260: --SELECT operand
1261: /*SELECT /*+ no_expand * operand -- for bug 14787674 by anupgupt
1262: FROM
1263: QP_LIST_LINES QPLL
1264: , QP_PRICING_ATTRIBUTES QPPR
1265: WHERE QPLL.list_line_id = QPPR.list_line_id
1266: AND QPLL.List_header_id = v_price_list_id
1267: AND QPPR.product_attribute_context = cp_item
1268: --AND QPPR.Product_Attr_value = p_inv_item_id --Commented by zhiwei for Bug#12718676 on 20110704

Line 1277: qp_pricing_attributes qppr

1273:
1274: /*Modofied cursor statement by mmurtuza for bug 16248381*/
1275: SELECT qpll.operand
1276: FROM qp_list_lines qpll,
1277: qp_pricing_attributes qppr
1278: WHERE qppr.list_line_id = qpll.list_line_id
1279: AND qpll.List_header_id = v_price_list_id
1280: AND qppr.product_attribute_context = cp_item --'ITEM'
1281: AND decode(UPPER(qppr.product_attr_value), 'ALL', NULL, qppr.product_attr_value) = to_char(p_inv_item_id)

Line 1318: , qp_pricing_attributes c

1314: SELECT
1315: b.operand list_price
1316: FROM
1317: qp_list_lines b
1318: , qp_pricing_attributes c
1319: WHERE b.list_header_id = v_price_list_id
1320: AND c.list_line_id = b.list_line_id
1321: AND c.product_uom_code = pv_uom_code
1322: AND NVL( start_date_active, SYSDATE- 1 ) <= SYSDATE