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 593: mtl_item_locations_kfv mlc ,

589: wms_license_plate_numbers lpn,
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 */

Line 595: mtl_item_locations_kfv milk,

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

Line 699: mtl_item_locations mlc ,

695: wms_license_plate_numbers lpn,
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,

Line 701: mtl_item_locations milk,

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

Line 702: mtl_item_locations milk2,

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

Line 765: mtl_item_locations_kfv mlc ,

761: wms_license_plate_numbers lpn,
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,

Line 767: mtl_item_locations_kfv milk,

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

Line 770: mtl_item_locations_kfv milk2

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
771: WHERE wlc.parent_lpn_id = p_parent_lpn_id
772: AND lpn.lpn_id = wlc.parent_lpn_id
773: AND lpn.organization_id = mp.organization_id
774: AND lpn.outermost_lpn_id = lpn3.lpn_id

Line 869: mtl_item_locations mlc ,

865: wms_license_plate_numbers lpn,
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 */

Line 871: mtl_item_locations milk,

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

Line 972: mtl_item_locations_kfv mlc ,

968: wms_license_plate_numbers lpn,
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

Line 974: mtl_item_locations_kfv milk,

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

Line 1060: , mtl_item_locations mlc

1056: , mtl_system_items_vl msiv -- Modified for Bug # 5472330
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:

Line 1597: from mtl_serial_numbers msn, mtl_item_locations_kfv milk

1593: */
1594: OPEN x_serialLOV for
1595: select msn.serial_number, msn.current_subinventory_code, milk.concatenated_segments
1596: , msn.lot_number,'', msn.current_status, '', msn.current_locator_id
1597: from mtl_serial_numbers msn, mtl_item_locations_kfv milk
1598: where msn.current_organization_id = p_organization_id
1599: and msn.inventory_item_id = p_inventory_item_id
1600: --and msn.current_status in (3, 5)
1601: AND msn.current_status in (3, 5, 7)

Line 2143: mtl_item_locations mil,

2139: msik.secondary_uom_code
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

Line 2340: mtl_item_locations milk,

2336: msik.secondary_uom_code secondary_uom_code
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,

Line 2452: MTL_ITEM_LOCATIONS milk

2448: INV_PROJECT.GET_TASK_NUMBER task_number,
2449: msik.serial_number_control_code serial_number_control_code
2450: FROM MTL_SERIAL_NUMBERS msn,
2451: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2452: MTL_ITEM_LOCATIONS milk
2453: WHERE milk.organization_id(+) = msn.current_organization_id
2454: AND milk.subinventory_code(+) = msn.current_subinventory_code
2455: AND milk.inventory_location_id(+) = msn.current_locator_id
2456: AND msn.inventory_item_id = msik.inventory_item_id

Line 2538: MTL_ITEM_LOCATIONS milk,

2534: ---msik.secondary_uom_code
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,

Line 2690: MTL_ITEM_LOCATIONS milk,

2686: INV_PROJECT.GET_PROJECT_NUMBER project_number,
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

Line 2811: mtl_item_locations milk,

2807: INV_PROJECT.GET_PROJECT_NUMBER project_number,
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,

Line 2986: mtl_item_locations milk,

2982: msik.lot_control_code lot_control_code,
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