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.CTO_SUBASSEMBLY_SUP_PK dependencies on OE_ORDER_LINES_ALL

Line 1804: oe_order_lines_all oel,

1800: IS
1801: SELECT DISTINCT(bcmm.order_line_id) order_line_id,
1802: oeh.order_number order_number
1803: FROM bom_cto_mlsupply_main_temp bcmm,
1804: oe_order_lines_all oel,
1805: oe_order_headers_all oeh
1806: WHERE bcmm.order_line_id = oel.line_id
1807: AND oel.header_id = oeh.header_id
1808: ORDER BY oeh.order_number,

Line 2163: FROM oe_order_lines_all oel,

2159: l_ordered_uom,
2160: l_order_number,
2161: l_cfm_routing_flag,
2162: l_routing_sequence_id
2163: FROM oe_order_lines_all oel,
2164: oe_order_headers_all oeh,
2165: mtl_system_items_kfv mtl,
2166: bom_operational_routings bor
2167: WHERE oel.line_id = p_Top_Assembly_LineId

Line 3391: OE_ORDER_LINES_ALL oel

3387:
3388: SELECT count(1)
3389: INTO l_routing_count_sa
3390: FROM bom_operational_routings bor,
3391: OE_ORDER_LINES_ALL oel
3392: WHERE oel.INVENTORY_ITEM_ID = l_mlsupply_items(l_index).item_id
3393: AND oel.INVENTORY_ITEM_ID = bor.assembly_item_id
3394: AND oel.ship_from_org_id = bor.organization_id
3395: AND ROWNUM = 1;