[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,
549: FROM mtl_material_transactions_temp mmtt,
550: mtl_transaction_lots_temp mtlt,
551: wms_license_plate_numbers lpn,
552: wms_license_plate_numbers lpn3,
553: mtl_parameters mp,
554: cst_cost_groups ccg,
555: mtl_item_locations_kfv mlc ,
556: mtl_secondary_inventories msub,
557: mtl_item_locations_kfv milk,
617: FROM
618: wms_lpn_contents wlc,
619: wms_license_plate_numbers lpn,
620: wms_license_plate_numbers lpn3,
621: mtl_parameters mp,
622: cst_cost_groups ccg,
623: mtl_item_locations mlc ,
624: mtl_secondary_inventories msub,
625: mtl_item_locations milk,
682: wlc.parent_lpn_id
683: --lpn status project end
684: FROM wms_lpn_contents wlc,
685: wms_license_plate_numbers lpn,
686: mtl_parameters mp,
687: wms_license_plate_numbers lpn3,
688: cst_cost_groups ccg,
689: mtl_item_locations_kfv mlc ,
690: mtl_secondary_inventories msub,
787: wlc.source_name
788: ) wwlc,
789: wms_license_plate_numbers lpn,
790: wms_license_plate_numbers lpn3,
791: mtl_parameters mp,
792: cst_cost_groups ccg,
793: mtl_item_locations mlc ,
794: mtl_secondary_inventories msub,
795: mtl_item_locations milk,
889: --lpn status project end
890:
891: FROM wms_lpn_contents wlc,
892: wms_license_plate_numbers lpn,
893: mtl_parameters mp,
894: wms_license_plate_numbers lpn3,
895: cst_cost_groups ccg,
896: mtl_item_locations_kfv mlc ,
897: mtl_secondary_inventories msub,
977: -- INVCONV end
978: FROM WMS_LPN_CONTENTS wlc
979: , WMS_LICENSE_PLATE_NUMBERS lpn
980: , mtl_system_items_vl msiv -- Modified for Bug # 5472330
981: , mtl_parameters mp
982: , wms_license_plate_numbers lpn3
983: , cst_cost_groups ccg
984: , mtl_item_locations mlc
985: , mtl_secondary_inventories msub