EBS提供了很多标准的KFF(更多说明见:Key Flexfields in Oracle E-Business Suite),通过下边这个SQL就可以查询(以Applicaiton Code排序)
SELECT B.APPLICATION_SHORT_NAME,
A.ID_FLEX_CODE,
A.ID_FLEX_NAME,
A.APPLICATION_TABLE_NAME,
A.UNIQUE_ID_COLUMN_NAME,
A.DESCRIPTION
FROM FND_ID_FLEXS A,FND_APPLICATION B
WHERE A.APPLICATION_ID = B.APPLICATION_ID ORDER BY A.APPLICATION_ID;
ID_FLEX_CODE | ID_FLEX_NAME | APPLICATION_TABLE_NAME | DESCRIPTION |
GLAT | Reporting Attributes:Accountin | GL_C |