Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - FII Tables and Views

TABLE - FII.EDW_AP_APPY_CHECK_LSTG

TABLE - FII.EDW_AP_APPY_CHECK_LTC

TABLE - FII.EDW_AP_APPY_PAYMENT_LSTG

TABLE - FII.EDW_AP_APPY_PAYMENT_LTC

TABLE - FII.EDW_AP_APPY_PYMT_MTHD_LSTG

TABLE - FII.EDW_AP_APPY_PYMT_MTHD_LTC

TABLE - FII.EDW_AP_PAYMENT_A_LTC

TABLE - FII.EDW_AP_PAYMENT_M

TABLE - FII.EDW_AP_PAY_TERM_A_LTC

TABLE - FII.EDW_AP_PAY_TERM_M

TABLE - FII.EDW_AP_PTRM_PAY_TERM_LSTG

TABLE - FII.EDW_AP_PTRM_PAY_TERM_LTC

TABLE - FII.EDW_ARDN_DOC_NUM_LSTG

TABLE - FII.EDW_ARDN_DOC_NUM_LTC

TABLE - FII.EDW_ARTT_CODE_LSTG

TABLE - FII.EDW_ARTT_CODE_LTC

TABLE - FII.EDW_ARTT_TYPE_LSTG

TABLE - FII.EDW_ARTT_TYPE_LTC

TABLE - FII.EDW_AR_DOC_NUM_A_LTC

TABLE - FII.EDW_AR_DOC_NUM_M

TABLE - FII.EDW_AR_TRX_TYPE_A_LTC

TABLE - FII.EDW_AR_TRX_TYPE_M

TABLE - BIS.EDW_CONS_SET_OF_BOOKS

TABLE - FII.EDW_CURRENCY_A_LTC

TABLE - FII.EDW_CURRENCY_M

TABLE - FII.EDW_CURR_CURRENCY_LSTG

TABLE - FII.EDW_CURR_CURRENCY_LTC

TABLE - BIS.EDW_EQUI_SET_OF_BOOKS

TABLE - BIS.EDW_GL_ACCT10_M

TABLE - BIS.EDW_GL_ACCT1_M

TABLE - BIS.EDW_GL_ACCT2_M

TABLE - BIS.EDW_GL_ACCT3_M

TABLE - BIS.EDW_GL_ACCT4_M

TABLE - BIS.EDW_GL_ACCT5_M

TABLE - BIS.EDW_GL_ACCT6_M

TABLE - BIS.EDW_GL_ACCT7_M

TABLE - BIS.EDW_GL_ACCT8_M

TABLE - BIS.EDW_GL_ACCT9_M

TABLE - FII.EDW_GL_BOOK_A_LTC

TABLE - FII.EDW_GL_BOOK_BOOK_LSTG

TABLE - FII.EDW_GL_BOOK_BOOK_LTC

TABLE - FII.EDW_GL_BOOK_FA_BOOK_LSTG

TABLE - FII.EDW_GL_BOOK_FA_BOOK_LTC

TABLE - FII.EDW_GL_BOOK_M

TABLE - FII.EDW_HOLD_A_LTC

TABLE - FII.EDW_HOLD_HOLD_LSTG

TABLE - FII.EDW_HOLD_HOLD_LTC

TABLE - FII.EDW_HOLD_HOLD_TYPE_LSTG

TABLE - FII.EDW_HOLD_HOLD_TYPE_LTC

TABLE - FII.EDW_HOLD_M

TABLE - FII.EDW_ILTY_INV_LN_TYP_LSTG

TABLE - FII.EDW_ILTY_INV_LN_TYP_LTC

TABLE - FII.EDW_INV_LN_TYP_A_LTC

TABLE - FII.EDW_INV_LN_TYP_M

TABLE - FII.EDW_INV_SOURCE_A_LTC

TABLE - FII.EDW_INV_SOURCE_M

TABLE - FII.EDW_INV_TYPE_A_LTC

TABLE - FII.EDW_INV_TYPE_M

TABLE - FII.EDW_IVSR_INV_SOURCE_LSTG

TABLE - FII.EDW_IVSR_INV_SOURCE_LTC

TABLE - FII.EDW_IVTY_INV_LSTG

TABLE - FII.EDW_IVTY_INV_LTC

TABLE - FII.EDW_IVTY_INV_TYPE_LSTG

TABLE - FII.EDW_IVTY_INV_TYPE_LTC

TABLE - FII.EDW_PA_EXP_TYPE_A_LTC

TABLE - FII.EDW_PA_EXP_TYPE_M

TABLE - FII.EDW_PA_PAEX_EXP_TYPE_LSTG

TABLE - FII.EDW_PA_PAEX_EXP_TYPE_LTC

TABLE - FII.EDW_PROJECT_A_LTC

TABLE - FII.EDW_PROJECT_M

TABLE - FII.EDW_PROJ_CATEG1_LSTG

TABLE - FII.EDW_PROJ_CATEG1_LTC

TABLE - FII.EDW_PROJ_CATEG2_LSTG

TABLE - FII.EDW_PROJ_CATEG2_LTC

TABLE - FII.EDW_PROJ_CATEG3_LSTG

TABLE - FII.EDW_PROJ_CATEG3_LTC

TABLE - FII.EDW_PROJ_CATEG4_LSTG

TABLE - FII.EDW_PROJ_CATEG4_LTC

TABLE - FII.EDW_PROJ_CATEG5_LSTG

TABLE - FII.EDW_PROJ_CATEG5_LTC

TABLE - FII.EDW_PROJ_CATEG6_LSTG

TABLE - FII.EDW_PROJ_CATEG6_LTC

TABLE - FII.EDW_PROJ_CATEG7_LSTG

TABLE - FII.EDW_PROJ_CATEG7_LTC

TABLE - FII.EDW_PROJ_CLS1_LSTG

TABLE - FII.EDW_PROJ_CLS1_LTC

TABLE - FII.EDW_PROJ_CLS2_LSTG

TABLE - FII.EDW_PROJ_CLS2_LTC

TABLE - FII.EDW_PROJ_CLS3_LSTG

TABLE - FII.EDW_PROJ_CLS3_LTC

TABLE - FII.EDW_PROJ_CLS4_LSTG

TABLE - FII.EDW_PROJ_CLS4_LTC

TABLE - FII.EDW_PROJ_CLS5_LSTG

TABLE - FII.EDW_PROJ_CLS5_LTC

TABLE - FII.EDW_PROJ_CLS6_LSTG

TABLE - FII.EDW_PROJ_CLS6_LTC

TABLE - FII.EDW_PROJ_CLS7_LSTG

TABLE - FII.EDW_PROJ_CLS7_LTC

TABLE - FII.EDW_PROJ_PRJ_TYP_LSTG

TABLE - FII.EDW_PROJ_PRJ_TYP_LTC

TABLE - FII.EDW_PROJ_PROJECT_LSTG

TABLE - FII.EDW_PROJ_PROJECT_LTC

TABLE - FII.EDW_PROJ_TASK_LSTG

TABLE - FII.EDW_PROJ_TASK_LTC

TABLE - FII.EDW_PROJ_TOP_TASK_LSTG

TABLE - FII.EDW_PROJ_TOP_TASK_LTC

TABLE - FII.EDW_RELEASE_A_LTC

TABLE - FII.EDW_RELEASE_M

TABLE - FII.EDW_RESR_REV_SRC_LSTG

TABLE - FII.EDW_RESR_REV_SRC_LTC

