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 1326: from mtl_item_locations_kfv

1322: if ( nvl(p_loc_id,0) <> 0 ) Then
1323:
1324: Select concatenated_segments
1325: into x_loc_name
1326: from mtl_item_locations_kfv
1327: where inventory_location_id = p_loc_id
1328: and organization_id = p_loc_id;
1329: end if;
1330: Exception

Line 1723: FROM mtl_item_locations

1719: IF (l_project_reference_enabled = 1)THEN
1720: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN
1721: SELECT project_id
1722: INTO l_project_id
1723: FROM mtl_item_locations
1724: WHERE inventory_location_id = p_kanban_card_rec_tbl(1).locator_id
1725: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
1726: END IF;
1727: IF (l_project_id IS NOT NULL)THEN

Line 1731: FROM mtl_item_locations

1727: IF (l_project_id IS NOT NULL)THEN
1728: l_project_accounting_context := 'Y';
1729: SELECT task_id
1730: INTO l_task_id
1731: FROM mtl_item_locations
1732: WHERE NVL(project_id,-999) = NVL(l_project_id, -111)
1733: AND inventory_location_id =p_kanban_card_rec_tbl(1).locator_id
1734: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
1735: END IF;

Line 2009: FROM mtl_item_locations

2005: BEGIN
2006: SELECT project_id,task_id
2007: INTO l_trolin_tbl(l_order_count).project_id,
2008: l_trolin_tbl(l_order_count).task_id
2009: FROM mtl_item_locations
2010: WHERE inventory_location_id = p_kanban_card_rec_tbl(1).source_locator_id and organization_id = p_kanban_card_rec_tbl(1).organization_id;
2011: EXCEPTION
2012: WHEN no_data_found THEN
2013: NULL;

Line 2172: FROM mtl_item_locations

2168: IF (l_project_reference_enabled = 1)THEN
2169: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN
2170: SELECT project_id
2171: INTO l_project_id
2172: FROM mtl_item_locations
2173: WHERE inventory_location_id = p_kanban_card_rec_tbl(1).locator_id
2174: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
2175: END IF;
2176: IF (l_project_id IS NOT NULL)THEN

Line 2179: FROM mtl_item_locations

2175: END IF;
2176: IF (l_project_id IS NOT NULL)THEN
2177: SELECT task_id
2178: INTO l_task_id
2179: FROM mtl_item_locations
2180: WHERE NVL(project_id,-999) = NVL(l_project_id, -111)
2181: AND inventory_location_id =p_kanban_card_rec_tbl(1).locator_id
2182: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
2183: END IF;

Line 2353: FROM mtl_item_locations

2349: IF (l_project_reference_enabled = 1)THEN
2350: IF (p_kanban_card_rec_tbl(1).locator_id IS NOT NULL)THEN
2351: SELECT project_id
2352: INTO l_project_id
2353: FROM mtl_item_locations
2354: WHERE inventory_location_id = p_kanban_card_rec_tbl(1).locator_id
2355: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
2356: END IF;
2357: IF (l_project_id IS NOT NULL)THEN

Line 2360: FROM mtl_item_locations

2356: END IF;
2357: IF (l_project_id IS NOT NULL)THEN
2358: SELECT task_id
2359: INTO l_task_id
2360: FROM mtl_item_locations
2361: WHERE NVL(project_id,-999) = NVL(l_project_id, -111)
2362: AND inventory_location_id =p_kanban_card_rec_tbl(1).locator_id
2363: AND organization_id = p_kanban_card_rec_tbl(1).organization_id;
2364: END IF;