APPS.INVKBCGN dependencies on MTL_ITEM_LOCATIONS_KFV

Line 434: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

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
438:

Line 817: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

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
821: if ( (X_ITEM_LO IS NULL) AND (X_ITEM_HI IS NULL) ) then

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

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
1038: l_pull_seq_rec.pull_sequence_id := X_pull_sequence_id;

Line 1088: from mtl_item_locations_kfv

1084: kb_get_conc_segments(X_org_id, X_loc_id, l_loc_name);
1085: /*
1086: Select concatenated_segments
1087: into l_loc_name
1088: from mtl_item_locations_kfv
1089: where inventory_location_id = X_loc_id and
1090: organization_id = X_org_id;
1091: */
1092: end if;