APPS.INVKBCGN dependencies on MTL_ITEM_LOCATIONS_KFV

Line 471: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

467: v_success Number := 1;
468: v_report_id Number := NULL;
469: v_org_code VARCHAR2(3);
470: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
471: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
472:
473: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
474: Begin
475:

Line 1002: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

998: v_success Number := 1;
999: v_report_id Number := NULL;
1000: v_org_code VARCHAR2(3);
1001: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
1002: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
1003:
1004: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1005: Begin
1006: if ( (X_ITEM_LO IS NULL) AND (X_ITEM_HI IS NULL) ) then

Line 1297: l_loc_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;

1293: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1294: l_report_id number;
1295: l_org_code VARCHAR2(3) := Null;
1296: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;
1297: l_loc_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;
1298: --added for ekanban by javakat
1299: l_no_of_existing_cards NUMBER;
1300: l_no_of_activenhold_cards NUMBER;
1301: l_create_kanban BOOLEAN DEFAULT FALSE;

Line 1513: from mtl_item_locations_kfv

1509: kb_get_conc_segments(X_org_id, X_loc_id, l_loc_name);
1510: /*
1511: Select concatenated_segments
1512: into l_loc_name
1513: from mtl_item_locations_kfv
1514: where inventory_location_id = X_loc_id and
1515: organization_id = X_org_id;
1516: */
1517: end if;

Line 2049: from mtl_item_locations_kfv

2045: if l_locator_id is not null Then
2046:
2047: Select concatenated_segments
2048: into x_loc_name
2049: from mtl_item_locations_kfv
2050: where inventory_location_id = l_locator_id
2051: and organization_id = l_organization_id;
2052:
2053: end if;