TABLE - FII.EDW_REV_SOURCE_A_LTC

TABLE - FII.EDW_REV_SOURCE_M

TABLE - FII.EDW_RLSE_RELEASE_LSTG

TABLE - FII.EDW_RLSE_RELEASE_LTC

TABLE - FII.EDW_RLSE_RELEASE_TYPE_LSTG

TABLE - FII.EDW_RLSE_RELEASE_TYPE_LTC

TABLE - BIS.EDW_SEGMENT_CLASSES

TABLE - BIS.EDW_SET_OF_BOOKS

TABLE - FII.EDW_SICM_SIC_LSTG

TABLE - FII.EDW_SICM_SIC_LTC

TABLE - FII.EDW_SIC_CODE_A_LTC

TABLE - FII.EDW_SIC_CODE_M

TABLE - FII.EDW_TIME_A_LTC

TABLE - FII.EDW_TIME_CAL_DAY_LSTG

TABLE - FII.EDW_TIME_CAL_DAY_LTC

TABLE - FII.EDW_TIME_CAL_NAME_LSTG

TABLE - FII.EDW_TIME_CAL_NAME_LTC

TABLE - FII.EDW_TIME_CAL_PERIOD_LSTG

TABLE - FII.EDW_TIME_CAL_PERIOD_LTC

TABLE - FII.EDW_TIME_CAL_QTR_LSTG

TABLE - FII.EDW_TIME_CAL_QTR_LTC

TABLE - FII.EDW_TIME_CAL_YEAR_LSTG

TABLE - FII.EDW_TIME_CAL_YEAR_LTC

TABLE - FII.EDW_TIME_DAY_LSTG

TABLE - FII.EDW_TIME_DAY_LTC

TABLE - FII.EDW_TIME_EP_CAL_NAME_LSTG

TABLE - FII.EDW_TIME_EP_CAL_NAME_LTC

TABLE - FII.EDW_TIME_EP_CAL_PERIOD_LSTG

TABLE - FII.EDW_TIME_EP_CAL_PERIOD_LTC

TABLE - FII.EDW_TIME_EP_CAL_QTR_LSTG

TABLE - FII.EDW_TIME_EP_CAL_QTR_LTC

TABLE - FII.EDW_TIME_EP_CAL_YEAR_LSTG

TABLE - FII.EDW_TIME_EP_CAL_YEAR_LTC

TABLE - FII.EDW_TIME_HALF_MONTH_LSTG

TABLE - FII.EDW_TIME_HALF_MONTH_LTC

TABLE - FII.EDW_TIME_HALF_YEAR_LSTG

TABLE - FII.EDW_TIME_HALF_YEAR_LTC

TABLE - FII.EDW_TIME_M

TABLE - FII.EDW_TIME_MONTH_LSTG

TABLE - FII.EDW_TIME_MONTH_LTC

TABLE - FII.EDW_TIME_PA_PERIOD_LSTG

TABLE - FII.EDW_TIME_PA_PERIOD_LTC

TABLE - FII.EDW_TIME_PERIOD_445_LSTG

TABLE - FII.EDW_TIME_PERIOD_445_LTC

TABLE - FII.EDW_TIME_QTR_LSTG

TABLE - FII.EDW_TIME_QTR_LTC

TABLE - FII.EDW_TIME_WEEK_LSTG

TABLE - FII.EDW_TIME_WEEK_LTC

TABLE - FII.EDW_TIME_YEAR_LSTG

TABLE - FII.EDW_TIME_YEAR_LTC

TABLE - BIS.EDW_VBH_ROOTS

TABLE - BIS.EDW_VBH_TEMP1

TABLE - BIS.EDW_VBH_TEMP10

TABLE - BIS.EDW_VBH_TEMP2

TABLE - BIS.EDW_VBH_TEMP3

TABLE - BIS.EDW_VBH_TEMP4

TABLE - BIS.EDW_VBH_TEMP5

TABLE - BIS.EDW_VBH_TEMP6

TABLE - BIS.EDW_VBH_TEMP7

TABLE - BIS.EDW_VBH_TEMP8

TABLE - BIS.EDW_VBH_TEMP9

TABLE - FII.FII_AP_AGING_BKTS_B

TABLE - FII.FII_AP_BUCKET_CALCS

TABLE - FII.FII_AP_DBI_LOG_EXP_T

TABLE - FII.FII_AP_DBI_LOG_PS_T

TABLE - FII.FII_AP_DBI_LOG_T

TABLE - FII.FII_AP_DISCOUNTS_SUMMARY

TABLE - FII.FII_AP_DUE_COUNTS_B

TABLE - FII.FII_AP_FUNC_RATES_TEMP

TABLE - FII.FII_AP_HOLD_DATA_F

TABLE - FII.FII_AP_HOLD_DATA_FSTG

TABLE - FII.FII_AP_HOLD_HIST_B

TABLE - FII.FII_AP_HOLD_MSNG_RATES

TABLE - FII.FII_AP_INDEX_TEMP

TABLE - FII.FII_AP_INVH_MSNG_RATES

TABLE - FII.FII_AP_INVOICE_B

TABLE - FII.FII_AP_INVOICE_IDS

TABLE - FII.FII_AP_INV_B

TABLE - FII.FII_AP_INV_DIST_F

TABLE - FII.FII_AP_INV_DIST_T

TABLE - FII.FII_AP_INV_HOLDS_B

TABLE - FII.FII_AP_INV_ID

TABLE - FII.FII_AP_INV_LINES_F

TABLE - FII.FII_AP_INV_LINES_FSTG

TABLE - FII.FII_AP_INV_ON_HOLD_F

TABLE - FII.FII_AP_INV_ON_HOLD_FSTG

TABLE - FII.FII_AP_INV_PAYMTS_F

TABLE - FII.FII_AP_INV_PAYMTS_FSTG

TABLE - FII.FII_AP_INV_STG

TABLE - FII.FII_AP_IPAY_MSNG_RATES

TABLE - FII.FII_AP_LINE_MSNG_RATES

TABLE - FII.FII_AP_OP_INDICATOR_SUMMARY

TABLE - FII.FII_AP_PAY_CHK_STG

TABLE - FII.FII_AP_PAY_SCHED_B

TABLE - FII.FII_AP_PAY_SCHED_ID

TABLE - FII.FII_AP_PAY_SCHED_TEMP

TABLE - FII.FII_AP_PREPAY_T

TABLE - FII.FII_AP_PREPAY_WH_STG

TABLE - FII.FII_AP_PS_BUCKETS

TABLE - FII.FII_AP_PS_RATES_TEMP

TABLE - FII.FII_AP_PS_WORK_JOBS

TABLE - FII.FII_AP_SCHP_MSNG_RATES

TABLE - FII.FII_AP_SCH_PAYMTS_F

TABLE - FII.FII_AP_SCH_PAYMTS_FSTG

TABLE - FII.FII_AP_SUM_WORK_JOBS

TABLE - FII.FII_AP_TMP_HOLD_PK

TABLE - FII.FII_AP_TMP_INVH_PK

TABLE - FII.FII_AP_TMP_IPAY_PK

TABLE - FII.FII_AP_TMP_LINE_PK

TABLE - FII.FII_AP_TMP_SCHP_PK

TABLE - FII.FII_AP_TRANS_BACKLOG_SUMMARY

TABLE - FII.FII_AP_UNPOST_HEADERS_T

TABLE - FII.FII_AP_WH_TAX_T

