EBS提供的所有Key Flexfields(KFF)

来源：互联网发布：简单平面图制作软件编辑：程序博客网时间：2024/05/22 01:50

EBS提供了很多标准的KFF，通过下边这个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_CODEID_FLEX_NAMEAPPLICATION_TABLE_NAMEDESCRIPTIONGLATReporting Attributes:AccountinGL_CODE_COMBINATIONSReporting Attributes:General Ledger Accounting FlexfieldGL#Accounting FlexfieldGL_CODE_COMBINATIONSGeneral Ledger Accounting FlexfieldGLLEGL Ledger FlexfieldGL_CODE_COMBINATIONSThe new Ledger Flexfield in General LedgerKEY#Asset Key FlexfieldFA_ASSET_KEYWORDSFlexfield for Asset KeyCAT#Category FlexfieldFA_CATEGORIES_BAsset Category FlexfieldLOC#Location FlexfieldFA_LOCATIONSFlexfield for locationsSERVOracle Service Item FlexfieldMTL_SYSTEM_ITEMS_BOracle Service Item FlexfieldRLOCSales Tax Location FlexfieldAR_LOC_COMBINATIONS_OLDOracle Receivables Sales Tax Location FlexfieldCT#Territory FlexfieldRA_TERRITORIESCustomer Territory FlexfieldZX#eBTax Context FlexfieldZX_API_CODE_COMBINATIONSFECOCost Object FlexfieldFEM_COST_OBJECTSCost Object FlexfieldFEACActivity FlexfieldFEM_ACTIVITIESActivity FlexfieldMCATItem CategoriesMTL_CATEGORIES_BItem category key flexfieldMDSPAccount AliasesMTL_GENERIC_DISPOSITIONSAccount aliasesMICGItem CatalogsMTL_ITEM_CATALOG_GROUPS_BItem catalog group key flexfieldMKTSSales OrdersMTL_SALES_ORDERSSales ordersSERVORACLE_SERVICE_ITEM_FLEXFIELDMTL_SYSTEM_ITEMS_BItem Flex Field that Displays segments in different sequenceMTLLStock LocatorsMTL_ITEM_LOCATIONSStock locatorsMSTKSystem ItemsMTL_SYSTEM_ITEMS_BSystem item key flexfieldFII#Management FlexfieldFII_REPORTING_STRUCTURESManagement Reporting FlexfieldFWKFWK Item FlexfieldFWK_TBX_ITEM_CCIDSFWK Item FlexfieldGRDGrade FlexfieldPER_GRADE_DEFINITIONSGrade FlexfieldJOBJob FlexfieldPER_JOB_DEFINITIONSJob FlexfieldPEAPersonal Analysis FlexfieldPER_ANALYSIS_CRITERIAPersonal Analysis FlexfieldPOSPosition FlexfieldPER_POSITION_DEFINITIONSPosition FlexfieldSCLSoft Coded KeyFlexfieldHR_SOFT_CODING_KEYFLEXLegislation Specific Key FlexfieldCAGRCAGR FlexfieldPER_CAGR_GRADES_DEFCollectively Agreed Grades FlexfieldICXItem Contexts KeyflexHR_ITEM_CONTEXTSItem Contexts KeyflexCMPCompetence FlexfieldPER_COMPETENCE_DEFINITIONSCompetence FlexfieldCOSTCost Allocation FlexfieldPAY_COST_ALLOCATION_KEYFLEXCost Allocation FlexfieldBANKBank Details KeyFlexFieldPAY_EXTERNAL_ACCOUNTSLegislation Specific Key FlexfieldGRPPeople Group FlexfieldPAY_PEOPLE_GROUPSPeople Group FlexfieldRESTraining ResourcesOTA_RESOURCE_DEFINITIONSTraining Resource KeyflexAHLRAHL RouteAHL_ROUTES_BAHL RouteAHLOAHL OperationAHL_OPERATIONS_BAHL OperationACCTAccount StructureJA_CN_ACCOUNT_STRUCTURESNatural Account StructureBPSPSB Position FlexfieldPSB_POSITION_DEFINITIONSPSB Position FlexfieldSGP#Super GroupFA_SUPER_GROUPSSuper GroupGRP#Group AssetFA_GROUP_ASSETSGroup Asset
转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7534059

0 0