APPS.INVKBCGN dependencies on MTL_SYSTEM_ITEMS_KFV

Line 470: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

466: d_release_kanban_flag NUMBER;
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

Line 1001: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

997: d_release_kanban_flag NUMBER;
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

Line 1296: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;

1292: l_kanban_card_rec INV_Kanban_PVT.Kanban_Card_Rec_Type;
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;

Line 1522: from mtl_system_items_kfv

1518:
1519: if X_item_id is not NULL then
1520: Select concatenated_segments
1521: into l_item_name
1522: from mtl_system_items_kfv
1523: where inventory_item_id = X_item_id and
1524: organization_id = X_org_id;
1525: end if;
1526:

Line 2038: from mtl_system_items_kfv a , mtl_parameters b,

2034: Select concatenated_segments,organization_code,
2035: subinventory_name,locator_id,pull.organization_id
2036: into x_item_name,x_org_code,x_subinventory,l_locator_id,
2037: l_organization_id
2038: from mtl_system_items_kfv a , mtl_parameters b,
2039: mtl_kanban_pull_sequences pull
2040: where a.inventory_item_id = pull.inventory_item_id
2041: and a.organization_id = Pull.organization_id
2042: and b.organization_id = Pull.organization_id