APPS.INV_TRANSACTION_LOVS dependencies on MTL_ITEM_SUB_TRK_VAL_V

Line 236: FROM mtl_item_sub_trk_val_v

232: IF (p_Transaction_Action_Id <> 2 and p_Transaction_Action_Id <>3) THEN
233: IF p_Restrict_Subinventories_Code = 1 THEN
234: OPEN x_Zones FOR
235: SELECT secondary_inventory_name,description,asset_inventory
236: FROM mtl_item_sub_trk_val_v
237: WHERE organization_id = p_Organization_Id AND
238: inventory_item_id = p_Inventory_Item_Id AND
239: secondary_inventory_name like p_Secondary_Inventory_Name;
240: ELSE

Line 252: FROM mtl_item_sub_trk_val_v

248: ELSE
249: IF p_Restrict_Subinventories_Code = 1 THEN
250: OPEN x_Zones FOR
251: SELECT secondary_inventory_name,description,asset_inventory
252: FROM mtl_item_sub_trk_val_v
253: WHERE organization_id = p_Organization_Id AND
254: inventory_item_id = p_Inventory_Item_Id AND
255: secondary_inventory_name like p_Secondary_Inventory_Name;
256: ELSE

Line 285: FROM mtl_item_sub_trk_val_v

281: ELSE
282: IF p_Restrict_Subinventories_Code = 1 THEN
283: OPEN x_Zones FOR
284: SELECT secondary_inventory_name,description,asset_inventory
285: FROM mtl_item_sub_trk_val_v
286: WHERE organization_id = p_Organization_Id AND
287: inventory_item_id = p_Inventory_Item_Id AND
288: secondary_inventory_name like p_Secondary_Inventory_Name;
289: ELSE