TABLE - FII.FII_AR_ADJUSTMENTS_F

TABLE - FII.FII_AR_ADJ_UPDATE_GT

TABLE - FII.FII_AR_AGING_DISPUTES

TABLE - FII.FII_AR_AGING_RECEIPTS

TABLE - FII.FII_AR_AGING_RECEIVABLES

TABLE - FII.FII_AR_CACCTS_DELTA_GT

TABLE - FII.FII_AR_CACCTS_D_GT

TABLE - FII.FII_AR_CACCTS_TMP_GT

TABLE - FII.FII_AR_CASH_FSTG

TABLE - FII.FII_AR_CURR_RATES_T

TABLE - FII.FII_AR_CUST_HIER_D_GT

TABLE - FII.FII_AR_CUST_HIER_TMP_GT

TABLE - FII.FII_AR_CUST_HIER_UI_GT

TABLE - FII.FII_AR_CUST_LNODES_GT

TABLE - FII.FII_AR_CUST_RLNS_GT

TABLE - FII.FII_AR_DISPUTE_HISTORY_F

TABLE - FII.FII_AR_DISP_UPDATE_GT

TABLE - FII.FII_AR_DSO_SETUP

TABLE - FII.FII_AR_HELP_COLLECTORS

TABLE - FII.FII_AR_HELP_MKT_CLASSES

TABLE - FII.FII_AR_MARKER_GT

TABLE - FII.FII_AR_OPEN_INSTALLMENT_F

TABLE - FII.FII_AR_OPEN_INSTALLMENT_FSTG

TABLE - FII.FII_AR_OPERATIONS_SUMMARY

TABLE - FII.FII_AR_OPER_CUST_SUMMARY_F

TABLE - FII.FII_AR_PARTIES_DELTA_GT

TABLE - FII.FII_AR_PARTIES_LEVEL1_GT

TABLE - FII.FII_AR_PARTIES_LEVEL2_GT

TABLE - FII.FII_AR_PAYSCH_DELETE_GT

TABLE - FII.FII_AR_PAYSCH_INSERT_GT

TABLE - FII.FII_AR_PAYSCH_MERGE_GT

TABLE - FII.FII_AR_PMT_SCHEDULES_F

TABLE - FII.FII_AR_RECAPP_DELETE_GT

TABLE - FII.FII_AR_RECAPP_INSERT_GT

TABLE - FII.FII_AR_RECAPP_MERGE_GT

TABLE - FII.FII_AR_RECEIPTS_DELETE_T

TABLE - FII.FII_AR_RECEIPTS_F

TABLE - FII.FII_AR_REC_AGING_SUM_GT

TABLE - FII.FII_AR_REC_FSTG

TABLE - FII.FII_AR_REVENUE_B

TABLE - FII.FII_AR_REVENUE_F_DLOG

TABLE - FII.FII_AR_REVENUE_ID

TABLE - FII.FII_AR_REVENUE_JOBS

TABLE - FII.FII_AR_REVENUE_STG

TABLE - FII.FII_AR_REV_ACCTS

TABLE - FII.FII_AR_RISK_INDICATOR_F

TABLE - FII.FII_AR_SALES_CREDITS

TABLE - FII.FII_AR_SALES_CREDITS_D_T

TABLE - FII.FII_AR_SCHEDULED_DISC_F

TABLE - FII.FII_AR_SETUP

TABLE - FII.FII_AR_SUMMARY_GT

TABLE - FII.FII_AR_TOP_TO_SOURCE_GT

TABLE - FII.FII_AR_TPDUE_AGRT_F

TABLE - FII.FII_AR_TPDUE_BASE_F

TABLE - FII.FII_AR_TRANSACTIONS_F

TABLE - FII.FII_AR_TRANS_DELETE_GT

TABLE - FII.FII_AR_TRX_DIST_F

TABLE - FII.FII_AR_TRX_DIST_FSTG

TABLE - FII.FII_AR_TRX_DIST_F_DLOG

TABLE - FII.FII_AR_TRX_MSNG_RT

TABLE - FII.FII_BUDGET_BASE

TABLE - FII.FII_BUDGET_BASE_T

TABLE - FII.FII_BUDGET_BASE_UPG_T

TABLE - FII.FII_BUDGET_DELTAS

TABLE - FII.FII_BUDGET_INTERFACE

TABLE - FII.FII_BUDGET_STG

TABLE - FII.FII_CCC_SEC_INTERFACE

TABLE - FII.FII_CC_MGR_HIERARCHIES

TABLE - FII.FII_CC_PMV_AGRT_NODES

TABLE - FII.FII_CHANGE_LOG

TABLE - FII.FII_COLLECTORS

TABLE - FII.FII_COMPANY_GRANTS

TABLE - FII.FII_COMPANY_HIERARCHIES

TABLE - FII.FII_COMPANY_HIER_GT

TABLE - FII.FII_COMPANY_SETS

TABLE - FII.FII_COM_CC_DIM_MAPS

TABLE - FII.FII_COM_CC_MAPPINGS

TABLE - FII.FII_COM_PMV_AGRT_NODES

TABLE - FII.FII_COST_CENTER_GRANTS

TABLE - FII.FII_COST_CTR_HIERARCHIES

TABLE - FII.FII_COST_CTR_HIER_GT

TABLE - FII.FII_CURR_CONV_RATES

TABLE - FII.FII_CURR_CONV_RATES_GT

TABLE - FII.FII_CUSTOMER_HIERARCHIES

TABLE - FII.FII_CUST_ACCOUNTS

TABLE - FII.FII_DIM_MAPPING_RULES

TABLE - FII.FII_DIM_NORM_HIERARCHY

TABLE - FII.FII_ENCUM_TYPE_MAPPINGS

TABLE - FII.FII_E_REVENUE_F

TABLE - FII.FII_E_REVENUE_FSTG

TABLE - FII.FII_E_REVENUE_SUMMARY_F

TABLE - FII.FII_FA_ACCT_CLASS_CODE_GT

TABLE - FII.FII_FA_CAT_DIMENSIONS

TABLE - FII.FII_FA_CAT_SEGMENTS

TABLE - FII.FII_FA_EXP_CJE_IDS

TABLE - FII.FII_FA_EXP_F

TABLE - FII.FII_FA_EXP_HDR_IDS

TABLE - FII.FII_FA_EXP_T

TABLE - FII.FII_FA_NEW_EXP_CJE_IDS

TABLE - FII.FII_FA_NEW_EXP_HDR_IDS

TABLE - FII.FII_FA_WORKER_JOBS

TABLE - FII.FII_FC_PMV_AGRT_NODES

TABLE - FII.FII_FC_TYPE_NORM_ASSIGN

TABLE - FII.FII_FINANCIAL_DIMENSIONS

TABLE - FII.FII_FIN_CAT_LEAF_MAPS

TABLE - FII.FII_FIN_CAT_MAPPINGS

TABLE - FII.FII_FIN_CAT_TYPE_ASSGNS

TABLE - FII.FII_FIN_ITEM_ASSIGNMENTS

TABLE - FII.FII_FIN_ITEM_HIERARCHIES

TABLE - FII.FII_FIN_ITEM_HIER_GT

TABLE - FII.FII_FIN_ITEM_LEAF_HIERS

TABLE - FII.FII_FIN_ITEM_SETS

TABLE - FII.FII_FULL_COMPANY_HIERS

TABLE - FII.FII_FULL_COST_CTR_HIERS

