DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.FND_ID_FLEX_STRUCTURES_VL

Object Details
Object Name: FND_ID_FLEX_STRUCTURES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.FND_ID_FLEX_STRUCTURES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
APPLICATION_ID NUMBER (10) Yes
ID_FLEX_CODE VARCHAR2 (4) Yes
ID_FLEX_NUM NUMBER (15) Yes
ID_FLEX_STRUCTURE_CODE VARCHAR2 (30) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (10)
CONCATENATED_SEGMENT_DELIMITER VARCHAR2 (1) Yes
CROSS_SEGMENT_VALIDATION_FLAG VARCHAR2 (1) Yes
DYNAMIC_INSERTS_ALLOWED_FLAG VARCHAR2 (1) Yes
ENABLED_FLAG VARCHAR2 (1) Yes
FREEZE_FLEX_DEFINITION_FLAG VARCHAR2 (1) Yes
FREEZE_STRUCTURED_HIER_FLAG VARCHAR2 (1) Yes
SHORTHAND_ENABLED_FLAG VARCHAR2 (1) Yes
SHORTHAND_LENGTH NUMBER (3)
STRUCTURE_VIEW_NAME VARCHAR2 (30)
ID_FLEX_STRUCTURE_NAME VARCHAR2 (30) Yes
DESCRIPTION VARCHAR2 (240)
SHORTHAND_PROMPT VARCHAR2 (80)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      APPLICATION_ID
,      ID_FLEX_CODE
,      ID_FLEX_NUM
,      ID_FLEX_STRUCTURE_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CONCATENATED_SEGMENT_DELIMITER
,      CROSS_SEGMENT_VALIDATION_FLAG
,      DYNAMIC_INSERTS_ALLOWED_FLAG
,      ENABLED_FLAG
,      FREEZE_FLEX_DEFINITION_FLAG
,      FREEZE_STRUCTURED_HIER_FLAG
,      SHORTHAND_ENABLED_FLAG
,      SHORTHAND_LENGTH
,      STRUCTURE_VIEW_NAME
,      ID_FLEX_STRUCTURE_NAME
,      DESCRIPTION
,      SHORTHAND_PROMPT
FROM APPS.FND_ID_FLEX_STRUCTURES_VL;

Dependencies

[top of page]

APPS.FND_ID_FLEX_STRUCTURES_VL references the following:

SchemaAPPS
SynonymFND_ID_FLEX_STRUCTURES
SynonymFND_ID_FLEX_STRUCTURES_TL
APPS.FND_ID_FLEX_STRUCTURES_VL is referenced by following:

