[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 */
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,
558: mtl_lot_numbers mln,
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,
626: mtl_item_locations milk2,
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,
691: mtl_item_locations_kfv milk,
692: mfg_lookups mlk,
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,
796: mtl_lot_numbers mln,
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,
898: mtl_item_locations_kfv milk,
899: mfg_lookups mlk
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
986: , mtl_lot_numbers mln
987: , mfg_lookups mlk
2246: mtl_lot_numbers mlot,
2247: mtl_material_statuses_vl mms1,
2248: mtl_material_statuses_vl mms2,
2249: mtl_material_statuses_vl mms3,
2250: cst_cost_groups csg
2251: WHERE moq.organization_id = msik.organization_id
2252: AND moq.inventory_item_id = msik.inventory_item_id
2253: AND moq.organization_id = msub.organization_id
2254: AND moq.subinventory_code = msub.secondary_inventory_name(+)
2445: MTL_MATERIAL_STATUSES_vl mms1,
2446: MTL_MATERIAL_STATUSES_vl mms2,
2447: MTL_MATERIAL_STATUSES_vl mms3,
2448: MTL_MATERIAL_STATUSES_vl mms4,
2449: CST_COST_GROUPS csg
2450: WHERE milk.organization_id(+) = msn.current_organization_id
2451: AND milk.subinventory_code(+) = msn.current_subinventory_code
2452: AND milk.inventory_location_id(+) = msn.current_locator_id
2453: AND milk.status_id = mms2.status_id(+)
2717: mtl_lot_numbers mlot,
2718: mtl_material_statuses_vl mms1,
2719: mtl_material_statuses_vl mms2,
2720: mtl_material_statuses_vl mms3,
2721: cst_cost_groups csg
2722: WHERE msn.current_organization_id = msik.organization_id
2723: AND msn.current_organization_id = p_Organization_Id
2724: AND msn.inventory_item_id = p_inventory_item_id
2725: AND msn.inventory_item_id = msik.inventory_item_id