TABLE - FII.FII_FULL_FIN_ITEM_HIERS

TABLE - FII.FII_FULL_LOB_HIERS

TABLE - FII.FII_FULL_UDD1_HIERS

TABLE - FII.FII_FULL_UDD2_HIERS

TABLE - FII.FII_GLOBAL_START_DATES

TABLE - FII.FII_GL_BUDGET_EXTRACT_T

TABLE - FII.FII_GL_CCID_DIMENSIONS

TABLE - FII.FII_GL_CCID_PROD_INT

TABLE - FII.FII_GL_ENC_CARRYFWD_F

TABLE - FII.FII_GL_ENC_CARRYFWD_T

TABLE - FII.FII_GL_JE_SUMMARY_B

TABLE - FII.FII_GL_JE_SUMMARY_STG

TABLE - FII.FII_GL_LOCAL_SNAP_F

TABLE - FII.FII_GL_NEW_JRL_HEADER_IDS

TABLE - FII.FII_GL_PROCESSED_HEADER_IDS

TABLE - FII.FII_GL_SNAP_F

TABLE - FII.FII_GL_SNAP_SUM_F

TABLE - FII.FII_GL_WORKER_JOBS

TABLE - FII.FII_INDEXES

TABLE - FII.FII_LOB_ASSIGNMENTS

TABLE - FII.FII_LOB_COST_CENTER_ORGS

TABLE - FII.FII_LOB_HIERARCHIES

TABLE - FII.FII_ORG_MGR_MAPPINGS

TABLE - FII.FII_PARTY_MKT_CLASS

TABLE - FII.FII_PARTY_MKT_CLASS_STG

TABLE - FII.FII_PA_BUDGET_F

TABLE - FII.FII_PA_BUDGET_FSTG

TABLE - FII.FII_PA_BUDGET_M

TABLE - FII.FII_PA_BUDGET_PK

TABLE - FII.FII_PA_COST_F

TABLE - FII.FII_PA_COST_FSTG

TABLE - FII.FII_PA_COST_PK

TABLE - FII.FII_PA_PABU_BUDGET_LSTG

TABLE - FII.FII_PA_PABU_BUDGET_LTC

TABLE - FII.FII_PA_REVENUE_EVT_PK

TABLE - FII.FII_PA_REVENUE_EXP_PK

TABLE - FII.FII_PA_REVENUE_F

TABLE - FII.FII_PA_REVENUE_FSTG

TABLE - FII.FII_PRODUCT_ASSIGNMENTS

TABLE - FII.FII_PROD_COA_ASSIGN_TYPE

TABLE - FII.FII_RECONV_GL_ROLLUP_GT

TABLE - FII.FII_RECONV_RATES

TABLE - FII.FII_REPORTING_STRUCTURES

TABLE - FII.FII_SLG_ASSIGNMENTS

TABLE - FII.FII_SLG_BUDGET_ASGNS

TABLE - FII.FII_SOURCE_LEDGER_GROUPS

TABLE - FII.FII_SYSTEM_EVENT_LOG

TABLE - FII.FII_TIME_CAL_NAME

TABLE - FII.FII_TIME_CAL_PERIOD

TABLE - FII.FII_TIME_CAL_QTR

TABLE - FII.FII_TIME_CAL_RPT_STRUCT

TABLE - FII.FII_TIME_CAL_YEAR

TABLE - FII.FII_TIME_DAY

TABLE - FII.FII_TIME_ENT_PERIOD

TABLE - FII.FII_TIME_ENT_QTR

TABLE - FII.FII_TIME_ENT_YEAR

TABLE - FII.FII_TIME_GL_PERIODS

TABLE - FII.FII_TIME_MONTH

TABLE - FII.FII_TIME_P445

TABLE - FII.FII_TIME_QTR

TABLE - FII.FII_TIME_ROLLING_OFFSETS

TABLE - FII.FII_TIME_RPT_STRUCT

TABLE - FII.FII_TIME_STRUCTURES

TABLE - FII.FII_TIME_WEEK

TABLE - FII.FII_TIME_YEAR

TABLE - FII.FII_TIME_YEAR445

TABLE - FII.FII_TMP_PK

TABLE - FII.FII_TOP_SPENDERS_STG

TABLE - FII.FII_TOP_SPNDR_SUM_B

TABLE - FII.FII_UDD1_HIERARCHIES

TABLE - FII.FII_UDD1_MAPPINGS

TABLE - FII.FII_UDD1_PMV_AGRT_NODES

TABLE - FII.FII_UDD2_HIERARCHIES

TABLE - FII.FII_UDD2_MAPPINGS

VIEW - APPS.EDW_AP_PAYMENT_MPV

VIEW - APPS.EDW_AP_PAY_TERM_MPV

VIEW - APPS.EDW_CURRENCY_MPV

VIEW - APPS.EDW_GL_BOOK_MPV

VIEW - APPS.EDW_HOLD_MPV

VIEW - APPS.EDW_INV_LN_TYP_MPV

VIEW - APPS.EDW_INV_SOURCE_MPV

VIEW - APPS.EDW_INV_TYPE_MPV

VIEW - APPS.EDW_PA_EXP_TYPE_MPV

VIEW - APPS.EDW_PROJECT_MPV

VIEW - APPS.EDW_RELEASE_MPV

VIEW - APPS.FIIBV_AP_AP_APPY_CHECK_LCV

VIEW - APPS.FIIBV_AP_AP_APPY_PAYMENT_LCV

VIEW - APPS.FIIBV_AP_AP_APPY_PYMT_MTHD_LCV

VIEW - APPS.FIIBV_AP_HOLD_DATA_FCV

VIEW - APPS.FIIBV_AP_HOLD_HOLD_LCV

VIEW - APPS.FIIBV_AP_HOLD_HOLD_TYPE_LCV

VIEW - APPS.FIIBV_AP_ILTY_INV_LN_TYP_LCV

VIEW - APPS.FIIBV_AP_INV_LINES_FCV

VIEW - APPS.FIIBV_AP_INV_ON_HOLD_FCV

VIEW - APPS.FIIBV_AP_INV_PAYMTS_FCV

VIEW - APPS.FIIBV_AP_IVSR_INV_SOURCE_LCV

VIEW - APPS.FIIBV_AP_IVTY_INV_LCV

VIEW - APPS.FIIBV_AP_IVTY_INV_TYPE_LCV

VIEW - APPS.FIIBV_AP_RLSE_RELEASE_LCV

VIEW - APPS.FIIBV_AP_RLSE_RELEASE_TYPE_LCV

VIEW - APPS.FIIBV_AP_SCH_PAYMTS_FCV

VIEW - APPS.FIIBV_AR_ARDN_DOC_NUM_LCV

VIEW - APPS.FIIBV_AR_ARTT_CODE_LCV

VIEW - APPS.FIIBV_AR_ARTT_TYPE_LCV

VIEW - APPS.FIIBV_CURR_CURRENCY_LCV

VIEW - APPS.FIIBV_GL_BOOK_BOOK_LCV

VIEW - APPS.FIIBV_GL_BOOK_FA_BOOK_LCV

VIEW - APPS.FIIBV_PA_BUDGET_F_FCV

VIEW - APPS.FIIBV_PA_COST_F_FCV

VIEW - APPS.FIIBV_PA_EXP_TYPES_V

VIEW - APPS.FIIBV_PA_PABU_BUDGET_LCV

