[Home] [Help]
192: mtl_lot_numbers mlot,
193: mtl_material_statuses_vl mms1,
194: mtl_material_statuses_vl mms2,
195: mtl_material_statuses_vl mms3,
196: cst_cost_groups csg
197: WHERE moq.organization_id = msik.organization_id
198: AND moq.inventory_item_id = msik.inventory_item_id
199: AND moq.organization_id = msub.organization_id
200: AND moq.subinventory_code = msub.secondary_inventory_name(+)
346: MTL_MATERIAL_STATUSES_vl mms1,
347: MTL_MATERIAL_STATUSES_vl mms2,
348: MTL_MATERIAL_STATUSES_vl mms3,
349: MTL_MATERIAL_STATUSES_vl mms4,
350: CST_COST_GROUPS csg
351: WHERE milk.organization_id(+) = msn.current_organization_id
352: AND milk.subinventory_code(+) = msn.current_subinventory_code
353: AND milk.inventory_location_id(+) = msn.current_locator_id
354: AND milk.status_id = mms2.status_id(+)
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,
488: mtl_system_items_vl msiv, /* Bug 5581528 */
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,
596: mtl_lot_numbers mln,
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,
702: mtl_item_locations milk2,
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,
767: mtl_item_locations_kfv milk,
768: mfg_lookups mlk,
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,
872: mtl_lot_numbers mln,
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,
974: mtl_item_locations_kfv milk,
975: mfg_lookups mlk
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
1062: , mtl_lot_numbers mln
1063: , mfg_lookups mlk
2342: mtl_lot_numbers mlot,
2343: mtl_material_statuses_vl mms1,
2344: mtl_material_statuses_vl mms2,
2345: mtl_material_statuses_vl mms3,
2346: cst_cost_groups csg
2347: WHERE moq.organization_id = msik.organization_id
2348: AND moq.inventory_item_id = msik.inventory_item_id
2349: AND moq.organization_id = msub.organization_id
2350: AND moq.subinventory_code = msub.secondary_inventory_name(+)
2541: MTL_MATERIAL_STATUSES_vl mms1,
2542: MTL_MATERIAL_STATUSES_vl mms2,
2543: MTL_MATERIAL_STATUSES_vl mms3,
2544: MTL_MATERIAL_STATUSES_vl mms4,
2545: CST_COST_GROUPS csg
2546: WHERE milk.organization_id(+) = msn.current_organization_id
2547: AND milk.subinventory_code(+) = msn.current_subinventory_code
2548: AND milk.inventory_location_id(+) = msn.current_locator_id
2549: AND milk.status_id = mms2.status_id(+)
2813: mtl_lot_numbers mlot,
2814: mtl_material_statuses_vl mms1,
2815: mtl_material_statuses_vl mms2,
2816: mtl_material_statuses_vl mms3,
2817: cst_cost_groups csg
2818: WHERE msn.current_organization_id = msik.organization_id
2819: AND msn.current_organization_id = p_Organization_Id
2820: AND msn.inventory_item_id = p_inventory_item_id
2821: AND msn.inventory_item_id = msik.inventory_item_id