[Home] [Help]
61:
62: FROM mtl_onhand_quantities_detail moq,
63: mtl_system_items_vl msik, -- Modified for Bug # 5472330
64: mtl_item_locations_kfv milk,
65: mtl_secondary_inventories msub,
66: mtl_lot_numbers mln
67: /* mtl_serial_numbers msn Commenting for bug 1643966 as this table is not reqd. */
68: WHERE moq.organization_id = msik.organization_id
69: AND moq.inventory_item_id = msik.inventory_item_id
187: msik.serial_number_control_code serial_number_control_code
188: FROM mtl_onhand_quantities_detail moq,
189: mtl_system_items_vl msik, -- Modified for Bug # 5472330
190: mtl_item_locations_kfv milk,
191: mtl_secondary_inventories msub,
192: mtl_lot_numbers mlot,
193: mtl_material_statuses_vl mms1,
194: mtl_material_statuses_vl mms2,
195: mtl_material_statuses_vl mms3,
340: 1
341: FROM MTL_SERIAL_NUMBERS msn,
342: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
343: MTL_ITEM_LOCATIONS_KFV milk,
344: MTL_SECONDARY_INVENTORIES msub,
345: MTL_LOT_NUMBERS mlot,
346: MTL_MATERIAL_STATUSES_vl mms1,
347: MTL_MATERIAL_STATUSES_vl mms2,
348: MTL_MATERIAL_STATUSES_vl mms3,
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 */
489: mfg_lookups mlk
490: WHERE mmtt.transfer_lpn_id = p_parent_lpn_id
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,
559: mtl_system_items_vl msiv, /* Bug 5581528 */
560: mfg_lookups mlk
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,
627: mtl_lot_numbers mln,
628: mtl_system_items_vl msiv, /* Bug 5581528 */
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,
693: wms_shipping_transaction_temp wstt,
694: mtl_item_locations_kfv milk2
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,
797: mtl_system_items_vl msiv, /* Bug 5581528 */
798: mfg_lookups mlk
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
900: WHERE wlc.parent_lpn_id = p_parent_lpn_id
901: AND lpn.lpn_id = wlc.parent_lpn_id
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
988:
989: WHERE lpn.organization_id = p_organization_id
2064: -- INVCONV end
2065: FROM mtl_onhand_quantities_detail moq,
2066: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2067: mtl_item_locations mil,
2068: mtl_secondary_inventories msub,
2069: mtl_lot_numbers mln
2070: WHERE moq.organization_id = msik.organization_id
2071: AND moq.inventory_item_id = msik.inventory_item_id
2072: AND moq.organization_id = msub.organization_id
2241: -- INVCONV end
2242: FROM mtl_onhand_quantities_detail moq,
2243: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2244: mtl_item_locations milk,
2245: mtl_secondary_inventories msub,
2246: mtl_lot_numbers mlot,
2247: mtl_material_statuses_vl mms1,
2248: mtl_material_statuses_vl mms2,
2249: mtl_material_statuses_vl mms3,
2439: -- INVCONV end
2440: FROM MTL_SERIAL_NUMBERS msn,
2441: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2442: MTL_ITEM_LOCATIONS milk,
2443: MTL_SECONDARY_INVENTORIES msub,
2444: MTL_LOT_NUMBERS mlot,
2445: MTL_MATERIAL_STATUSES_vl mms1,
2446: MTL_MATERIAL_STATUSES_vl mms2,
2447: MTL_MATERIAL_STATUSES_vl mms3,
2591: INV_PROJECT.GET_TASK_NUMBER task_number
2592: FROM MTL_SERIAL_NUMBERS msn,
2593: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2594: MTL_ITEM_LOCATIONS milk,
2595: MTL_SECONDARY_INVENTORIES msub,
2596: MTL_LOT_NUMBERS mln
2597: WHERE msn.inventory_item_id = p_Inventory_Item_Id
2598: AND milk.organization_id(+) = msn.current_organization_id
2599: AND milk.subinventory_code(+) = msn.current_subinventory_code
2712: INV_PROJECT.GET_TASK_NUMBER task_number
2713: FROM mtl_serial_numbers msn,
2714: mtl_system_items_vl msik, /* Bug 5581528 */
2715: mtl_item_locations milk,
2716: mtl_secondary_inventories msub,
2717: mtl_lot_numbers mlot,
2718: mtl_material_statuses_vl mms1,
2719: mtl_material_statuses_vl mms2,
2720: mtl_material_statuses_vl mms3,
2871: msik.serial_number_control_code serial_number_control_code
2872: FROM mtl_onhand_quantities_detail moq,
2873: mtl_system_items_vl msik, /* Bug 5581528 */
2874: mtl_item_locations milk,
2875: mtl_secondary_inventories msub,
2876: mtl_material_statuses_vl mms1,
2877: mtl_material_statuses_vl mms2
2878: WHERE moq.organization_id = msik.organization_id
2879: AND moq.inventory_item_id = msik.inventory_item_id