DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WMS_DIRECT_SHIP_TEMP

Line 5985: , wms_direct_ship_temp wdst

5981: from wsh_delivery_details_ob_grp_v wdd
5982: --, R12 TCA changes ra_customers c -- added the following tables instead
5983: , hz_parties c , hz_cust_accounts hca
5984: , oe_transaction_types_tl otl
5985: , wms_direct_ship_temp wdst
5986: where wdd.customer_id = hca.cust_account_id
5987: and c.party_id = hca.party_id
5988: and otl.language=userenv('LANG')
5989: and wdd.source_header_number like (p_order)

Line 6084: , wms_direct_ship_temp wds

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
6086: and oel.ship_from_org_id = p_org_id
6087: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')
6088: and msik.inventory_item_id = oel.inventory_item_id

Line 6188: , wms_direct_ship_temp wds

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
6190: and oel.ship_from_org_id = p_org_id
6191: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')
6192: and msik.inventory_item_id = oel.inventory_item_id

Line 6299: , wms_direct_ship_temp wds

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
6301: and oel.ship_from_org_id = p_org_id
6302: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')
6303: and msik.inventory_item_id = oel.inventory_item_id

Line 6404: , wms_direct_ship_temp wds

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
6406: and oel.ship_from_org_id = p_org_id
6407: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')
6408: and msik.inventory_item_id = oel.inventory_item_id