DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on MTL_ITEM_LOCATIONS

Line 1063: , mtl_item_locations milkfv

1059: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
1060: FROM wms_lpn_contents wlc
1061: , wms_license_plate_numbers plpn
1062: , cst_cost_groups ccg
1063: , mtl_item_locations milkfv
1064: WHERE plpn.lpn_id in (select /*+ cardinality(1) */ lpn_id from wms_license_plate_numbers
1065: where 1=1
1066: -- Bug 4137707
1067: --start with lpn_id in (select nvl(p_lpn_id, -99) from dual

Line 1182: , mtl_item_locations milkfv

1178: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
1179: FROM wms_lpn_contents wlc
1180: , wms_license_plate_numbers plpn
1181: , cst_cost_groups ccg
1182: , mtl_item_locations milkfv
1183: WHERE plpn.lpn_id in (
1184: select /*+ cardinality(1) */ id from
1185: ((select lpn_id id from wms_license_plate_numbers
1186: where 1=1

Line 1253: , mtl_item_locations milkfv

1249: FROM wms_packaging_hist wpc
1250: , mtl_material_transactions_temp mmtt
1251: , mtl_system_items msi
1252: , cst_cost_groups ccg
1253: , mtl_item_locations milkfv
1254: -- Bug 4137707, Do not need to include this where clause,
1255: -- This will be controlled when opening this cursor
1256: -- WHERE cartonization_flag = 1 --Cartonization Flow
1257: WHERE wpc.rowid in ( select /*+ cardinality(1) */ id from ((select rowid id from wms_packaging_hist