DBA Data[Home] [Help]

APPS.INV_UI_PROJECT_LOVS dependencies on MTL_ITEM_LOCATIONS

Line 612: mtl_item_locations mil

608: NVL ( p.project_number, ' ' ),
609: NVL ( p.project_name, ' ' )
610: FROM pjm_projects_mtll_v p,
611: mtl_cycle_count_entries mcce,
612: mtl_item_locations mil
613: WHERE mil.segment19 = p.project_id
614: AND mcce.locator_id = mil.inventory_location_id
615: AND mcce.organization_id = mil.organization_id
616: AND mcce.cycle_count_header_id = p_cycle_count_id

Line 662: mtl_item_locations mil

658: NVL ( p.project_number, ' ' ),
659: NVL ( p.project_name, ' ' )
660: FROM pjm_projects_mtll_v p,
661: mtl_physical_inventory_tags mpi,
662: mtl_item_locations mil
663: WHERE mil.project_id = p.project_id
664: AND mil.inventory_location_id = mpi.locator_id
665: AND mil.organization_id = p_organization_id
666: AND mpi.physical_inventory_id =