Descriptive Flex Field List

来源:互联网 发布:软件开发工程师要求 编辑:程序博客网 时间:2024/05/23 01:24

Query:

SELECT CONCATENATED_SEGS_VIEW_NAME,APPLICATION_TABLE_NAME,DESCRIPTIVE_FLEXFIELD_NAME,TITLE,CONTEXT_COLUMN_NAME,DESCRIPTION
FROM FND_DESCRIPTIVE_FLEXS_VL
WHERE APPLICATION_ID = 401  --Take Inventory Module as Example
ORDER BY APPLICATION_TABLE_NAME;


List:

CONCATENATED_SEGS_VIEW_NAMEAPPLICATION_TABLE_NAMEDESCRIPTIVE_FLEXFIELD_NAMETITLECONTEXT_COLUMN_NAMEDESCRIPTIONMTL_ABC_ASSIGNMENT_GROUPS_DFVMTL_ABC_ASSIGNMENT_GROUPSMTL_ABC_ASSIGNMENT_GROUPSABC groupsATTRIBUTE_CATEGORY MTL_ABC_COMPILE_HEADERS_DFVMTL_ABC_COMPILE_HEADERSMTL_ABC_COMPILE_HEADERSABC Analysis Compile HeadersATTRIBUTE_CATEGORYABC Analysis Compile Headers - Generic Descriptive flex fieldsMTL_ACTIONS_B_DFVMTL_ACTIONS_BMTL_ACTIONSMaintain ActionsATTRIBUTE_CATEGORY MTL_ATP_RULES_DFVMTL_ATP_RULESMTL_ATP_RULESATP Computation RulesATTRIBUTE_CATEGORYATP Rules Flex FieldMTL_CATEGORIES_B_DFVMTL_CATEGORIES_BMTL_CATEGORIESItem CategoriesATTRIBUTE_CATEGORYAdditional Item Category InformationMTL_CC_ENTRIES_INTERFACE_DFVMTL_CC_ENTRIES_INTERFACECycle Count Entries InterfaceCycle Count Entries InterfaceATTRIBUTE_CATEGORY MTL_CC_SCHEDULE_REQUESTS_DFVMTL_CC_SCHEDULE_REQUESTSMTL_CC_SCHEDULE_REQUESTSSchedule RequestsATTRIBUTE_CATEGORY MTL_COMMODITY_CODES_DFVMTL_COMMODITY_CODESMTL_COMMODITY_CODESCustomer Item Commodity CodesATTRIBUTE_CATEGORYCustomer Item Commodity CodesMTL_CROSS_REFERENCES_DFVMTL_CROSS_REFERENCESMTL_CROSS_REFERENCESItem cross-referencesATTRIBUTE_CATEGORYAdditional Item cross-reference informationMTL_CROSS_REFERENCE_TYPES_DFVMTL_CROSS_REFERENCE_TYPESMTL_CROSS_REFERENCE_TYPESItem cross-reference typesATTRIBUTE_CATEGORY MTL_CUSTOMER_ITEMS_DFVMTL_CUSTOMER_ITEMSMTL_CUSTOMER_ITEMSCustomer ItemsATTRIBUTE_CATEGORYCustomer ItemsMTL_CUSTOMER_ITEM_XREFS_DFVMTL_CUSTOMER_ITEM_XREFSMTL_CUSTOMER_ITEM_XREFSCustomer Item Cross ReferencesATTRIBUTE_CATEGORYCustomer Item Cross ReferencesMTL_CYCLE_COUNT_ENTRIES_DFVMTL_CYCLE_COUNT_ENTRIESMTL_CYCLE_COUNT_ENTRIESCycle Count EntriesATTRIBUTE_CATEGORY MTL_CYCLE_COUNT_ENTRIES1_DFVMTL_CYCLE_COUNT_ENTRIESMTL_CC_ENTRIES_ADDITIONAL_INFOAdditional Cycle Count Entry InformationCOUNT_DATE_CURRENTAdditional Cycle Count Entry InformationMTL_CYCLE_COUNT_ENTRIES2_DFVMTL_CYCLE_COUNT_ENTRIESMTL_CC_ENTRIES_LOT_NUMBERCycle Count Lot NumberLOT_CONTROLDevelopment dflex for lot numberMTL_CYCLE_COUNT_HEADERS_DFVMTL_CYCLE_COUNT_HEADERSMTL_CYCLE_COUNT_HEADERSCycle count headersATTRIBUTE_CATEGORYCycle count headersMTL_DEMAND_DFVMTL_DEMANDMTL_DEMANDItem reservationsATTRIBUTE_CATEGORY MTL_DEMAND_INTERFACE_DFVMTL_DEMAND_INTERFACEMTL_DEMAND_INTERFACEDemand interfaceATTRIBUTE_CATEGORY MTL_EAM_ASSET_ACTIVITIES_DFVMTL_EAM_ASSET_ACTIVITIESMTL_EAM_ASSET_ACTIVITIESAsset Activity AssociationATTRIBUTE_CATEGORYMTL_EAM_ASSET_ACTIVITIESMTL_EAM_ASSET_ATTR_VALUES_DFVMTL_EAM_ASSET_ATTR_VALUESMTL_EAM_ASSET_ATTR_VALUESAsset AttributesATTRIBUTE_CATEGORYMTL_EAM_ASSET_ATTR_VALUESMTL_EAM_NETWORK_ASSETS_DFVMTL_EAM_NETWORK_ASSETSMTL_EAM_NETWORK_ASSETSAsset Routes AssociationATTRIBUTE_CATEGORYMTL_EAM_NETWORK_ASSETSMTL_GENERIC_DISPOSITIONS_DFVMTL_GENERIC_DISPOSITIONSMTL_GENERIC_DISPOSITIONSAccount aliasesATTRIBUTE_CATEGORY MTL_GRADES_B_DFVMTL_GRADES_BMTL_GRADESMaintain GradesATTRIBUTE_CATEGORY MTL_INTERCOMPANY_PARAMETER_DFVMTL_INTERCOMPANY_PARAMETERSMTL_INTERCOMPANY_PARAMETERSIntercompany relationsATTRIBUTE_CATEGORYIntercompany relationsMTL_INTERORG_PARAMETERS_DFVMTL_INTERORG_PARAMETERSMTL_INTERORG_PARAMETERSInter-organization parametersATTRIBUTE_CATEGORYInter-organization parametersMTL_INTERORG_SHIP_METHODS_DFVMTL_INTERORG_SHIP_METHODSMTL_INTERORG_SHIP_METHODSAdditional Info For Inter-Org Ship MethodATTRIBUTE_CATEGORY MTL_ITEM_CATALOG_GROUPS_B_DFVMTL_ITEM_CATALOG_GROUPS_BMTL_ITEM_CATALOG_GROUPSItem Catalog GroupsATTRIBUTE_CATEGORYItem Catalog GroupsMTL_ITEM_LOCATIONS_DFVMTL_ITEM_LOCATIONSMTL_ITEM_LOCATIONSStock locatorsATTRIBUTE_CATEGORY MTL_ITEM_REVISIONS_B_DFVMTL_ITEM_REVISIONS_BMTL_ITEM_REVISIONSItem RevisionsATTRIBUTE_CATEGORYItem RevisionsMTL_ITEM_STATUS_DFVMTL_ITEM_STATUS_TLMTL_ITEM_STATUSItem statusATTRIBUTE_CATEGORY MTL_ITEM_SUB_INVENTORIES_DFVMTL_ITEM_SUB_INVENTORIESMTL_ITEM_SUB_INVENTORIESItem SubinventoriesATTRIBUTE_CATEGORY MTL_ITEM_TEMPLATES_DFVMTL_ITEM_TEMPLATES_BMTL_ITEM_TEMPLATESItem Template Descriptive FlexfieldATTRIBUTE_CATEGORYItem Template Descriptive FlexfieldMTL_KANBAN_CARDS_DFVMTL_KANBAN_CARDSMTL_KANBAN_CARDSKanban CardsATTRIBUTE_CATEGORY MTL_KANBAN_CARD_ACTIVITY_DFVMTL_KANBAN_CARD_ACTIVITYMTL_KANBAN_CARD_ACTIVITYKanban Card ActivityATTRIBUTE_CATEGORY MTL_KANBAN_PULL_SEQUENCES_DFVMTL_KANBAN_PULL_SEQUENCESMTL_KANBAN_PULL_SEQUENCESPull SequencesATTRIBUTE_CATEGORY MTL_LOT_NUMBERS_DFVMTL_LOT_NUMBERSMTL_LOT_NUMBERSMaintain Lot NumbersATTRIBUTE_CATEGORY MTL_LOT_NUMBERS1_DFVMTL_LOT_NUMBERSLot AttributesLot AttributesLOT_ATTRIBUTE_CATEGORYLot Attributes Descriptive Flex fieldMTL_MANUFACTURERS_DFVMTL_MANUFACTURERSMTL_MANUFACTURERSManufacturersATTRIBUTE_CATEGORY MTL_MATERIAL_TRANSACTIONS_DFVMTL_MATERIAL_TRANSACTIONSMTL_MATERIAL_TRANSACTIONSTransaction historyATTRIBUTE_CATEGORY MTL_MFG_PART_NUMBERS_DFVMTL_MFG_PART_NUMBERSMTL_MFG_PART_NUMBERSManufacturer Part NumberATTRIBUTE_CATEGORY MTL_MOVEMENT_PARAMETERS_DFVMTL_MOVEMENT_PARAMETERSMTL_MOVEMENT_PARAMETERSMovement ParametersATTRIBUTE_CATEGORYMovement ParametersMTL_MOVEMENT_STATISTICS_DFVMTL_MOVEMENT_STATISTICSMTL_MOVEMENT_STATISTICSMovement StatisticsATTRIBUTE_CATEGORYMovement StatisticsMTL_PARAMETERS_DFVMTL_PARAMETERSMTL_PARAMETERSOrganization parametersATTRIBUTE_CATEGORY MTL_PHYSICAL_ADJUSTMENTS_DFVMTL_PHYSICAL_ADJUSTMENTSMTL_PHYSICAL_ADJUSTMENTSAdditional Item/Adjustment InformationLOT_SERIAL_CONTROLSAdditional Item/Adjustment InformationMTL_PHYSICAL_INVENTORIES_DFVMTL_PHYSICAL_INVENTORIESMTL_PHYSICAL_INVENTORIESPhysical InventoryATTRIBUTE_CATEGORY MTL_PHYSICAL_INVENTORY_TA1_DFVMTL_PHYSICAL_INVENTORY_TAGSMTL_PHYSICAL_TAGS_LOT_SERIALLot/Serial Number InformationLOT_SERIAL_CONTROLSAdditional Tag informationMTL_PHYSICAL_INVENTORY_TAG_DFVMTL_PHYSICAL_INVENTORY_TAGSMTL_PHYSICAL_INVENTORY_TAGSPhysical inventory tagsATTRIBUTE_CATEGORY MTL_PLANNERS_DFVMTL_PLANNERSMTL_PLANNERSPlannersATTRIBUTE_CATEGORY MTL_RELATED_ITEMS_DFVMTL_RELATED_ITEMSMTL_RELATED_ITEMSItem RelationshipsATTR_CONTEXTItem Relationships Descriptive FlexfieldMTL_RESERVATIONS_DFVMTL_RESERVATIONSMTL_RESERVATIONSReservationsATTRIBUTE_CATEGORYReservations descriptive flexMTL_RESERVATIONS_INTERFACE_DFVMTL_RESERVATIONS_INTERFACEMTL_RESERVATIONS_INTERFACEReservations InterfaceATTRIBUTE_CATEGORY MTL_RTG_ITEM_REVISIONS_DFVMTL_RTG_ITEM_REVISIONSMTL_RTG_ITEM_REVISIONSRouting revisionsATTRIBUTE_CATEGORY MTL_SECONDARY_INVENTORIES_DFVMTL_SECONDARY_INVENTORIESMTL_SECONDARY_INVENTORIESSubinventoriesATTRIBUTE_CATEGORY MTL_SERIAL_NUMBERS1_DFVMTL_SERIAL_NUMBERSSerial AttributesSerial AttributesSERIAL_ATTRIBUTE_CATEGORYSerial AttributesMTL_SERIAL_NUMBERS_DFVMTL_SERIAL_NUMBERSMTL_SERIAL_NUMBERSSerial numbersATTRIBUTE_CATEGORY MTL_SHORT_CHK_PARAM_DFVMTL_SHORT_CHK_PARAMMTL_SHORT_CHK_PARAMShortage ParameterATTRIBUTE_CATEGORYShortage Parameter Descriptive FlexfieldMTL_SYSTEM_ITEMS_B_DFVMTL_SYSTEM_ITEMS_BMTL_SYSTEM_ITEMSItemsATTRIBUTE_CATEGORY MTL_TRANSACTIONS_INTERFACE_DFVMTL_TRANSACTIONS_INTERFACEMTL_TRANSACTIONS_INTERFACETransaction interfaceATTRIBUTE_CATEGORY MTL_TRANSACTION_FLOW_HEADE_DFVMTL_TRANSACTION_FLOW_HEADERSMTL_TXN_FLOW_HEADERS_DFFTransaction Flow Headers DFFATTRIBUTE_CATEGORYDesc Flex for Trx Flow HeaderMTL_TRANSACTION_FLOW_LINES_DFVMTL_TRANSACTION_FLOW_LINESMTL_TXN_FLOW_LINES_DFFTransaction Flow Lines DFFATTRIBUTE_CATEGORYDesc Flex for Trx flow LinesMTL_TRANSACTION_REASONS_DFVMTL_TRANSACTION_REASONSMTL_TRANSACTION_REASONSTransaction ReasonsATTRIBUTE_CATEGORYTransaction ReasonsMTL_TRANSACTION_TYPES_DFVMTL_TRANSACTION_TYPESMTL_TRANSACTION_TYPESTransaction typesATTRIBUTE_CATEGORY MTL_TXN_REQUEST_HEADERS_DFVMTL_TXN_REQUEST_HEADERSMTL_TXN_REQUEST_HEADERSTransfer Order HeaderATTRIBUTE_CATEGORYTransfer Order HeaderMTL_TXN_REQUEST_LINES_DFVMTL_TXN_REQUEST_LINESMTL_TXN_REQUEST_LINESTransfer Order LinesATTRIBUTE_CATEGORY MTL_TXN_SOURCE_TYPES_DFVMTL_TXN_SOURCE_TYPESMTL_TXN_SOURCE_TYPESTransaction source typesATTRIBUTE_CATEGORYMTL_TXN_SOURCE_TYPESMTL_TXN_SOURCE_TYPES1_DFVMTL_TXN_SOURCE_TYPESTransaction SourceTransaction SourceTRANSACTION_SOURCE_CATEGORYTransaction Source Validation Descriptive FlexMTL_UNITS_OF_MEASURE_TL_DFVMTL_UNITS_OF_MEASURE_TLMTL_UNITS_OF_MEASUREDefine Unit of MeasureATTRIBUTE_CATEGORY MTL_UOM_CLASSES_TL_DFVMTL_UOM_CLASSES_TLMTL_UOM_CLASSESUnit of measure classesATTRIBUTE_CATEGORY ORG_FREIGHT_TL_DFVORG_FREIGHT_TLORG_FREIGHTFreight carriersATTRIBUTE_CATEGORY 



原创粉丝点击