APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on OE_ORDER_LINES_ALL

Line 3478: oe_order_lines_all oel

3474: CURSOR c_unshipped_count (p_ship_set_id NUMBER)
3475: IS
3476: SELECT 1
3477: FROM wsh_delivery_details_ob_grp_v wdd,
3478: oe_order_lines_all oel
3479: WHERE oel.ship_set_id = p_ship_set_id
3480: AND wdd.source_line_id = oel.line_id
3481: AND wdd.source_header_id = oel.header_id
3482: AND wdd.ship_set_id = p_ship_set_id

Line 5362: oe_order_lines_all ol

5358: wsh_delivery_assignments_v wda,
5359: wsh_delivery_details_ob_grp_v wdd2,
5360: wms_license_plate_numbers lpn,
5361: mtl_txn_request_lines mol,
5362: oe_order_lines_all ol
5363: WHERE lpn.outermost_lpn_id = p_lpn_id
5364: AND wdd2.lpn_id = lpn.lpn_id
5365: AND wdd2.released_status = 'X' -- For LPN reuse ER : 6845650
5366: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id

Line 6000: from oe_order_lines_all ool

5996: (wdst.order_header_id = wdd.source_header_id
5997: and wdd.released_status = ('Y')))
5998: and wdst.organization_id (+) = wdd.organization_id --Added bug 4128854
5999: and exists (select 1
6000: from oe_order_lines_all ool
6001: where ool.header_id = wdd.source_header_id
6002: and NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(ool.line_id),'P') = l_fulfillment_base
6003: )
6004: order by 2,1;

Line 6081: FROM oe_order_lines_all oel

6077: , wdd.src_requested_quantity_uom
6078: , wdd.src_requested_quantity2
6079: , wdd.REQUESTED_QUANTITY_UOM2
6080: , NVL(wds.secondary_processed_qty,0) secondary_processed_qty
6081: FROM oe_order_lines_all oel
6082: , wsh_delivery_details_ob_grp_v wdd
6083: , mtl_system_items_kfv msik
6084: , wms_direct_ship_temp wds
6085: WHERE oel.header_id =p_header_id

Line 6185: FROM oe_order_lines_all oel

6181: , wdd.src_requested_quantity_uom
6182: , 0
6183: , wdd.REQUESTED_QUANTITY_UOM2
6184: , 0 secondary_processed_qty
6185: FROM oe_order_lines_all oel
6186: , wsh_delivery_details_ob_grp_v wdd
6187: , mtl_system_items_kfv msik
6188: , wms_direct_ship_temp wds
6189: WHERE oel.header_id =p_header_id

Line 6296: FROM oe_order_lines_all oel

6292: , wdd.src_requested_quantity_uom
6293: , wdd.src_requested_quantity2
6294: , wdd.REQUESTED_QUANTITY_UOM2
6295: , NVL(wds.secondary_processed_qty,0) secondary_processed_qty
6296: FROM oe_order_lines_all oel
6297: , wsh_delivery_details_ob_grp_v wdd
6298: , mtl_system_items_kfv msik
6299: , wms_direct_ship_temp wds
6300: WHERE oel.header_id =p_header_id

Line 6401: FROM oe_order_lines_all oel

6397: , wdd.src_requested_quantity_uom
6398: , 0
6399: , wdd.REQUESTED_QUANTITY_UOM2
6400: , 0 secondary_processed_qty
6401: FROM oe_order_lines_all oel
6402: , wsh_delivery_details_ob_grp_v wdd
6403: , mtl_system_items_kfv msik
6404: , wms_direct_ship_temp wds
6405: WHERE oel.header_id =p_header_id