DBA Data[Home] [Help]

APPS.INV_LABEL_PVT6 dependencies on MTL_ITEM_LOCATIONS

Line 62: ,mtl_item_locations milkfv

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
66: AND milkfv.subinventory_code(+) = msi.secondary_inventory_name;

Line 133: , mtl_item_locations milkfv

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
135: , pa_projects_all pap
136: , cst_cost_groups ccg
137: WHERE mp.organization_id = l_organization_id