[Home] [Help]
479: --lpn status project end
480: FROM mtl_material_transactions_temp mmtt,
481: wms_license_plate_numbers lpn,
482: wms_license_plate_numbers lpn3,
483: mtl_parameters mp,
484: cst_cost_groups ccg,
485: mtl_item_locations_kfv mlc ,
486: mtl_secondary_inventories msub,
487: mtl_item_locations_kfv milk,
587: FROM mtl_material_transactions_temp mmtt,
588: mtl_transaction_lots_temp mtlt,
589: wms_license_plate_numbers lpn,
590: wms_license_plate_numbers lpn3,
591: mtl_parameters mp,
592: cst_cost_groups ccg,
593: mtl_item_locations_kfv mlc ,
594: mtl_secondary_inventories msub,
595: mtl_item_locations_kfv milk,
693: FROM
694: wms_lpn_contents wlc,
695: wms_license_plate_numbers lpn,
696: wms_license_plate_numbers lpn3,
697: mtl_parameters mp,
698: cst_cost_groups ccg,
699: mtl_item_locations mlc ,
700: mtl_secondary_inventories msub,
701: mtl_item_locations milk,
758: wlc.parent_lpn_id
759: --lpn status project end
760: FROM wms_lpn_contents wlc,
761: wms_license_plate_numbers lpn,
762: mtl_parameters mp,
763: wms_license_plate_numbers lpn3,
764: cst_cost_groups ccg,
765: mtl_item_locations_kfv mlc ,
766: mtl_secondary_inventories msub,
863: wlc.source_name
864: ) wwlc,
865: wms_license_plate_numbers lpn,
866: wms_license_plate_numbers lpn3,
867: mtl_parameters mp,
868: cst_cost_groups ccg,
869: mtl_item_locations mlc ,
870: mtl_secondary_inventories msub,
871: mtl_item_locations milk,
965: --lpn status project end
966:
967: FROM wms_lpn_contents wlc,
968: wms_license_plate_numbers lpn,
969: mtl_parameters mp,
970: wms_license_plate_numbers lpn3,
971: cst_cost_groups ccg,
972: mtl_item_locations_kfv mlc ,
973: mtl_secondary_inventories msub,
1053: -- INVCONV end
1054: FROM WMS_LPN_CONTENTS wlc
1055: , WMS_LICENSE_PLATE_NUMBERS lpn
1056: , mtl_system_items_vl msiv -- Modified for Bug # 5472330
1057: , mtl_parameters mp
1058: , wms_license_plate_numbers lpn3
1059: , cst_cost_groups ccg
1060: , mtl_item_locations mlc
1061: , mtl_secondary_inventories msub