[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
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,
597: mtl_system_items_vl msiv, /* Bug 5581528 */
598: mfg_lookups mlk
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,
703: mtl_lot_numbers mln,
704: mtl_system_items_vl msiv, /* Bug 5581528 */
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,
769: wms_shipping_transaction_temp wstt,
770: mtl_item_locations_kfv milk2
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,
873: mtl_system_items_vl msiv, /* Bug 5581528 */
874: mfg_lookups mlk
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
976: WHERE wlc.parent_lpn_id = p_parent_lpn_id
977: AND lpn.lpn_id = wlc.parent_lpn_id
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
1064:
1065: WHERE lpn.organization_id = p_organization_id
2140: -- INVCONV end
2141: FROM mtl_onhand_quantities_detail moq,
2142: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2143: mtl_item_locations mil,
2144: mtl_secondary_inventories msub,
2145: mtl_lot_numbers mln
2146: WHERE moq.organization_id = msik.organization_id
2147: AND moq.inventory_item_id = msik.inventory_item_id
2148: AND moq.organization_id = msub.organization_id
2337: -- INVCONV end
2338: FROM mtl_onhand_quantities_detail moq,
2339: mtl_system_items_vl msik, -- Modified for Bug # 5472330
2340: mtl_item_locations milk,
2341: mtl_secondary_inventories msub,
2342: mtl_lot_numbers mlot,
2343: mtl_material_statuses_vl mms1,
2344: mtl_material_statuses_vl mms2,
2345: mtl_material_statuses_vl mms3,
2535: -- INVCONV end
2536: FROM MTL_SERIAL_NUMBERS msn,
2537: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2538: MTL_ITEM_LOCATIONS milk,
2539: MTL_SECONDARY_INVENTORIES msub,
2540: MTL_LOT_NUMBERS mlot,
2541: MTL_MATERIAL_STATUSES_vl mms1,
2542: MTL_MATERIAL_STATUSES_vl mms2,
2543: MTL_MATERIAL_STATUSES_vl mms3,
2687: INV_PROJECT.GET_TASK_NUMBER task_number
2688: FROM MTL_SERIAL_NUMBERS msn,
2689: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2690: MTL_ITEM_LOCATIONS milk,
2691: MTL_SECONDARY_INVENTORIES msub,
2692: MTL_LOT_NUMBERS mln
2693: WHERE msn.inventory_item_id = p_Inventory_Item_Id
2694: AND milk.organization_id(+) = msn.current_organization_id
2695: AND milk.subinventory_code(+) = msn.current_subinventory_code
2808: INV_PROJECT.GET_TASK_NUMBER task_number
2809: FROM mtl_serial_numbers msn,
2810: mtl_system_items_vl msik, /* Bug 5581528 */
2811: mtl_item_locations milk,
2812: mtl_secondary_inventories msub,
2813: mtl_lot_numbers mlot,
2814: mtl_material_statuses_vl mms1,
2815: mtl_material_statuses_vl mms2,
2816: mtl_material_statuses_vl mms3,
2983: msik.serial_number_control_code serial_number_control_code
2984: FROM mtl_onhand_quantities_detail moq,
2985: mtl_system_items_vl msik, /* Bug 5581528 */
2986: mtl_item_locations milk,
2987: mtl_secondary_inventories msub,
2988: mtl_material_statuses_vl mms1,
2989: mtl_material_statuses_vl mms2
2990: WHERE moq.organization_id = msik.organization_id
2991: AND moq.inventory_item_id = msik.inventory_item_id