SchemaAPPS
Package BodyAP_WEB_EXPENSE_WF - show dependent code
Package BodyAZ_FLEX_COMPILER - show dependent code
Package BodyBEN_DM_DOWNLOAD_DK - show dependent code
Package BodyBEN_DM_UPLOAD_DK - show dependent code
Package BodyCSP_ASL_PUB - show dependent code
ViewEDWBV_ORGA_BUSINESS_GRP_LCV
Package BodyEDW_ITEMS_M_C - show dependent code
Package BodyEDW_ORGANIZATION_M_SIZING - show dependent code
ViewFII_PROD_ASSIGN_TYPE_V
ViewFND_FLEX_CROSS_VALIDATION_V
Package BodyFND_FLEX_DIAGNOSE - show dependent code
Package BodyFND_FLEX_KEY_API - show dependent code
PL/SQL PackageFND_FLEX_KEY_API - show dependent code
ViewFND_FLEX_KEY_SEG_VSET_V
ViewFND_FLEX_SHORTHAND_ALIAS_V
Package BodyFND_FLEX_UPGRADE_UTILITIES - show dependent code
ViewFND_ID_FLEX_STRUCTURES_V
PL/SQL PackageGHR_UTILITY - show dependent code
Package BodyGHR_UTILITY - show dependent code
Package BodyGL_CHART_OF_ACCOUNTS_API_PKG - show dependent code
Package BodyGL_FLEXFIELDS_PKG - show dependent code
Package BodyGL_REP_ATTRIBUTES - show dependent code
Package BodyGMF_MIGRATION - show dependent code
ViewHRFV_DETAILED_SPECIAL_INFO
ViewHRFV_JOB_AND_POS_REQUIREMENTS
ViewHRFV_PERSON_SPECIAL_INFO
Package BodyHRI_BPL_SETUP_DIAGNOSTIC - show dependent code
Package BodyHRWCDCR_PKG - show dependent code
Package BodyHR_DM_AOL_UP - show dependent code
Package BodyHR_DM_COPY - show dependent code
Package BodyHR_DM_INIT - show dependent code
Package BodyHR_ENTRY - show dependent code
PL/SQL PackageHR_FLEXFIELD_INFO - show dependent code
Package BodyHR_FLEXFIELD_INFO - show dependent code
Package BodyHR_ORG_INFORMATION_PKG - show dependent code
Package BodyHR_ORI_BUS - show dependent code
ViewHR_PAY_INTERFACE_SPECIAL_IF_V
Package BodyHR_REPORTS - show dependent code
Package BodyHR_SUMMARY_UTIL - show dependent code
ViewINVFV_ITEM_CATEGORIES
ViewINVFV_ITEM_CATEGORY_TYPES
ViewJG_ZZ_TA_RULE_SETS_V
Package BodyJTF_DIAGNOSTIC_COREAPI - show dependent code
Package BodyLNS_BILLING_BATCH_PUB - show dependent code
ViewMTL_CATEGORIES_V
Package BodyMTL_CATEGORY_SETS_PKG - show dependent code
ViewMTL_CATEGORY_SETS_V
Package BodyOKS_EXTWAR_UTIL_PVT - show dependent code
Package BodyOKS_REV_DISTR_PUB - show dependent code
Package BodyOM_SETUP_VALID_PKG - show dependent code
ViewOTA_SKILLS_V
ViewOTA_SKILL_PROVISIONS_V
Package BodyPAY_AE_ARCHIVE - show dependent code
Package BodyPAY_AE_USER_FUNCTION - show dependent code
Package BodyPAY_IP_STARTUP_UTIL - show dependent code
Package BodyPAY_KW_ARCHIVE - show dependent code
Package BodyPAY_KW_USER_FUNCTION - show dependent code
Package BodyPAY_PAYMENT_XML_PKG - show dependent code
Package BodyPAY_PAYROLL_XML_EXTRACT_PKG - show dependent code
ViewPAY_PRE_PAYMENTS_V3
Package BodyPAY_RESTRICT_VAL_PKG - show dependent code
Package BodyPAY_SLA_PKG - show dependent code
Package BodyPAY_US_DB_PER_SETUP - show dependent code
PL/SQL PackagePA_HR_COMPETENCE_UTILS - show dependent code
Package BodyPA_HR_COMPETENCE_UTILS - show dependent code
ViewPERBV_CN_SPEC_INFO_V
Package BodyPER_ASSIGNMENTS_F2_PKG - show dependent code
ViewPER_COLL_AGREE_GRADES_V
Package BodyPER_DB_PER_SETUP - show dependent code
Package BodyPER_IT_QH_TAX - show dependent code
Package BodyPER_JGR_BUS - show dependent code
ViewPER_JOB_GROUPS_V
ViewPER_JP_SPECIAL_INFORMATION
Package BodyPER_QH_FIND_QUERY - show dependent code
Package BodyPER_QH_MAINTAIN_QUERY - show dependent code
PL/SQL PackagePER_RI_CONFIG_TECH_SUMMARY - show dependent code
Package BodyPER_RI_CONFIG_UTILITIES - show dependent code
Package BodyPER_SIT_PKG - show dependent code
ViewPER_SPECIAL_INFO_TYPES_V
ViewPER_SPECIAL_INFO_TYPES_V2
ViewPOFV_MC_RECEIVING_SUBLEDGERS
ViewPOFV_RECEIVING_SUBLEDGERS
Package BodyPOS_PRODUCT_SERVICE_UTL_PKG - show dependent code
Package BodyPQH_UTILITY - show dependent code
Package BodyPQP_PENSION_EXTRACTS - show dependent code
Package BodyPQP_US_PENSION_EXTRACTS - show dependent code
Package BodyPSA_REP_ATTRIBUTES - show dependent code
ViewPSBFV_DATA_EXTRACTS
Package BodyPSB_FLEX_MAPPING_PVT - show dependent code
Package BodyPSB_HR_EXTRACT_DATA_PVT - show dependent code
Package BodyPSB_HR_POPULATE_DATA_PVT - show dependent code
Package BodyXLA_ACCOUNTING_CACHE_PKG - show dependent code
Package BodyXLA_AE_CODE_COMBINATION_PKG - show dependent code
Package BodyXLA_CMP_TAD_PKG - show dependent code
Package BodyXLA_FLEX_PKG - show dependent code
Package BodyXLA_FLEX_UTIL - show dependent code
Package BodyXLA_HIST_LEDGER_UPG_PKG - show dependent code
Package BodyXLA_JE_VALIDATION_PKG - show dependent code
Package BodyXLA_TAB_PKG - show dependent code
ViewZX_FC_INTENDED_USE_V
ViewZX_FC_PRODUCT_FISCAL_V
Package BodyZX_TCM_GET_EXCEPT_PKG - show dependent code