DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 2267: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms

2263: , mil.concatenated_segments
2264: , msn.revision
2265: , msn.cost_group_id
2266: , ccg.cost_group
2267: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms
2268: WHERE (group_mark_id IS NULL
2269: OR group_mark_id = -1
2270: )
2271: AND mms.status_id(+) = msn.status_id

Line 2305: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms

2301: , mil.concatenated_segments
2302: , msn.revision
2303: , msn.cost_group_id
2304: , ccg.cost_group
2305: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms
2306: WHERE (group_mark_id IS NULL
2307: OR group_mark_id = -1
2308: )
2309: AND mms.status_id(+) = msn.status_id

Line 2809: , mtl_item_locations_kfv milv

2805: , inv_project.get_task_id
2806: , inv_project.get_task_number
2807: FROM mtl_serial_numbers msn
2808: , mtl_system_items_vl msiv
2809: , mtl_item_locations_kfv milv
2810: , mtl_secondary_inventories msi
2811: WHERE msn.current_organization_id = p_current_organization_id
2812: AND msn.lpn_id IS NULL
2813: AND (msn.group_mark_id IS NULL