APPS.FLM_KANBAN_CONSOLIDATION dependencies on MTL_ITEM_LOCATIONS

Line 70: FROM mtl_item_locations

66: IF (l_project_reference_enabled = 1)THEN
67: IF (l_Kanban_Card_Rec_Tbl(1).locator_id IS NOT NULL)THEN
68: SELECT project_id
69: INTO l_project_id
70: FROM mtl_item_locations
71: WHERE inventory_location_id = l_Kanban_Card_Rec_Tbl(l_order_count).locator_id
72: AND organization_id = l_Kanban_Card_Rec_Tbl(l_order_count).organization_id;
73: END IF;
74: IF (l_project_id IS NOT NULL)THEN

Line 78: FROM mtl_item_locations

74: IF (l_project_id IS NOT NULL)THEN
75: l_project_accounting_context := 'Y';
76: SELECT task_id
77: INTO l_task_id
78: FROM mtl_item_locations
79: WHERE NVL(project_id,-999) = NVL(l_project_id, -111)
80: AND inventory_location_id =l_Kanban_Card_Rec_Tbl(l_order_count).locator_id
81: AND organization_id = l_Kanban_Card_Rec_Tbl(l_order_count).organization_id;
82: END IF;

Line 312: FROM mtl_item_locations

308: BEGIN
309: SELECT project_id,task_id
310: INTO l_trolin_tbl(l_order_count).project_id,
311: l_trolin_tbl(l_order_count).task_id
312: FROM mtl_item_locations
313: WHERE inventory_location_id = l_Kanban_Card_Rec_Tbl(l_order_count).source_locator_id
314: and organization_id = l_Kanban_Card_Rec_Tbl(l_order_count).organization_id;
315: EXCEPTION
316: WHEN no_data_found THEN