jgood (User)
Expert Boarder
Posts: 108
|
data loader 11 Years, 9 Months ago
|
|
Hi Hasan,
I want to say thank you for including DL in you list of topics.
It is very good.
Meanwhile, any idea of the sql table or script to extract the Account segment values giving you the data including the account type. I tried the view from help menu after loading the values but no rows selected.
Regards
Ify
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:data loader 11 Years, 9 Months ago
|
|
The account segment values reside in fnd_flex_values table. Translated descriptions reside in fnd_flex_values_tl table. For each record in fnd_flex_values you will have one record in fnd_flex_values_tl per installed language.
The account type could be found in the column compiled_value_attributes in table fnd_flex_values.
The fnd_flex_values table contains values for all value sets. So you will have to join this table with fnd_flex_value_sets to filter the values belonging to a particular value set.
Here is a sample SQL you could use:
SELECT FLEX_VALUE "Account",
SUBSTR(FV.COMPILED_VALUE_ATTRIBUTES,5,1)"Acc Type",
DESCRIPTION "Description"
FROM FND_FLEX_VALUES a, FND_FLEX_VALUES_TL b,
FND_FLEX_VALUE_SETS c
WHERE a.FLEX_VALUE_ID = b.FLEX_VALUE_ID
AND a.FLEX_VALUE_SET_ID = b.FLEX_VALUE_SET_ID
AND b.FLEX_VALUE_SET_NAME = 'HOE Account'
--- Replace it with your value set name
I have not tested this sql as I wrote it on the fly, but it should work fine.
|
|
|
|
|
The administrator has disabled public write access.
|
jgood (User)
Expert Boarder
Posts: 108
|
Re:data loader 11 Years, 9 Months ago
|
|
Hi Hasan,
Thanks once again for your DL script. I understand you did not test it,hence it did not work directly until I modified it slightly and it worked. See below:
SELECT a.FLEX_VALUE "Account",
SUBSTR(a.COMPILED_VALUE_ATTRIBUTES,5,1)"Acc Type",
b.DESCRIPTION "Description"
FROM FND_FLEX_VALUES a, FND_FLEX_VALUES_TL b,
FND_FLEX_VALUE_SETS c
WHERE a.FLEX_VALUE_ID = b.FLEX_VALUE_ID
AND a.FLEX_VALUE_SET_ID = c.FLEX_VALUE_SET_ID
AND c.FLEX_VALUE_SET_NAME = 'IF_ACCOUNT'
Regards
John
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:data loader 11 Years, 9 Months ago
|
|
Good to know that it worked for you.
|
|
|
|
|
The administrator has disabled public write access.
|
|