DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on MTL_ITEM_LOCATIONS

Line 78: mtl_item_locations mil

74: NVL ( t.task_number, ' ' ),
75: NVL ( t.task_name, ' ' )
76: FROM pjm_tasks_mtll_v t,
77: mtl_cycle_count_entries mcce,
78: mtl_item_locations mil
79: WHERE t.project_id = p_project_id
80: AND mcce.organization_id = mil.organization_id
81: AND mcce.subinventory = mil.subinventory_code
82: AND mcce.locator_id = mil.inventory_location_id

Line 118: mtl_item_locations mil

114: NVL ( t.task_number, ' ' ),
115: NVL ( t.task_name, ' ' )
116: FROM pjm_tasks_mtll_v t,
117: mtl_physical_inventory_tags mpi,
118: mtl_item_locations mil
119: WHERE t.project_id = p_project_id
120: AND mil.inventory_location_id = mpi.locator_id
121: AND mil.organization_id = p_organization_id
122: AND mpi.physical_inventory_id = p_physical_inventory_id