[Home] [Help]
5769: from wsh_delivery_details_ob_grp_v wdd
5770: --, R12 TCA changes ra_customers c -- added the following tables instead
5771: , hz_parties c , hz_cust_accounts hca
5772: , oe_transaction_types_tl otl
5773: , wms_direct_ship_temp wdst
5774: where wdd.customer_id = hca.cust_account_id
5775: and c.party_id = hca.party_id
5776: and otl.language=userenv('LANG')
5777: and wdd.source_header_number like (p_order)
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
5862: and oel.ship_from_org_id = p_org_id
5863: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')
5864: and msik.inventory_item_id = oel.inventory_item_id
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
5959: and oel.ship_from_org_id = p_org_id
5960: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')
5961: and msik.inventory_item_id = oel.inventory_item_id
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
6064: and oel.ship_from_org_id = p_org_id
6065: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')
6066: and msik.inventory_item_id = oel.inventory_item_id
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
6162: and oel.ship_from_org_id = p_org_id
6163: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')
6164: and msik.inventory_item_id = oel.inventory_item_id