eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ITEM_INQ dependencies on MTL_ITEM_LOCATIONS

Line 64: mtl_item_locations_kfv milk,

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. */
68: WHERE moq.organization_id = msik.organization_id

Line 190: mtl_item_locations_kfv milk,

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,
194: mtl_material_statuses_vl mms2,

Line 282: MTL_ITEM_LOCATIONS_KFV milk

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
286: AND msn.inventory_item_id = msik.inventory_item_id

Line 343: MTL_ITEM_LOCATIONS_KFV milk,

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,
347: MTL_MATERIAL_STATUSES_vl mms2,

Line 407: * and mtl_item_locations.

403: * a) Removed outer join between MFG_LOOKUPS and WMS_LICENSE_PLATE_NUMBERS since
404: * an LPN will always have a context associated
405: * b) Forked the code to fetch the dock door if the LPN context is "Loaded to Dock(9)"
406: * For this join between wms_license_plate_numbers, wms_shipping_transactions_temp
407: * and mtl_item_locations.
408: * d) For other LPN contexts, we do not need dock door information. So removed the
409: * join with wms_shipping_transactions_temp and mtl_item_locations (milk2).
410: * e) Use the cached values for PROJECT_NUMBER and TASK_NUMBER instead of fetching
411: * them using project_id and task_id

Line 409: * join with wms_shipping_transactions_temp and mtl_item_locations (milk2).

405: * b) Forked the code to fetch the dock door if the LPN context is "Loaded to Dock(9)"
406: * For this join between wms_license_plate_numbers, wms_shipping_transactions_temp
407: * and mtl_item_locations.
408: * d) For other LPN contexts, we do not need dock door information. So removed the
409: * join with wms_shipping_transactions_temp and mtl_item_locations (milk2).
410: * e) Use the cached values for PROJECT_NUMBER and TASK_NUMBER instead of fetching
411: * them using project_id and task_id
412: */
413: PROCEDURE GET_LPN_CONTENTS(

Line 485: mtl_item_locations_kfv mlc ,

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 */
489: mfg_lookups mlk

Line 487: mtl_item_locations_kfv milk,

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

Line 555: mtl_item_locations_kfv mlc ,

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,
559: mtl_system_items_vl msiv, /* Bug 5581528 */

Line 557: mtl_item_locations_kfv milk,

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
561: WHERE mmtt.transfer_lpn_id = p_parent_lpn_id

Line 623: mtl_item_locations mlc ,

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,
627: mtl_lot_numbers mln,

Line 625: mtl_item_locations milk,

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 */
629: mfg_lookups mlk,

Line 626: mtl_item_locations milk2,

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 */
629: mfg_lookups mlk,
630: wms_shipping_transaction_temp wstt

Line 689: mtl_item_locations_kfv mlc ,

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,
693: wms_shipping_transaction_temp wstt,

Line 691: mtl_item_locations_kfv milk,

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
695: WHERE wlc.parent_lpn_id = p_parent_lpn_id

Line 694: mtl_item_locations_kfv milk2

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
695: WHERE wlc.parent_lpn_id = p_parent_lpn_id
696: AND lpn.lpn_id = wlc.parent_lpn_id
697: AND lpn.organization_id = mp.organization_id
698: AND lpn.outermost_lpn_id = lpn3.lpn_id

Line 793: mtl_item_locations mlc ,

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,
797: mtl_system_items_vl msiv, /* Bug 5581528 */

Line 795: mtl_item_locations milk,

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
799: WHERE

Line 896: mtl_item_locations_kfv mlc ,

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
900: WHERE wlc.parent_lpn_id = p_parent_lpn_id

Line 898: mtl_item_locations_kfv milk,

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
902: AND lpn.organization_id = mp.organization_id

Line 984: , mtl_item_locations mlc

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
988:

Line 1521: from mtl_serial_numbers msn, mtl_item_locations_kfv milk

1517: */
1518: OPEN x_serialLOV for
1519: select msn.serial_number, msn.current_subinventory_code, milk.concatenated_segments
1520: , msn.lot_number,'', msn.current_status, '', msn.current_locator_id
1521: from mtl_serial_numbers msn, mtl_item_locations_kfv milk
1522: where msn.current_organization_id = p_organization_id
1523: and msn.inventory_item_id = p_inventory_item_id
1524: --and msn.current_status in (3, 5)
1525: AND msn.current_status in (3, 5, 7)

Line 2067: mtl_item_locations mil,

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
2071: AND moq.inventory_item_id = msik.inventory_item_id

Line 2244: mtl_item_locations milk,

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,
2248: mtl_material_statuses_vl mms2,

Line 2356: MTL_ITEM_LOCATIONS milk

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
2360: AND msn.inventory_item_id = msik.inventory_item_id

Line 2442: MTL_ITEM_LOCATIONS milk,

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,
2446: MTL_MATERIAL_STATUSES_vl mms2,

Line 2594: MTL_ITEM_LOCATIONS milk,

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
2598: AND milk.organization_id(+) = msn.current_organization_id

Line 2715: mtl_item_locations milk,

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,
2719: mtl_material_statuses_vl mms2,

Line 2874: mtl_item_locations milk,

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
2878: WHERE moq.organization_id = msik.organization_id