VIEW - APPS.FIIBV_PA_REVENUE_F_FCV

VIEW - APPS.FIIBV_PROJ_CATEG1_LCV

VIEW - APPS.FIIBV_PROJ_CATEG2_LCV

VIEW - APPS.FIIBV_PROJ_CATEG3_LCV

VIEW - APPS.FIIBV_PROJ_CATEG4_LCV

VIEW - APPS.FIIBV_PROJ_CATEG5_LCV

VIEW - APPS.FIIBV_PROJ_CATEG6_LCV

VIEW - APPS.FIIBV_PROJ_CATEG7_LCV

VIEW - APPS.FIIBV_PROJ_CLS1_LCV

VIEW - APPS.FIIBV_PROJ_CLS2_LCV

VIEW - APPS.FIIBV_PROJ_CLS3_LCV

VIEW - APPS.FIIBV_PROJ_CLS4_LCV

VIEW - APPS.FIIBV_PROJ_CLS5_LCV

VIEW - APPS.FIIBV_PROJ_CLS6_LCV

VIEW - APPS.FIIBV_PROJ_CLS7_LCV

VIEW - APPS.FIIBV_PROJ_PRJ_TYP_LCV

VIEW - APPS.FIIBV_PROJ_PROJECT_LCV

VIEW - APPS.FIIBV_PROJ_TASK_LCV

VIEW - APPS.FIIBV_PROJ_TOP_TASK_LCV

VIEW - APPS.FII_ALL_BUD_CCC_V

VIEW - APPS.FII_ALL_EFFECTIVE_DATES_V

VIEW - APPS.FII_ALL_FIN_ITEMS_V

VIEW - APPS.FII_ALL_LEDGER_V

VIEW - APPS.FII_ALL_LINES_OF_BUSINESS_V

VIEW - APPS.FII_ALL_NATURAL_ACCOUNTS_V

VIEW - APPS.FII_ALL_PRODUCTS_V

VIEW - APPS.FII_AP_AP_APPY_CHECK_LCV

VIEW - APPS.FII_AP_AP_APPY_PAYMENT_LCV

VIEW - APPS.FII_AP_AP_APPY_PYMT_MTHD_LCV

VIEW - APPS.FII_AP_DISC_AVAL_DTL_SUMMARY_V

VIEW - APPS.FII_AP_DISC_AVAL_TOP_SUMMARY_V

VIEW - APPS.FII_AP_DISC_LOST_DTL_SUMMARY_V

VIEW - APPS.FII_AP_DISC_LOST_TOP_SUMMARY_V

VIEW - APPS.FII_AP_DISC_TOP_SUMMARY_V

VIEW - APPS.FII_AP_HOLD_DATA_FCV

VIEW - APPS.FII_AP_HOLD_HOLD_LCV

VIEW - APPS.FII_AP_HOLD_HOLD_TYPE_LCV

VIEW - APPS.FII_AP_ILTY_INV_LN_TYP_LCV

VIEW - APPS.FII_AP_INV_B_V1

VIEW - APPS.FII_AP_INV_B_V2

VIEW - APPS.FII_AP_INV_LINES_FCV

VIEW - APPS.FII_AP_INV_ON_HOLD_FCV

VIEW - APPS.FII_AP_INV_PAYMTS_FCV

VIEW - APPS.FII_AP_IVSR_INV_SOURCE_LCV

VIEW - APPS.FII_AP_IVTY_INV_LCV

VIEW - APPS.FII_AP_IVTY_INV_TYPE_LCV

VIEW - APPS.FII_AP_OPEN_PAYMT_DTL_SUM_V

VIEW - APPS.FII_AP_OPEN_PAYMT_SUMMARY_V

VIEW - APPS.FII_AP_OP_IND_INV_SUMMARY_V

VIEW - APPS.FII_AP_OP_IND_PAYMT_SUMMARY_V

VIEW - APPS.FII_AP_PTRM_PAY_TERM_LCV

VIEW - APPS.FII_AP_RLSE_RELEASE_LCV

VIEW - APPS.FII_AP_RLSE_RELEASE_TYPE_LCV

VIEW - APPS.FII_AP_SCH_PAYMTS_FCV

VIEW - APPS.FII_AR_AGING_PMV

VIEW - APPS.FII_AR_AGING_WH_V

VIEW - APPS.FII_AR_ARDN_DOC_NUM_LCV

VIEW - APPS.FII_AR_ARTT_CODE_LCV

VIEW - APPS.FII_AR_ARTT_TYPE_LCV

VIEW - APPS.FII_AR_BILLING_ACT_AGRT_MV_F_V

VIEW - APPS.FII_AR_BILLING_ACT_AGRT_MV_P_V

VIEW - APPS.FII_AR_BILLING_ACT_AGRT_MV_S_V

VIEW - APPS.FII_AR_BILLING_ACT_BASE_MV_F_V

VIEW - APPS.FII_AR_BILLING_ACT_BASE_MV_P_V

VIEW - APPS.FII_AR_BILLING_ACT_BASE_MV_S_V

VIEW - APPS.FII_AR_CASH_CUST_L7D_V

VIEW - APPS.FII_AR_CASH_CUST_L7D_WH_V

VIEW - APPS.FII_AR_CASH_CUST_V

VIEW - APPS.FII_AR_CASH_CUST_WH_V

VIEW - APPS.FII_AR_CASH_FCV

VIEW - APPS.FII_AR_COLLECTORS_V

VIEW - APPS.FII_AR_CURR_REC_PMV

VIEW - APPS.FII_AR_CURR_REC_WH_V

VIEW - APPS.FII_AR_CUST_LOV_V

VIEW - APPS.FII_AR_DISPUTES_AGRT_MV_F_V

VIEW - APPS.FII_AR_DISPUTES_AGRT_MV_P_V

VIEW - APPS.FII_AR_DISPUTES_AGRT_MV_S_V

VIEW - APPS.FII_AR_DISPUTES_BASE_MV_F_V

VIEW - APPS.FII_AR_DISPUTES_BASE_MV_P_V

VIEW - APPS.FII_AR_DISPUTES_BASE_MV_S_V

VIEW - APPS.FII_AR_DISPUTE_REC_PMV

VIEW - APPS.FII_AR_DISPUTE_REC_WH_V

VIEW - APPS.FII_AR_INV_CUST_L7D_V

VIEW - APPS.FII_AR_INV_CUST_L7D_WH_V

VIEW - APPS.FII_AR_INV_CUST_V

VIEW - APPS.FII_AR_INV_CUST_WH_V

VIEW - APPS.FII_AR_NET_REC_AGRT_MV_F_V

VIEW - APPS.FII_AR_NET_REC_AGRT_MV_P_V

VIEW - APPS.FII_AR_NET_REC_AGRT_MV_S_V

VIEW - APPS.FII_AR_NET_REC_BASE_MV_F_V

VIEW - APPS.FII_AR_NET_REC_BASE_MV_P_V

VIEW - APPS.FII_AR_NET_REC_BASE_MV_S_V

VIEW - APPS.FII_AR_OLTP_CASH_V

VIEW - APPS.FII_AR_OLTP_INV_V

VIEW - APPS.FII_AR_OLTP_OPEN_INV_V

VIEW - APPS.FII_AR_PASTDUE_REC_PMV

VIEW - APPS.FII_AR_PASTDUE_REC_SUM_PMV

VIEW - APPS.FII_AR_PASTDUE_REC_WH_V

