DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on STANDARD

Line 5863: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

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
5865: and msik.organization_id = oel.ship_from_org_id
5866: and msik.mtl_transactions_enabled_flag <> 'N'
5867: and wdd.source_header_id = oel.header_id

Line 5960: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

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
5962: and msik.organization_id = oel.ship_from_org_id
5963: and msik.mtl_transactions_enabled_flag <> 'N'
5964: and wdd.source_header_id = oel.header_id

Line 6065: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

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
6067: and msik.organization_id = oel.ship_from_org_id
6068: and msik.mtl_transactions_enabled_flag <> 'N'
6069: and wdd.source_header_id = oel.header_id

Line 6163: and oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')

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
6165: and msik.organization_id = oel.ship_from_org_id
6166: and msik.mtl_transactions_enabled_flag <> 'N'
6167: and wdd.source_header_id = oel.header_id