DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on MTL_ITEM_LOCATIONS

Line 76: mtl_item_locations mil

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

Line 116: mtl_item_locations mil

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