DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on MTL_ITEM_LOCATIONS

Line 918: , mtl_item_locations milkfv

914: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
915: FROM wms_lpn_contents wlc
916: , wms_license_plate_numbers plpn
917: , cst_cost_groups ccg
918: , mtl_item_locations milkfv
919: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers
920: where 1=1
921: -- Bug 4137707
922: --start with lpn_id in (select nvl(p_lpn_id, -99) from dual

Line 1036: , mtl_item_locations milkfv

1032: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
1033: FROM wms_lpn_contents wlc
1034: , wms_license_plate_numbers plpn
1035: , cst_cost_groups ccg
1036: , mtl_item_locations milkfv
1037: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers
1038: where 1=1
1039: start with lpn_id in (select nvl(p_lpn_id, -99) from dual
1040: union all

Line 1105: , mtl_item_locations milkfv

1101: FROM wms_packaging_hist wpc
1102: , mtl_material_transactions_temp mmtt
1103: , mtl_system_items msi
1104: , cst_cost_groups ccg
1105: , mtl_item_locations milkfv
1106: -- Bug 4137707, Do not need to include this where clause,
1107: -- This will be controlled when opening this cursor
1108: -- WHERE cartonization_flag = 1 --Cartonization Flow
1109: WHERE wpc.rowid in (select rowid from wms_packaging_hist