DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 2201: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce

2197: SELECT UNIQUE mil.inventory_location_id,
2198: --mil.concatenated_segments concatenated_segments,--Bug4398337:Commented this line and added below line
2199: mil.locator_segments concatenated_segments,
2200: mil.description
2201: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce
2202: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
2203: AND mil.organization_id = p_organization_id
2204: AND mil.subinventory_code = p_subinventory_code
2205: AND NVL(mil.project_id,-1) = NVL(p_project_id,-1)

Line 2389: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce

2385: SELECT UNIQUE mil.inventory_location_id,
2386: --mil.concatenated_segments concatenated_segments,--Bug4398337:Commented this line and added below line
2387: mil.locator_segments concatenated_segments,
2388: mil.description
2389: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce
2390: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
2391: AND mil.organization_id = p_organization_id
2392: AND mil.subinventory_code = p_subinventory_code
2393: AND NVL(mil.project_id,-1) = NVL(p_project_id,-1)