DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_ITEM_LOCATIONS_KFV

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

2176: , mil.concatenated_segments
2177: , msn.revision
2178: , msn.cost_group_id
2179: , ccg.cost_group
2180: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms
2181: WHERE (group_mark_id IS NULL
2182: OR group_mark_id = -1
2183: )
2184: AND mms.status_id(+) = msn.status_id

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

2214: , mil.concatenated_segments
2215: , msn.revision
2216: , msn.cost_group_id
2217: , ccg.cost_group
2218: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms
2219: WHERE (group_mark_id IS NULL
2220: OR group_mark_id = -1
2221: )
2222: AND mms.status_id(+) = msn.status_id

Line 2722: , mtl_item_locations_kfv milv

2718: , inv_project.get_task_id
2719: , inv_project.get_task_number
2720: FROM mtl_serial_numbers msn
2721: , mtl_system_items_vl msiv
2722: , mtl_item_locations_kfv milv
2723: , mtl_secondary_inventories msi
2724: WHERE msn.current_organization_id = p_current_organization_id
2725: AND msn.lpn_id IS NULL
2726: AND (msn.group_mark_id IS NULL