DBA Data[Home] [Help]

APPS.INV_ITEM_INQ dependencies on MTL_SYSTEM_ITEMS_VL

Line 63: mtl_system_items_vl msik, -- Modified for Bug # 5472330

59: msik.serial_number_control_code,
60: moq.cost_group_id
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. */

Line 189: mtl_system_items_vl msik, -- Modified for Bug # 5472330

185: sum(nvl(moq.primary_transaction_quantity, 0)) sum_txn_qty,
186: msik.lot_control_code lot_control_code,
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,

Line 281: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */

277: msn.serial_number,
278: msik.primary_uom_code,
279: 1
280: FROM MTL_SERIAL_NUMBERS msn,
281: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
282: MTL_ITEM_LOCATIONS_KFV milk
283: WHERE milk.organization_id(+) = msn.current_organization_id
284: AND milk.subinventory_code(+) = msn.current_subinventory_code
285: AND milk.inventory_location_id(+) = msn.current_locator_id

Line 342: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */

338: mms4.status_code serial_status,
339: msik.primary_uom_code,
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,

Line 488: mtl_system_items_vl msiv, /* Bug 5581528 */

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
491: AND lpn.lpn_id = mmtt.transfer_lpn_id
492: AND lpn.organization_id = mp.organization_id

Line 559: mtl_system_items_vl msiv, /* Bug 5581528 */

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
561: WHERE mmtt.transfer_lpn_id = p_parent_lpn_id
562: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
563: AND lpn.lpn_id = mmtt.transfer_lpn_id

Line 628: mtl_system_items_vl msiv, /* Bug 5581528 */

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 */
629: mfg_lookups mlk,
630: wms_shipping_transaction_temp wstt
631: WHERE wlc.parent_lpn_id = p_parent_lpn_id
632: AND lpn.lpn_id = wlc.parent_lpn_id

Line 797: mtl_system_items_vl msiv, /* Bug 5581528 */

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
799: WHERE
800: lpn.lpn_id = wwlc.parent_lpn_id
801: AND lpn.organization_id = mp.organization_id

Line 980: , mtl_system_items_vl msiv -- Modified for Bug # 5472330

976: , msiv.secondary_uom_code
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

Line 2066: mtl_system_items_vl msik, -- Modified for Bug # 5472330

2062: sum(nvl(moq.secondary_transaction_quantity, 0)),
2063: msik.secondary_uom_code
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

Line 2243: mtl_system_items_vl msik, -- Modified for Bug # 5472330

2239: NVL(msik.tracking_quantity_ind, 'P') tracking_quantity_ind,
2240: msik.secondary_uom_code secondary_uom_code
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,

Line 2355: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */

2351: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2352: INV_PROJECT.GET_TASK_NUMBER task_number,
2353: msik.serial_number_control_code serial_number_control_code
2354: FROM MTL_SERIAL_NUMBERS msn,
2355: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2356: MTL_ITEM_LOCATIONS milk
2357: WHERE milk.organization_id(+) = msn.current_organization_id
2358: AND milk.subinventory_code(+) = msn.current_subinventory_code
2359: AND milk.inventory_location_id(+) = msn.current_locator_id

Line 2441: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */

2437: ---NVL(msik.tracking_quantity_ind, 'P'),
2438: ---msik.secondary_uom_code
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,

Line 2593: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */

2589: msn.cost_group_id,
2590: INV_PROJECT.GET_PROJECT_NUMBER project_number,
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

Line 2714: mtl_system_items_vl msik, /* Bug 5581528 */

2710: msik.serial_number_control_code serial_number_control_code,
2711: INV_PROJECT.GET_PROJECT_NUMBER project_number,
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,

Line 2873: mtl_system_items_vl msik, /* Bug 5581528 */

2869: sum(nvl(moq.primary_transaction_quantity, 0)) sum_txn_qty,
2870: msik.lot_control_code lot_control_code,
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