APPS.INV_KANBAN_PVT dependencies on MTL_ITEM_LOCATIONS

Line 102: from mtl_item_locations_kfv

98: if l_locator_id is not null Then
99:
100: Select concatenated_segments
101: into x_loc_name
102: from mtl_item_locations_kfv
103: where inventory_location_id = l_locator_id
104: and organization_id = l_organization_id;
105:
106: end if;

Line 388: from mtl_item_locations_kfv

384: if l_Pull_Sequence_Rec.locator_id is not null Then
385:
386: Select concatenated_segments
387: into l_loc_name
388: from mtl_item_locations_kfv
389: where inventory_location_id =
390: l_Pull_Sequence_Rec.locator_id
391: and organization_id =
392: l_Pull_Sequence_Rec.organization_id;

Line 1347: from mtl_item_locations_kfv

1343: if ( nvl(p_loc_id,0) <> 0 ) Then
1344:
1345: Select concatenated_segments
1346: into x_loc_name
1347: from mtl_item_locations_kfv
1348: where inventory_location_id = p_loc_id
1349: and organization_id = p_loc_id;
1350: end if;
1351: Exception

Line 2001: FROM mtl_item_locations

1997: IF (l_project_reference_enabled = 1)THEN
1998: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN
1999: SELECT project_id
2000: INTO l_project_id
2001: FROM mtl_item_locations
2002: WHERE inventory_location_id = p_kanban_card_rec_tbl(1).locator_id
2003: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
2004: END IF;
2005: IF (l_project_id IS NOT NULL)THEN

Line 2009: FROM mtl_item_locations

2005: IF (l_project_id IS NOT NULL)THEN
2006: l_project_accounting_context := 'Y';
2007: SELECT task_id
2008: INTO l_task_id
2009: FROM mtl_item_locations
2010: WHERE NVL(project_id,-999) = NVL(l_project_id, -111)
2011: AND inventory_location_id =p_kanban_card_rec_tbl(1).locator_id
2012: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
2013: END IF;

Line 2309: FROM mtl_item_locations

2305: BEGIN
2306: SELECT project_id,task_id
2307: INTO l_trolin_tbl(l_order_count).project_id,
2308: l_trolin_tbl(l_order_count).task_id
2309: FROM mtl_item_locations
2310: WHERE inventory_location_id = p_kanban_card_rec_tbl(1).source_locator_id and organization_id = p_kanban_card_rec_tbl(1).organization_id;
2311: EXCEPTION
2312: WHEN no_data_found THEN
2313: NULL;

Line 2513: FROM mtl_item_locations

2509: IF (l_project_reference_enabled = 1)THEN
2510: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN
2511: SELECT project_id
2512: INTO l_project_id
2513: FROM mtl_item_locations
2514: WHERE inventory_location_id = p_kanban_card_rec_tbl(1).locator_id
2515: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
2516: END IF;
2517: IF (l_project_id IS NOT NULL)THEN

Line 2520: FROM mtl_item_locations

2516: END IF;
2517: IF (l_project_id IS NOT NULL)THEN
2518: SELECT task_id
2519: INTO l_task_id
2520: FROM mtl_item_locations
2521: WHERE NVL(project_id,-999) = NVL(l_project_id, -111)
2522: AND inventory_location_id =p_kanban_card_rec_tbl(1).locator_id
2523: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
2524: END IF;

Line 2723: FROM mtl_item_locations

2719: IF (l_project_reference_enabled = 1)THEN
2720: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN
2721: SELECT project_id
2722: INTO l_project_id
2723: FROM mtl_item_locations
2724: WHERE inventory_location_id = p_kanban_card_rec_tbl(1).locator_id
2725: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
2726: END IF;
2727: IF (l_project_id IS NOT NULL)THEN

Line 2730: FROM mtl_item_locations

2726: END IF;
2727: IF (l_project_id IS NOT NULL)THEN
2728: SELECT task_id
2729: INTO l_task_id
2730: FROM mtl_item_locations
2731: WHERE NVL(project_id,-999) = NVL(l_project_id, -111)
2732: AND inventory_location_id =p_kanban_card_rec_tbl(1).locator_id
2733: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
2734: END IF;