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
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