DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 2578: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce

2574: SELECT UNIQUE mil.inventory_location_id,
2575: --mil.concatenated_segments concatenated_segments,--Bug4398337:Commented this line and added below line
2576: mil.locator_segments concatenated_segments,
2577: mil.description
2578: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce
2579: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
2580: AND mil.organization_id = p_organization_id
2581: AND mil.subinventory_code = p_subinventory_code
2582: AND NVL(mil.project_id,-1) = NVL(p_project_id,-1)

Line 2766: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce

2762: SELECT UNIQUE mil.inventory_location_id,
2763: --mil.concatenated_segments concatenated_segments,--Bug4398337:Commented this line and added below line
2764: mil.locator_segments concatenated_segments,
2765: mil.description
2766: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce
2767: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
2768: AND mil.organization_id = p_organization_id
2769: AND mil.subinventory_code = p_subinventory_code
2770: AND NVL(mil.project_id,-1) = NVL(p_project_id,-1)