APPS.CSI_ASSET_PVT dependencies on FA_LOCATIONS

Line 202: from FA_LOCATIONS_KFV

198: -- Resolve FA Location
199: Begin
200: select concatenated_segments
201: into l_fa_location
202: from FA_LOCATIONS_KFV
203: where location_id = px_instance_asset_rec.fa_location_id;
204: Exception
205: when no_data_found then
206: null;

Line 558: FROM fa_locations

554: p_asset_header_tbl(tab_row).fa_location_segment4,
555: p_asset_header_tbl(tab_row).fa_location_segment5,
556: p_asset_header_tbl(tab_row).fa_location_segment6,
557: p_asset_header_tbl(tab_row).fa_location_segment7
558: FROM fa_locations
559: WHERE location_id = p_asset_header_tbl(tab_row).fa_location_id;
560: EXCEPTION
561: WHEN OTHERS THEN
562: NULL;

Line 1354: --check for the existance of location_id in fa_locations table

1350: END IF; -- Called from grp check as GRP API already does the validation
1351: --
1352: IF p_instance_asset_rec.fa_sync_validation_reqd = fnd_api.g_false AND
1353: nvl(p_instance_asset_rec.fa_sync_flag,'N') = 'Y' THEN
1354: --check for the existance of location_id in fa_locations table
1355: l_valid_flag := 'Y';
1356: l_exists_flag := 'N';
1357: IF p_instance_asset_rec.fa_location_id is not null AND
1358: p_instance_asset_rec.fa_location_id <> FND_API.G_MISS_NUM THEN