VIEW - APPS.FII_AR_RCT_AGING_AGRT_MV_F_V

VIEW - APPS.FII_AR_RCT_AGING_AGRT_MV_P_V

VIEW - APPS.FII_AR_RCT_AGING_AGRT_MV_S_V

VIEW - APPS.FII_AR_RCT_AGING_BASE_MV_F_V

VIEW - APPS.FII_AR_RCT_AGING_BASE_MV_P_V

VIEW - APPS.FII_AR_RCT_AGING_BASE_MV_S_V

VIEW - APPS.FII_AR_RECEIPTS_F_V

VIEW - APPS.FII_AR_REC_FCV

VIEW - APPS.FII_AR_RESR_REV_SRC_LCV

VIEW - APPS.FII_AR_REVENUE_B_V1

VIEW - APPS.FII_AR_REVENUE_B_V2

VIEW - APPS.FII_AR_REV_CUST_L7D_V

VIEW - APPS.FII_AR_REV_CUST_L7D_WH_V

VIEW - APPS.FII_AR_REV_CUST_V

VIEW - APPS.FII_AR_REV_CUST_WH_V

VIEW - APPS.FII_AR_REV_SUM_V1

VIEW - APPS.FII_AR_REV_SUM_V2

VIEW - APPS.FII_AR_SICM_SIC_LCV

VIEW - APPS.FII_AR_SIC_CODE_BASE_V

VIEW - APPS.FII_AR_SUMMARY_GT_V

VIEW - APPS.FII_AR_TRX_DIST_FCV

VIEW - APPS.FII_AR_UNAPP_REC_PMV

VIEW - APPS.FII_AR_UNAPP_REC_WH_V

VIEW - APPS.FII_ASSET_CAT_MAJOR_V

VIEW - APPS.FII_ASSET_CAT_MINOR_V

VIEW - APPS.FII_CCC_SEC_ROLES_V

VIEW - APPS.FII_CCC_VALUES_V

VIEW - APPS.FII_CC_MGR_SUP_V

VIEW - APPS.FII_COLLECTORS_BRIDGE_V

VIEW - APPS.FII_COLLECTORS_V

VIEW - APPS.FII_COMPANIES_V

VIEW - APPS.FII_COMPANY_VALUES_V

VIEW - APPS.FII_COST_CENTER_V

VIEW - APPS.FII_COST_CENTER_VALUES_V

VIEW - APPS.FII_CURRENCIES_V

VIEW - APPS.FII_CURR_CURRENCY_LCV

VIEW - APPS.FII_CURR_V

VIEW - APPS.FII_CUSTOMERS_V

VIEW - APPS.FII_CUST_ACCOUNTS_V

VIEW - APPS.FII_CUST_ACCTS_V

VIEW - APPS.FII_CUST_V

VIEW - APPS.FII_EFFECTIVE_DATES_V

VIEW - APPS.FII_FC_TYPE_ASSGNS_V

VIEW - APPS.FII_FC_V

VIEW - APPS.FII_FINANCIAL_DIMENSIONS_V

VIEW - APPS.FII_FIN_ITEMS_V

VIEW - APPS.FII_FIN_ITEM_V

VIEW - APPS.FII_FULL_COMPANIES_V

VIEW - APPS.FII_FULL_COST_CENTER_V

VIEW - APPS.FII_FULL_FC_V

VIEW - APPS.FII_FULL_USER_DEFINED1_V

VIEW - APPS.FII_FULL_USER_DEFINED2_V

VIEW - APPS.FII_GL_AGRT_SUM_MV_P_V

VIEW - APPS.FII_GL_AGRT_SUM_MV_S_V

VIEW - APPS.FII_GL_BASE_MAP_MV_P_V

VIEW - APPS.FII_GL_BASE_MAP_MV_S_V

VIEW - APPS.FII_GL_BASE_V1

VIEW - APPS.FII_GL_BASE_V2

VIEW - APPS.FII_GL_BOOK_BOOK_LCV

VIEW - APPS.FII_GL_BOOK_FA_BOOK_LCV

VIEW - APPS.FII_GL_BOOK_V

VIEW - APPS.FII_GL_JE_SUMMARY_B_P_V

VIEW - APPS.FII_GL_JE_SUMMARY_B_S_V

VIEW - APPS.FII_GL_LOCAL_SNAP_F_P_V

VIEW - APPS.FII_GL_LOCAL_SNAP_F_S_V

VIEW - APPS.FII_GL_MGMT_CCC_V1

VIEW - APPS.FII_GL_MGMT_CCC_V2

VIEW - APPS.FII_GL_MGMT_SUM_V1

VIEW - APPS.FII_GL_MGMT_SUM_V2

VIEW - APPS.FII_GL_PRD_V1

VIEW - APPS.FII_GL_PRD_V2

VIEW - APPS.FII_GL_SNAP_F_P_V

VIEW - APPS.FII_GL_SNAP_F_S_V

VIEW - APPS.FII_GL_SNAP_SUM_F_P_V

VIEW - APPS.FII_GL_SNAP_SUM_F_S_V

VIEW - APPS.FII_GL_TREND_SUM_MV_P_V

VIEW - APPS.FII_GL_TREND_SUM_MV_S_V

VIEW - APPS.FII_LEDGERS_V

VIEW - APPS.FII_LEDGER_V

VIEW - APPS.FII_LOB_ASSIGNMENTS_V

VIEW - APPS.FII_LOB_V

VIEW - APPS.FII_OPERATING_UNITS_V

VIEW - APPS.FII_OU_LEDGER_V

VIEW - APPS.FII_OU_V

VIEW - APPS.FII_PARTNER_MKT_CLASS_V

VIEW - APPS.FII_PARTY_MKT_CLASS_BRIDGE_V

VIEW - APPS.FII_PARTY_MKT_CLASS_TYPE_V

VIEW - APPS.FII_PARTY_MKT_CLASS_V

VIEW - APPS.FII_PA_BUDGET_F_FCV

VIEW - APPS.FII_PA_BUDGET_MPV

VIEW - APPS.FII_PA_COST_F_FCV

VIEW - APPS.FII_PA_CURRENT_TASKS

VIEW - APPS.FII_PA_EXP_TYPES_V

VIEW - APPS.FII_PA_INTERFACED_TASKS

VIEW - APPS.FII_PA_PABU_BUDGET_LCV

VIEW - APPS.FII_PA_REVENUE_F_FCV

VIEW - APPS.FII_PORTAL_POA_SUMMARY_V

VIEW - APPS.FII_PROD_ASSIGN_TYPE_V

VIEW - APPS.FII_PROJ_CATEG1_LCV

VIEW - APPS.FII_PROJ_CATEG2_LCV

VIEW - APPS.FII_PROJ_CATEG3_LCV

VIEW - APPS.FII_PROJ_CATEG4_LCV

VIEW - APPS.FII_PROJ_CATEG5_LCV

VIEW - APPS.FII_PROJ_CATEG6_LCV

VIEW - APPS.FII_PROJ_CATEG7_LCV

VIEW - APPS.FII_PROJ_CLS1_LCV

VIEW - APPS.FII_PROJ_CLS2_LCV

VIEW - APPS.FII_PROJ_CLS3_LCV

VIEW - APPS.FII_PROJ_CLS4_LCV

VIEW - APPS.FII_PROJ_CLS5_LCV

VIEW - APPS.FII_PROJ_CLS6_LCV

VIEW - APPS.FII_PROJ_CLS7_LCV

