APPS.INVKBCGN dependencies on MTL_SYSTEM_ITEMS_KFV

Line 433: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

429: d_release_kanban_flag NUMBER;
430: v_success Number := 1;
431: v_report_id Number := NULL;
432: v_org_code VARCHAR2(3);
433: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
434: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
435:
436: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
437: Begin

Line 816: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

812: d_release_kanban_flag NUMBER;
813: v_success Number := 1;
814: v_report_id Number := NULL;
815: v_org_code VARCHAR2(3);
816: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
817: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
818:
819: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
820: Begin

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

1029: l_pull_seq_rec INV_Kanban_PVT.pull_sequence_rec_type;
1030: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1031: l_report_id number;
1032: l_org_code VARCHAR2(3) := Null;
1033: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;
1034: l_loc_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;
1035:
1036: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1037: BEGIN

Line 1097: from mtl_system_items_kfv

1093:
1094: if X_item_id is not NULL then
1095: Select concatenated_segments
1096: into l_item_name
1097: from mtl_system_items_kfv
1098: where inventory_item_id = X_item_id and
1099: organization_id = X_org_id;
1100: end if;
1101: