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

Line 3417: oe_order_lines_all oel

3413: CURSOR c_unshipped_count (p_ship_set_id NUMBER)
3414: IS
3415: SELECT 1
3416: FROM wsh_delivery_details_ob_grp_v wdd,
3417: oe_order_lines_all oel
3418: WHERE oel.ship_set_id = p_ship_set_id
3419: AND wdd.source_line_id = oel.line_id
3420: AND wdd.source_header_id = oel.header_id
3421: AND wdd.ship_set_id = p_ship_set_id

Line 5202: oe_order_lines_all ol

5198: wsh_delivery_assignments_v wda,
5199: wsh_delivery_details_ob_grp_v wdd2,
5200: wms_license_plate_numbers lpn,
5201: mtl_txn_request_lines mol,
5202: oe_order_lines_all ol
5203: WHERE lpn.outermost_lpn_id = p_lpn_id
5204: AND wdd2.lpn_id = lpn.lpn_id
5205: AND wdd2.released_status = 'X' -- For LPN reuse ER : 6845650
5206: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id

Line 5857: FROM oe_order_lines_all oel

5853: , wdd.FREIGHT_TERMS_CODE
5854: , NVL(wds.processed_flag,'N') processed_flag
5855: , NVL(wds.processed_quantity,0) processed_quantity
5856: , wdd.src_requested_quantity_uom
5857: FROM oe_order_lines_all oel
5858: , wsh_delivery_details_ob_grp_v wdd
5859: , mtl_system_items_kfv msik
5860: , wms_direct_ship_temp wds
5861: WHERE oel.header_id =p_header_id

Line 5954: FROM oe_order_lines_all oel

5950: , wdd.FREIGHT_TERMS_CODE
5951: , 'N' processed_flag
5952: , 0 processed_quantity
5953: , wdd.src_requested_quantity_uom
5954: FROM oe_order_lines_all oel
5955: , wsh_delivery_details_ob_grp_v wdd
5956: , mtl_system_items_kfv msik
5957: , wms_direct_ship_temp wds
5958: WHERE oel.header_id =p_header_id

Line 6059: FROM oe_order_lines_all oel

6055: , wdd.FREIGHT_TERMS_CODE
6056: , NVL(wds.processed_flag,'N') processed_flag
6057: , NVL(wds.processed_quantity,0) processed_quantity
6058: , wdd.src_requested_quantity_uom
6059: FROM oe_order_lines_all oel
6060: , wsh_delivery_details_ob_grp_v wdd
6061: , mtl_system_items_kfv msik
6062: , wms_direct_ship_temp wds
6063: WHERE oel.header_id =p_header_id

Line 6157: FROM oe_order_lines_all oel

6153: , wdd.FREIGHT_TERMS_CODE
6154: , 'N' processed_flag
6155: , 0 processed_quantity
6156: , wdd.src_requested_quantity_uom
6157: FROM oe_order_lines_all oel
6158: , wsh_delivery_details_ob_grp_v wdd
6159: , mtl_system_items_kfv msik
6160: , wms_direct_ship_temp wds
6161: WHERE oel.header_id =p_header_id