VIEW - APPS.FII_PROJ_PRJ_TYP_LCV

VIEW - APPS.FII_PROJ_PROJECT_FKV

VIEW - APPS.FII_PROJ_PROJECT_LCV

VIEW - APPS.FII_PROJ_TASK_FKV

VIEW - APPS.FII_PROJ_TASK_LCV

VIEW - APPS.FII_PROJ_TOP_TASK_FKV

VIEW - APPS.FII_PROJ_TOP_TASK_LCV

VIEW - APPS.FII_SRS_ALL_TIME_PERIODS_V

VIEW - APPS.FII_TIME_BIMONTH_V

VIEW - APPS.FII_TIME_CAL_NAME_V

VIEW - APPS.FII_TIME_CAL_PERIOD_V

VIEW - APPS.FII_TIME_CAL_QTR_V

VIEW - APPS.FII_TIME_CAL_YEAR_V

VIEW - APPS.FII_TIME_DAY_ALL_V

VIEW - APPS.FII_TIME_DAY_V

VIEW - APPS.FII_TIME_ENT_PERIOD_V

VIEW - APPS.FII_TIME_ENT_QTR_V

VIEW - APPS.FII_TIME_ENT_YEAR_V

VIEW - APPS.FII_TIME_MONTH_V

VIEW - APPS.FII_TIME_P445_V

VIEW - APPS.FII_TIME_QTR_V

VIEW - APPS.FII_TIME_RPT_STRUCT2_V

VIEW - APPS.FII_TIME_RPT_STRUCT_V

VIEW - APPS.FII_TIME_SEMIYEAR_V

VIEW - APPS.FII_TIME_WEEK_V

VIEW - APPS.FII_TIME_YEAR445_V

VIEW - APPS.FII_TIME_YEAR_V

VIEW - APPS.FII_TOP_SPENDERS_V1

VIEW - APPS.FII_TOP_SPENDERS_V2

VIEW - APPS.FII_TRADING_PARTNER_MKTCLASS_V

VIEW - APPS.FII_USER_DEFINED1_V

VIEW - APPS.FII_USER_DEFINED2_V

Table: EDW_AP_APPY_CHECK_LSTG

Comments

This is the interface table for the AP Payment Dimension checks level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.

Indexes

Columns

[top of page]

FII.EDW_AP_APPY_CHECK_LSTG does not reference any database object

FII.EDW_AP_APPY_CHECK_LSTG is referenced by following:

APPS

SYNONYM - EDW_AP_APPY_CHECK_LSTG

[top of page]

Table: EDW_AP_APPY_CHECK_LTC

Comments

This is the AP check level table for the AP payment dimension. This stores information for payments issued to suppliers.

Indexes

Columns

[top of page]

FII.EDW_AP_APPY_CHECK_LTC does not reference any database object

FII.EDW_AP_APPY_CHECK_LTC is referenced by following:

APPS

SYNONYM - EDW_AP_APPY_CHECK_LTC

[top of page]

Table: EDW_AP_APPY_PAYMENT_LSTG

Comments

This is the interface table for the AP Payment Dimension payment level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.

Indexes

Columns

[top of page]

FII.EDW_AP_APPY_PAYMENT_LSTG does not reference any database object

FII.EDW_AP_APPY_PAYMENT_LSTG is referenced by following:

APPS

SYNONYM - EDW_AP_APPY_PAYMENT_LSTG

[top of page]

Table: EDW_AP_APPY_PAYMENT_LTC

Comments

AP payment level table for AP payment dimension. This stores the information for invoice payments made to suppliers.

Indexes

Columns

[top of page]

FII.EDW_AP_APPY_PAYMENT_LTC does not reference any database object

FII.EDW_AP_APPY_PAYMENT_LTC is referenced by following:

APPS

SYNONYM - EDW_AP_APPY_PAYMENT_LTC

[top of page]

Table: EDW_AP_APPY_PYMT_MTHD_LSTG

Comments

This is the interface table for the AP Payment Dimension payment method level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.

Indexes

Columns

[top of page]

FII.EDW_AP_APPY_PYMT_MTHD_LSTG does not reference any database object

FII.EDW_AP_APPY_PYMT_MTHD_LSTG is referenced by following:

APPS

SYNONYM - EDW_AP_APPY_PYMT_MTHD_LSTG

[top of page]

Table: EDW_AP_APPY_PYMT_MTHD_LTC

Comments

AP payment method level table for AP payment dimension. This stores information on various payment methods.

Indexes

Columns

[top of page]

FII.EDW_AP_APPY_PYMT_MTHD_LTC does not reference any database object

FII.EDW_AP_APPY_PYMT_MTHD_LTC is referenced by following:

APPS

SYNONYM - EDW_AP_APPY_PYMT_MTHD_LTC

[top of page]

Table: EDW_AP_PAYMENT_A_LTC

Comments

Top level table for AP payment dimension.

Indexes

Columns

[top of page]

FII.EDW_AP_PAYMENT_A_LTC does not reference any database object

FII.EDW_AP_PAYMENT_A_LTC is referenced by following:

APPS

SYNONYM - EDW_AP_PAYMENT_A_LTC

[top of page]

Table: EDW_AP_PAYMENT_M

Comments

This is AP payment dimension table. It is a denormalized star table and it contains records for the lowest level of the dimension and their parentage up to the top level.

Indexes

Columns

[top of page]

FII.EDW_AP_PAYMENT_M does not reference any database object

FII.EDW_AP_PAYMENT_M is referenced by following:

APPS

SYNONYM - EDW_AP_PAYMENT_M

[top of page]

Table: EDW_AP_PAY_TERM_A_LTC

Comments

Top level table for AP payment terms dimension.

Indexes

Columns

[top of page]

FII.EDW_AP_PAY_TERM_A_LTC does not reference any database object

FII.EDW_AP_PAY_TERM_A_LTC is referenced by following:

APPS

SYNONYM - EDW_AP_PAY_TERM_A_LTC

[top of page]

Table: EDW_AP_PAY_TERM_M

Comments

This is payment term dimension table. This is a denormalized star table and contains records for lowest level of the dimension and their parentage up to the top level.

Indexes

Columns

[top of page]

FII.EDW_AP_PAY_TERM_M does not reference any database object

FII.EDW_AP_PAY_TERM_M is referenced by following:

APPS

SYNONYM - EDW_AP_PAY_TERM_M

[top of page]

Table: EDW_AP_PTRM_PAY_TERM_LSTG

Comments

This is the interface table for the AP payment terms level table. Data from multiple transactional systems is staged here for verefication and cleansing, before loading it into the dimension level table.

Indexes

Columns

[top of page]

FII.EDW_AP_PTRM_PAY_TERM_LSTG does not reference any database object

FII.EDW_AP_PTRM_PAY_TERM_LSTG is referenced by following:

APPS

SYNONYM - EDW_AP_PTRM_PAY_TERM_LSTG

[top of page]

Table: EDW_AP_PTRM_PAY_TERM_LTC

Comments

Top level table for AP payment terms dimension.

Indexes

Columns

[top of page]

FII.EDW_AP_PTRM_PAY_TERM_LTC does not reference any database object

FII.EDW_AP_PTRM_PAY_TERM_LTC is referenced by following:

APPS

SYNONYM - EDW_AP_PTRM_PAY_TERM_LTC

[top of page]

Table: EDW_ARDN_DOC_NUM_LSTG

Comments

