APPS.WMS_ATF_DESTINATION_LPN dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 191: mtl_material_transactions_temp mmtt,

187: mmtt.organization_id
188: from wms_op_plan_instances wopi, -- after review on 07/30/03, replaced wms_op_plans_b table with wms_op_plan_instances.
189: wms_op_plan_details wopd,
190: -- wms_zones_b wzb, -- Removed after Code Review on Sept 11th 2003.
191: mtl_material_transactions_temp mmtt,
192: wms_op_operation_instances wooi -- Added after review on 07/30/03
193: where mmtt.organization_id = wopi.organization_id
194: -- @@@ Commented after Code Review on Sept 11th 2003.
195: -- and wzb.zone_id(+) = wopd.pre_specified_zone_id

Line 220: mtl_material_transactions_temp mmtt,

216: --
217: cursor c_lpn_active_wzone_witem is
218: select wlpn.outermost_lpn_id
219: from wms_license_plate_numbers wlpn,
220: mtl_material_transactions_temp mmtt,
221: wms_zone_locators wzl,
222: wms_op_plan_instances wopi,
223: wms_op_operation_instances wooi,
224: wms_op_operation_instances wooi2

Line 258: from mtl_material_transactions_temp mmtt,

254: --
255: --
256: cursor c_lpn_active_wzone_woitem is
257: select wlpn.outermost_lpn_id
258: from mtl_material_transactions_temp mmtt,
259: wms_license_plate_numbers wlpn,
260: wms_zone_locators wzl,
261: wms_op_plan_instances wopi,
262: wms_op_operation_instances wooi,

Line 296: from mtl_material_transactions_temp mmtt,

292: --
293: --
294: cursor c_lpn_active_wozone_witem is
295: select wlpn.outermost_lpn_id
296: from mtl_material_transactions_temp mmtt,
297: wms_license_plate_numbers wlpn,
298: wms_op_plan_instances wopi,
299: wms_op_operation_instances wooi,
300: wms_op_operation_instances wooi2

Line 330: from mtl_material_transactions_temp mmtt,

326: --
327: --
328: cursor c_lpn_active_wozone_woitem is
329: select wlpn.outermost_lpn_id
330: from mtl_material_transactions_temp mmtt,
331: wms_license_plate_numbers wlpn,
332: wms_op_plan_instances wopi,
333: wms_op_operation_instances wooi,
334: wms_op_operation_instances wooi2