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.JMF_SHIKYU_ONT_PVT dependencies on QP_PRICE_LIST_PVT

Line 1053: SELECT qp_price_list_pvt.get_product_uom_code(list_line_id),

1049: -- The following query was rewritten to select from the based table
1050: -- QP_LIST_LINES, instead of the OE_PRICE_LIST_LINES view.
1051:
1052: /* Commenting as part of bugfix 9315131. Rewriting this sql.
1053: SELECT qp_price_list_pvt.get_product_uom_code(list_line_id),
1054: operand
1055: INTO l_price_list_uom,
1056: l_component_price
1057: FROM qp_list_lines

Line 1059: AND qp_price_list_pvt.get_inventory_item_id(list_line_id) = p_item_id

1055: INTO l_price_list_uom,
1056: l_component_price
1057: FROM qp_list_lines
1058: WHERE list_header_id = l_price_list_id
1059: AND qp_price_list_pvt.get_inventory_item_id(list_line_id) = p_item_id
1060: AND l_ship_date BETWEEN
1061: NVL(start_date_active, l_ship_date - 1)
1062: AND
1063: NVL(end_date_active, l_ship_date + 1);

Line 1068: SELECT qp_price_list_pvt.get_product_uom_code(qp.list_line_id),

1064: */
1065:
1066: lStmtNo := 180;
1067:
1068: SELECT qp_price_list_pvt.get_product_uom_code(qp.list_line_id),
1069: qp.operand
1070: INTO l_price_list_uom,
1071: l_component_price
1072: FROM qp_list_lines qp