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_KFV

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 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 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 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 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)