APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on STANDARD

Line 43: AND d1.delivery_type = 'STANDARD'

39: WHERE d1.delivery_id <> l_delivery_id
40: AND s1.stop_id = dl1.pick_up_stop_id
41: AND d1.delivery_id = dl1.delivery_id
42: AND d1.status_code = 'OP'
43: AND d1.delivery_type = 'STANDARD'
44: AND s2.trip_id = s1.trip_id
45: AND s2.stop_id = dl2.pick_up_stop_id
46: AND dl2.delivery_id = l_delivery_id
47: AND rownum = 1;

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

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
6089: and msik.organization_id = oel.ship_from_org_id
6090: and msik.mtl_transactions_enabled_flag <> 'N'
6091: and wdd.source_header_id = oel.header_id

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

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
6193: and msik.organization_id = oel.ship_from_org_id
6194: and msik.mtl_transactions_enabled_flag <> 'N'
6195: and wdd.source_header_id = oel.header_id

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

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
6304: and msik.organization_id = oel.ship_from_org_id
6305: and msik.mtl_transactions_enabled_flag <> 'N'
6306: and wdd.source_header_id = oel.header_id

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

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
6409: and msik.organization_id = oel.ship_from_org_id
6410: and msik.mtl_transactions_enabled_flag <> 'N'
6411: and wdd.source_header_id = oel.header_id