This is the interface table for the Receivables Document Number level table. Before document number information is loaded into the warehouse, data is temporarily held in the staging table for verification and cleansing.

Columns

[top of page]

FII.EDW_ARDN_DOC_NUM_LSTG does not reference any database object

FII.EDW_ARDN_DOC_NUM_LSTG is referenced by following:

APPS

SYNONYM - EDW_ARDN_DOC_NUM_LSTG

[top of page]

Table: EDW_ARDN_DOC_NUM_LTC

Comments

This is the Receivables Document Number level table within Receivables Document Number dimension. This stores the various document numbers that are used for different business purposes.

Indexes

Columns

[top of page]

FII.EDW_ARDN_DOC_NUM_LTC does not reference any database object

FII.EDW_ARDN_DOC_NUM_LTC is referenced by following:

APPS

SYNONYM - EDW_ARDN_DOC_NUM_LTC

[top of page]

Table: EDW_ARTT_CODE_LSTG

Comments

This is the staging table for the transaction code level table. Before transaction code information is loaded into the warehouse, data is temporarily held in the staging table for verification and cleansing.

Columns

[top of page]

FII.EDW_ARTT_CODE_LSTG does not reference any database object

FII.EDW_ARTT_CODE_LSTG is referenced by following:

APPS

SYNONYM - EDW_ARTT_CODE_LSTG

[top of page]

Table: EDW_ARTT_CODE_LTC

Comments

This is the transaction code level table within transaction code dimension. This stores the various transaction codes that are used for different business purposes.

Indexes

Columns

[top of page]

FII.EDW_ARTT_CODE_LTC does not reference any database object

FII.EDW_ARTT_CODE_LTC is referenced by following:

APPS

SYNONYM - EDW_ARTT_CODE_LTC

[top of page]

Table: EDW_ARTT_TYPE_LSTG

Comments

This is the staging table for the transaction type level table. Before transaction type information is loaded into the warehouse, data is temporarily held in the staging table for verification and cleansing.

Columns

[top of page]

FII.EDW_ARTT_TYPE_LSTG does not reference any database object

FII.EDW_ARTT_TYPE_LSTG is referenced by following:

APPS

SYNONYM - EDW_ARTT_TYPE_LSTG

[top of page]

Table: EDW_ARTT_TYPE_LTC

Comments

This is the AR Transaction Type level table within AR Transaction Type dimension. This stores the various AR Transaction types that are used for different business purposes.

Indexes

Columns

[top of page]

FII.EDW_ARTT_TYPE_LTC does not reference any database object

FII.EDW_ARTT_TYPE_LTC is referenced by following:

APPS

SYNONYM - EDW_ARTT_TYPE_LTC

[top of page]

Table: EDW_AR_DOC_NUM_A_LTC

Comments

This is the all level table for the Receivables Document Number dimension.

Indexes

Columns

[top of page]

FII.EDW_AR_DOC_NUM_A_LTC does not reference any database object

FII.EDW_AR_DOC_NUM_A_LTC is referenced by following:

APPS

SYNONYM - EDW_AR_DOC_NUM_A_LTC

[top of page]

Table: EDW_AR_DOC_NUM_M

Primary Key: EDW_AR_DOC_NUM_M_P

1. DOC_DOC_NUM_PK_KEY

Primary Key: EDW_AR_DOC_NUM_M_U

1. DOC_DOC_NUM_PK

Comments

This is Receivables Document Number dimension table. It is a denormalized star table and it contains records for the lowest level of the dimension and their parentage up to the top level.

Indexes

Columns

[top of page]

FII.EDW_AR_DOC_NUM_M does not reference any database object

FII.EDW_AR_DOC_NUM_M is referenced by following:

APPS

SYNONYM - EDW_AR_DOC_NUM_M

[top of page]

Table: EDW_AR_TRX_TYPE_A_LTC

Comments

This is All level table for the Receivables Transaction Type dimension.

Indexes

Columns

[top of page]

FII.EDW_AR_TRX_TYPE_A_LTC does not reference any database object

FII.EDW_AR_TRX_TYPE_A_LTC is referenced by following:

APPS

SYNONYM - EDW_AR_TRX_TYPE_A_LTC

[top of page]

Table: EDW_AR_TRX_TYPE_M

Comments

This is Receivables transaction type dimension table. It is a denormalized star table and it contains records for the lowest level of the dimension and their parentage up to the top level.

Indexes

Columns

[top of page]

FII.EDW_AR_TRX_TYPE_M does not reference any database object

FII.EDW_AR_TRX_TYPE_M is referenced by following:

APPS

SYNONYM - EDW_AR_TRX_TYPE_M

[top of page]

Table: EDW_CONS_SET_OF_BOOKS

Comments

This is the setup table used by accounting flexfield dimensions. This stores information about your consolidation mappings.This table corresponds to the Consolidation Set of Books Setup form.

Columns

[top of page]

BIS.EDW_CONS_SET_OF_BOOKS does not reference any database object

BIS.EDW_CONS_SET_OF_BOOKS is referenced by following:

APPS

SYNONYM - EDW_CONS_SET_OF_BOOKS

[top of page]

Table: EDW_CURRENCY_A_LTC

Comments

This is All level table for the Currency dimension

Indexes

Columns

[top of page]

FII.EDW_CURRENCY_A_LTC does not reference any database object

FII.EDW_CURRENCY_A_LTC is referenced by following:

APPS

SYNONYM - EDW_CURRENCY_A_LTC

[top of page]

Table: EDW_CURRENCY_M

Comments

This is Currency dimension table. It is denormalized star table and it contains records for the lowest level of the dimension and their parentage up to the top level.

Indexes

Columns

[top of page]

FII.EDW_CURRENCY_M does not reference any database object

FII.EDW_CURRENCY_M is referenced by following:

APPS

SYNONYM - EDW_CURRENCY_M

[top of page]

Table: EDW_CURR_CURRENCY_LSTG

Comments

This is the staging table for the currency level. Before currency information is loaded into the warehouse, data is temporarily held in the staging table for verification and cleansing.

Indexes

Columns

[top of page]

FII.EDW_CURR_CURRENCY_LSTG does not reference any database object

FII.EDW_CURR_CURRENCY_LSTG is referenced by following:

APPS

SYNONYM - EDW_CURR_CURRENCY_LSTG

[top of page]

Table: EDW_CURR_CURRENCY_LTC

Comments

This is the Currency level table within Currency dimension. This stores the various currencies that are used for different business purposes.

Indexes

Columns

[top of page]

FII.EDW_CURR_CURRENCY_LTC does not reference any database object

FII.EDW_CURR_CURRENCY_LTC is referenced by following:

APPS

SYNONYM - EDW_CURR_CURRENCY_LTC

[top of page]

Table: EDW_EQUI_SET_OF_BOOKS

Comments

This is the setup table used by accounting flexfield dimensions. This stores the same sets of books sitting in different instances. This table corresponds to the the Equivalent Set of Books Setup form.

Columns

[top of page]

BIS.EDW_EQUI_SET_OF_BOOKS does not reference any database object

BIS.EDW_EQUI_SET_OF_BOOKS is referenced by following:

APPS

SYNONYM - EDW_EQUI_SET_OF_BOOKS

[top of page]

Table: EDW_GL_ACCT10_M

Comments

This is a denormalized star table for the GL Accounting Key Flexfield dimension. It contains records for lowest level of the GL Accounting Key Flexfield dimension and their parentage up to the top level, across all hierarchies.

Indexes

Columns