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_LABEL_PVT6 dependencies on MTL_SECONDARY_INVENTORIES

Line 57: FROM mtl_secondary_inventories

53: ------------------------End of this change for Custom Labels project code--------------------
54:
55: CURSOR c_all_sub IS
56: SELECT secondary_inventory_name
57: FROM mtl_secondary_inventories
58: WHERE organization_id = l_organization_id;
59: CURSOR c_all_sub_loc IS
60: SELECT msi.secondary_inventory_name, milkfv.inventory_location_id
61: FROM mtl_secondary_inventories msi

Line 61: FROM mtl_secondary_inventories msi

57: FROM mtl_secondary_inventories
58: WHERE organization_id = l_organization_id;
59: CURSOR c_all_sub_loc IS
60: SELECT msi.secondary_inventory_name, milkfv.inventory_location_id
61: FROM mtl_secondary_inventories msi
62: ,mtl_item_locations milkfv
63: WHERE msi.organization_id = l_organization_id
64: AND msi.secondary_inventory_name = nvl(l_subinventory_code, msi.secondary_inventory_name)
65: AND milkfv.organization_id(+) = l_organization_id

Line 130: , mtl_secondary_inventories msi

126: , milkfv.volume_uom_code locator_volume_capacity_uom
127: , milkfv.location_maximum_units locator_unit_capacity
128: , milkfv.alias locator_alias
129: FROM mtl_parameters mp
130: , mtl_secondary_inventories msi
131: , mtl_material_statuses_vl mmsvl1
132: , mtl_material_statuses_vl mmsvl2
133: , mtl_item_locations milkfv
134: , pa_tasks pat