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 - JA Tables and Views

TABLE - JA.JAI_AP_ETDS_ERRORS_T

TABLE - JA.JAI_AP_ETDS_REQUESTS

TABLE - JA.JAI_AP_ETDS_T

TABLE - JA.JAI_AP_INVOICE_LINES

TABLE - JA.JAI_AP_MATCH_ERS_T

TABLE - JA.JAI_AP_MATCH_INV_TAXES

TABLE - JA.JAI_AP_RGM_PAYMENTS

TABLE - JA.JAI_AP_TDS_CERT_NUMS

TABLE - JA.JAI_AP_TDS_F16_DTLS_ALL

TABLE - JA.JAI_AP_TDS_F16_HDRS_ALL

TABLE - JA.JAI_AP_TDS_INVOICES

TABLE - JA.JAI_AP_TDS_INV_CANCELS

TABLE - JA.JAI_AP_TDS_INV_PAYMENTS

TABLE - JA.JAI_AP_TDS_INV_TAXES

TABLE - JA.JAI_AP_TDS_PAN_CHANGES

TABLE - JA.JAI_AP_TDS_PAYMENTS

TABLE - JA.JAI_AP_TDS_PREPAYMENTS

TABLE - JA.JAI_AP_TDS_THGRP_AUDITS

TABLE - JA.JAI_AP_TDS_THHOLD_GRPS

TABLE - JA.JAI_AP_TDS_THHOLD_HDRS

TABLE - JA.JAI_AP_TDS_THHOLD_SLABS

TABLE - JA.JAI_AP_TDS_THHOLD_TAXES

TABLE - JA.JAI_AP_TDS_THHOLD_TRXS

TABLE - JA.JAI_AP_TDS_THHOLD_TYPES

TABLE - JA.JAI_AP_TDS_THHOLD_XCEPS

TABLE - JA.JAI_AP_TDS_VENDOR_HDRS

TABLE - JA.JAI_AP_TDS_YEARS

TABLE - JA.JAI_AP_TOL_SETUPS_ALL

TABLE - JA.JAI_AR_CASH_RECEIPTS_ALL

TABLE - JA.JAI_AR_DRB_CLAIMS

TABLE - JA.JAI_AR_ETCS_T

TABLE - JA.JAI_AR_EXCISE_UOM

TABLE - JA.JAI_AR_PAYMENT_AUDITS

TABLE - JA.JAI_AR_REC_APPL_AUDITS

TABLE - JA.JAI_AR_SUP_CHANGES_ALL

TABLE - JA.JAI_AR_SUP_HDRS_ALL

TABLE - JA.JAI_AR_SUP_INV_T

TABLE - JA.JAI_AR_SUP_LINES

TABLE - JA.JAI_AR_SUP_TAXES

TABLE - JA.JAI_AR_TDS_CERTIFICATES

TABLE - JA.JAI_AR_TRXS

TABLE - JA.JAI_AR_TRX_CM_T

TABLE - JA.JAI_AR_TRX_COPY_HDR_T

TABLE - JA.JAI_AR_TRX_INS_HDRS_T

TABLE - JA.JAI_AR_TRX_INS_LINES_T

TABLE - JA.JAI_AR_TRX_LINES

TABLE - JA.JAI_AR_TRX_POE_DTLS

TABLE - JA.JAI_AR_TRX_SUP_INV_T

TABLE - JA.JAI_AR_TRX_TAX_CALC_T

TABLE - JA.JAI_AR_TRX_TAX_LINES

TABLE - JA.JAI_AR_TRX_UPDATE_T

TABLE - JA.JAI_BOM_FINISHED_GOODS

TABLE - JA.JAI_BOM_RAW_MATERIALS

TABLE - JA.JAI_CMN_BOE_AGENTS

TABLE - JA.JAI_CMN_BOE_DTLS

TABLE - JA.JAI_CMN_BOE_HDRS

TABLE - JA.JAI_CMN_BOE_MATCHINGS

TABLE - JA.JAI_CMN_BOE_WRITEOFFS

TABLE - JA.JAI_CMN_CUS_ADDRESSES

TABLE - JA.JAI_CMN_DEBUG_CONTEXTS

TABLE - JA.JAI_CMN_DOCUMENT_TAXES

TABLE - JA.JAI_CMN_ERRORS_T

TABLE - JA.JAI_CMN_FIN_YEARS

TABLE - JA.JAI_CMN_INVENTORY_ORGS

TABLE - JA.JAI_CMN_JOURNAL_ENTRIES

TABLE - JA.JAI_CMN_LINES

TABLE - JA.JAI_CMN_MATCH_RECEIPTS

TABLE - JA.JAI_CMN_MATCH_TAXES

TABLE - JA.JAI_CMN_MTAX_HDRS_ALL

TABLE - JA.JAI_CMN_MTAX_UPD_DTLS

TABLE - JA.JAI_CMN_OM_AR_AR3_FORMS

TABLE - JA.JAI_CMN_RG_23AC_II_TRXS

TABLE - JA.JAI_CMN_RG_23AC_I_TRXS

TABLE - JA.JAI_CMN_RG_23D_TRXS

TABLE - JA.JAI_CMN_RG_BALANCES

TABLE - JA.JAI_CMN_RG_COMP_BALS

TABLE - JA.JAI_CMN_RG_COMP_DTLS

TABLE - JA.JAI_CMN_RG_CONSLDATIONS

TABLE - JA.JAI_CMN_RG_EXC_INV_NOS

TABLE - JA.JAI_CMN_RG_I_TRXS

TABLE - JA.JAI_CMN_RG_OTHERS

TABLE - JA.JAI_CMN_RG_OTH_BALANCES

TABLE - JA.JAI_CMN_RG_PERIOD_BALS

TABLE - JA.JAI_CMN_RG_PLA_CMP_DTLS

TABLE - JA.JAI_CMN_RG_PLA_DTLS

TABLE - JA.JAI_CMN_RG_PLA_HDRS

TABLE - JA.JAI_CMN_RG_PLA_TRXS

TABLE - JA.JAI_CMN_RG_ROUND_HDRS

TABLE - JA.JAI_CMN_RG_ROUND_LINES

TABLE - JA.JAI_CMN_RG_SLNOS

TABLE - JA.JAI_CMN_RG_TRANSFERS

TABLE - JA.JAI_CMN_STFORM_HDRS_ALL

TABLE - JA.JAI_CMN_ST_FORMS

TABLE - JA.JAI_CMN_ST_FORM_DTLS

TABLE - JA.JAI_CMN_ST_MATCH_DTLS

TABLE - JA.JAI_CMN_TAXCTG_UPDATES

TABLE - JA.JAI_CMN_TAXES_ALL

TABLE - JA.JAI_CMN_TAX_CTGS_ALL

TABLE - JA.JAI_CMN_TAX_CTG_LINES

TABLE - JA.JAI_CMN_TRANSACTIONS_T

TABLE - JA.JAI_CMN_VENDOR_SITES

TABLE - JA.JAI_CMN_WRITEOFFS_T

TABLE - JA.JAI_CRM_QUOTE_TAXES

TABLE - JA.JAI_DIST_TAX_TYPE

TABLE - JA.JAI_ENCUM_TAX_DETAILS

TABLE - JA.JAI_ENCUM_TAX_RVRSL_DTLS

TABLE - JA.JAI_FA_AST_BLOCKS

TABLE - JA.JAI_FA_AST_BLOCK_DTLS

TABLE - JA.JAI_FA_AST_BLOCK_H

TABLE - JA.JAI_FA_AST_PERIOD_RATES

TABLE - JA.JAI_FA_AST_YEARS

TABLE - JA.JAI_FA_DEP_BLOCKS

TABLE - JA.JAI_FA_DEP_BLOCKS_T

TABLE - JA.JAI_FA_EXEMPTIONS

TABLE - JA.JAI_FA_MASS_ADDITIONS

TABLE - JA.JAI_FBT_PAYMENT

TABLE - JA.JAI_FBT_PROCESS_DATE

TABLE - JA.JAI_FBT_REPOSITORY

TABLE - JA.JAI_FBT_SETTLEMENT

TABLE - JA.JAI_FBT_SETUP

TABLE - JA.JAI_FBT_SETUP_HEADERS

TABLE - JA.JAI_FBT_SETUP_LINES

TABLE - JA.JAI_INV_ITM_SETUPS

TABLE - JA.JAI_INV_ITM_TAXCTG_DTLS

TABLE - JA.JAI_INV_ITM_TAXCTG_HDRS

TABLE - JA.JAI_INV_SUBINV_DTLS

TABLE - JA.JAI_INV_SUBINV_HDRS

TABLE - JA.JAI_INV_TXN_EXT_DTLS

TABLE - JA.JAI_INV_TXN_EXT_HDRS

TABLE - JA.JAI_MTL_MATCH_RECEIPTS

TABLE - JA.JAI_MTL_TRXS

TABLE - JA.JAI_MTL_TRX_JRNLS

TABLE - JA.JAI_MTL_TXN_CST_DTL_T

TABLE - JA.JAI_MTL_TXN_CST_HDR_T

TABLE - JA.JAI_OM_LC_AMENDMENTS

TABLE - JA.JAI_OM_LC_HDRS

TABLE - JA.JAI_OM_LC_MATCHINGS

TABLE - JA.JAI_OM_OE_BOND_REG_DTLS

TABLE - JA.JAI_OM_OE_BOND_REG_HDRS

TABLE - JA.JAI_OM_OE_BOND_TRXS

TABLE - JA.JAI_OM_OE_GEN_TAXINV_T

TABLE - JA.JAI_OM_OE_RMA_LINES

TABLE - JA.JAI_OM_OE_RMA_TAXES

TABLE - JA.JAI_OM_OE_SO_LINES

TABLE - JA.JAI_OM_OE_SO_TAXES

TABLE - JA.JAI_OM_REP_JAINEXFR_T

TABLE - JA.JAI_OM_WSH_LINES_ALL

TABLE - JA.JAI_OM_WSH_LINE_TAXES

TABLE - JA.JAI_OPM_CM_ADJS_DTL

TABLE - JA.JAI_OPM_OSP_DTLS

TABLE - JA.JAI_OPM_OSP_EXC_RATES

TABLE - JA.JAI_OPM_OSP_HDRS

TABLE - JA.JAI_OPM_OSP_REG_SELS

TABLE - JA.JAI_OPM_TXN_EXTN_DTLS

TABLE - JA.JAI_OPM_TXN_EXTN_HDRS

TABLE - JA.JAI_PA_DRAFT_INVOICES

TABLE - JA.JAI_PA_DRAFT_INVOICE_LINES

TABLE - JA.JAI_PA_SETUP_CONTEXTS

TABLE - JA.JAI_PA_SETUP_PREFERENCES

TABLE - JA.JAI_PA_SETUP_VALUES

TABLE - JA.JAI_PO_COPYDOC_T

TABLE - JA.JAI_PO_COPY_T

TABLE - JA.JAI_PO_LINE_LOCATIONS

TABLE - JA.JAI_PO_OSP_BOM_T

TABLE - JA.JAI_PO_OSP_CENVAT_DTLS

TABLE - JA.JAI_PO_OSP_CENVAT_HDRS

TABLE - JA.JAI_PO_OSP_FORM_NUMBERS

TABLE - JA.JAI_PO_OSP_HDRS

TABLE - JA.JAI_PO_OSP_ITM_DTLS

TABLE - JA.JAI_PO_OSP_ITM_HDRS

TABLE - JA.JAI_PO_OSP_LINES

TABLE - JA.JAI_PO_OSP_LINE_DTLS

TABLE - JA.JAI_PO_QUOT_LINES_T

TABLE - JA.JAI_PO_REP_PRRG_T

TABLE - JA.JAI_PO_REQUEST_T

TABLE - JA.JAI_PO_REQ_LINES

TABLE - JA.JAI_PO_REQ_LINE_TAXES

TABLE - JA.JAI_PO_RMA_RTN_LINES

TABLE - JA.JAI_PO_RMA_RTN_TX_LNS

TABLE - JA.JAI_PO_TAXES

TABLE - JA.JAI_RCV_CENVAT_CLAIMS

TABLE - JA.JAI_RCV_CENVAT_CLAIM_T

TABLE - JA.JAI_RCV_HEADERS

TABLE - JA.JAI_RCV_INTERFACE_TRXS

TABLE - JA.JAI_RCV_JOURNAL_ENTRIES

TABLE - JA.JAI_RCV_LINES

TABLE - JA.JAI_RCV_LINE_TAXES

TABLE - JA.JAI_RCV_REP_ACCRUAL_T

TABLE - JA.JAI_RCV_RGM_CLAIMS

TABLE - JA.JAI_RCV_RGM_LINES

TABLE - JA.JAI_RCV_RTV_BATCH_GRPS

TABLE - JA.JAI_RCV_RTV_BATCH_TRXS

TABLE - JA.JAI_RCV_RTV_DTLS

TABLE - JA.JAI_RCV_SUBLED_ENTRIES

TABLE - JA.JAI_RCV_TP_BATCHES

TABLE - JA.JAI_RCV_TP_INVOICES

TABLE - JA.JAI_RCV_TP_INV_DETAILS

TABLE - JA.JAI_RCV_TRANSACTIONS

TABLE - JA.JAI_RETRO_LINE_CHANGES

TABLE - JA.JAI_RETRO_TAX_CHANGES

TABLE - JA.JAI_RGM_BALANCE_T

TABLE - JA.JAI_RGM_CERTIFICATES

TABLE - JA.JAI_RGM_CONC_REQUESTS

TABLE - JA.JAI_RGM_DEFINITIONS

TABLE - JA.JAI_RGM_DIS_DES_HDRS

TABLE - JA.JAI_RGM_DIS_DES_TAXES

TABLE - JA.JAI_RGM_DIS_SRC_HDRS

TABLE - JA.JAI_RGM_DIS_SRC_TAXES

TABLE - JA.JAI_RGM_DOC_SEQ_DTLS

TABLE - JA.JAI_RGM_DOC_SEQ_HDRS

TABLE - JA.JAI_RGM_INVOICE_GEN_T

TABLE - JA.JAI_RGM_ITEM_GEN_DOCS

TABLE - JA.JAI_RGM_ITM_REGNS

TABLE - JA.JAI_RGM_ITM_TEMPLATES

TABLE - JA.JAI_RGM_ITM_TMPL_ATTRS

TABLE - JA.JAI_RGM_LOOKUPS

TABLE - JA.JAI_RGM_MANUAL_TRXS

TABLE - JA.JAI_RGM_PARTIES

TABLE - JA.JAI_RGM_PARTY_REGNS

TABLE - JA.JAI_RGM_REFS_ALL

TABLE - JA.JAI_RGM_REGISTRATIONS

TABLE - JA.JAI_RGM_SETTLEMENTS

TABLE - JA.JAI_RGM_STL_BALANCES

TABLE - JA.JAI_RGM_TAXES

TABLE - JA.JAI_RGM_TERMS

TABLE - JA.JAI_RGM_TERM_ASSIGNS

TABLE - JA.JAI_RGM_THRESHOLDS

TABLE - JA.JAI_RGM_THRESHOLD_DTLS

TABLE - JA.JAI_RGM_TMPL_ITM_REGNS

TABLE - JA.JAI_RGM_TMPL_ORG_REGNS

TABLE - JA.JAI_RGM_TRM_SCHEDULES_T

TABLE - JA.JAI_RGM_TRX_RECORDS

TABLE - JA.JAI_RGM_TRX_REFS

TABLE - JA.JAI_RTP_POPULATE_T

TABLE - JA.JAI_RTP_TRANS_T

TABLE - JA.JAI_TRX_GT

TABLE - JA.JAI_TRX_REPO_EXTRACT_GT

TABLE - JA.JA_AU_ACCOUNT_DEFAULTS

TABLE - JA.JA_AU_ACCT_DEFAULT_SEGS

TABLE - JA.JA_AU_BAL_CHG_APPLIED

TABLE - JA.JA_AU_BAL_CHG_INTERFACE

TABLE - JA.JA_AU_BAL_CHG_SOURCE

TABLE - JA.JA_AU_CAPITAL_VALUE

TABLE - JA.JA_AU_FA_BOOK_CONTROLS

TABLE - JA.JA_AU_SRW_TAX_DEPRN_TMP

TABLE - JA.JA_AU_SUBINV_LOC_ASSOCS

TABLE - JA.JA_CN_ACCOUNTING_CLASSES_ALL

TABLE - JA.JA_CN_ACCOUNT_BALANCES

TABLE - JA.JA_CN_ACCOUNT_BALANCES_GT

TABLE - JA.JA_CN_ACCOUNT_BALANCES_POST_GT

TABLE - JA.JA_CN_ACCOUNT_CHILDREN_GT

TABLE - JA.JA_CN_ACCOUNT_STRUCTURES

TABLE - JA.JA_CN_CASH_ACCOUNTS_ALL

TABLE - JA.JA_CN_CASH_VALUESETS_ALL

TABLE - JA.JA_CN_CFS_ACTIVITIES_ALL

TABLE - JA.JA_CN_CFS_ACTIVITIES_INTERFACE

TABLE - JA.JA_CN_CFS_ASSIGNMENTS_ALL

TABLE - JA.JA_CN_CFS_CALCULATIONS_GT

TABLE - JA.JA_CN_CFS_ITEM_MAPPING_HDRS

TABLE - JA.JA_CN_CFS_ITEM_MAPPING_LINES

TABLE - JA.JA_CN_CFS_ROW_CGS_GT

TABLE - JA.JA_CN_COA_NA_EXCEPTIONS

TABLE - JA.JA_CN_DFF_ASSIGNMENTS

TABLE - JA.JA_CN_ERROR_ACCOUNTS

TABLE - JA.JA_CN_ITEM_INTERFACE

TABLE - JA.JA_CN_JOURNALS_OF_PERIOD

TABLE - JA.JA_CN_JOURNAL_LINES

TABLE - JA.JA_CN_JOURNAL_LINES_GT

TABLE - JA.JA_CN_JOURNAL_LINES_REQ

TABLE - JA.JA_CN_JOURNAL_NUMBERING

TABLE - JA.JA_CN_LEDGER_LE_BSV_GT

TABLE - JA.JA_CN_PERIODS

TABLE - JA.JA_CN_SOURCES_ALL

TABLE - JA.JA_CN_SUBSIDIARY_GT

TABLE - JA.JA_CN_SUB_ACC_SOURCES_ALL

TABLE - JA.JA_CN_SYSTEM_PARAMETERS_ALL

VIEW - APPS.JAI_57F4_PO_V

VIEW - APPS.JAI_AP_MATCH_TAXES_V

VIEW - APPS.JAI_AP_ST_FORMS_DTL_GRPRCPT_V

VIEW - APPS.JAI_AP_ST_MATCH_DTL_GRPRCPT_V

VIEW - APPS.JAI_AP_TDS_DEFAULT_SECTION_V

VIEW - APPS.JAI_AP_TDS_F16_DTLS_V

VIEW - APPS.JAI_AP_TDS_LE_NAME_V

VIEW - APPS.JAI_AP_TDS_NULLSITE_THHOLD_V

VIEW - APPS.JAI_AP_TDS_ORG_TAN_V

VIEW - APPS.JAI_AP_TDS_SECTION_TAX_V

VIEW - APPS.JAI_AP_TDS_SITE_V

VIEW - APPS.JAI_AP_TDS_THHOLD_EXCEPTION_V

VIEW - APPS.JAI_AP_TDS_THHOLD_VENDOR_V

VIEW - APPS.JAI_AP_TDS_TH_PAN_TAN_V

VIEW - APPS.JAI_AP_TDS_TH_VSITE_V

VIEW - APPS.JAI_AP_TDS_VNDR_TYPE_V

VIEW - APPS.JAI_AR_RG_BAL_V

VIEW - APPS.JAI_AR_ST_MATCH_DTL_GRPISS_V

VIEW - APPS.JAI_AR_TRX_DETAILS_V

VIEW - APPS.JAI_AR_TRX_DTLS_V

VIEW - APPS.JAI_AR_TRX_TMP_E_LINE_V

VIEW - APPS.JAI_CMN_BASE_CURRENCY_V

VIEW - APPS.JAI_CMN_BOE_APPLIED_V

VIEW - APPS.JAI_CMN_CESS_TRXS_V

VIEW - APPS.JAI_CMN_CUSTOMERS_V

VIEW - APPS.JAI_CMN_CUSTOMER_DTLS_V

VIEW - APPS.JAI_CMN_CUSTOMER_SITES_V

VIEW - APPS.JAI_CMN_CUST_ADDRESS_V

VIEW - APPS.JAI_CMN_HR_LOCATIONS_V

VIEW - APPS.JAI_CMN_ORG_DTLS_V

VIEW - APPS.JAI_CMN_PLA_REGISTER_V

VIEW - APPS.JAI_CMN_RG_23_II_V

VIEW - APPS.JAI_CMN_RG_BALANCES_V

VIEW - APPS.JAI_CMN_UOM_DTLS_V

VIEW - APPS.JAI_CMN_VENDOR_ADDRESS_V

VIEW - APPS.JAI_CMN_VENDOR_NAME_V

VIEW - APPS.JAI_FA_ASSETS_V

VIEW - APPS.JAI_FA_AST_RETIR_INAYR_V

VIEW - APPS.JAI_FBT_SETUP_HEADER_V

VIEW - APPS.JAI_FBT_TAX_TYPE_V

VIEW - APPS.JAI_MTL_CVAT_V

VIEW - APPS.JAI_OE_MATCH_LINES_V

VIEW - APPS.JAI_OM_CUST_ADDRESS_V

VIEW - APPS.JAI_OM_LC_MATCHING_V

VIEW - APPS.JAI_OM_WSH_DELIVERIES_V

VIEW - APPS.JAI_PO_CURRENCY_CODE_V

VIEW - APPS.JAI_PO_RFQQT_V

VIEW - APPS.JAI_PO_SHIPMENT_DTLS_V

VIEW - APPS.JAI_PO_VENDOR_NAMES_V

VIEW - APPS.JAI_RCV_ACCNT_HDR_V

VIEW - APPS.JAI_RCV_ACCOUNTING_V

VIEW - APPS.JAI_RCV_ACCT_DIST_V

VIEW - APPS.JAI_RCV_CLAIM_MODVAT_V

VIEW - APPS.JAI_RCV_COSTING_V

VIEW - APPS.JAI_RCV_RECEIVE_LINES_V

VIEW - APPS.JAI_RCV_RGM_HEADERS_V

VIEW - APPS.JAI_RCV_RGM_INSTALLMENT_V

VIEW - APPS.JAI_RCV_RGM_TAX_V

VIEW - APPS.JAI_RCV_RGM_TXNS_V

VIEW - APPS.JAI_RCV_RG_AMOUNT_V

VIEW - APPS.JAI_RCV_RG_QUANTITY_V

VIEW - APPS.JAI_RCV_RTV_LINES_V

VIEW - APPS.JAI_RCV_TAX_V

VIEW - APPS.JAI_REGIME_TAX_TYPES_V

VIEW - APPS.JAI_RGM_ITEM_ATTRIB_V

VIEW - APPS.JAI_RGM_ORGANIZATIONS_V

VIEW - APPS.JAI_RGM_ORG_REGNS_V

VIEW - APPS.JAI_RGM_PARTY_REGNS_V

VIEW - APPS.JAI_RGM_STL_BALANCES_V

VIEW - APPS.JAI_ST_FORMS_DTL_GRPISS_V

VIEW - APPS.JA_AU_ADDITIONS_ALLOCATIONS_V

VIEW - APPS.JA_AU_ADDITIONS_BOOKS_V

VIEW - APPS.JA_AU_BAL_CHG_DETAILS_V

VIEW - APPS.JA_AU_CAPITAL_VALUE_V

VIEW - APPS.JA_AU_FA_ADD_ADJ_V

VIEW - APPS.JA_AU_FA_BOOK_CONTROLS_V

VIEW - APPS.JA_AU_SOURCE_ADDITIONS_BOOKS_V

VIEW - APPS.JA_AU_SOURCE_ADDITIONS_V

VIEW - APPS.JA_AU_SUBINV_LOC_ASSOCS_V

VIEW - APPS.JA_CN_CFSBSV_V

VIEW - APPS.JA_LOOKUPS

VIEW - APPS.JA_LOOKUP_TYPES

VIEW - APPS.PA_COMMITMENT_TXNS_V

Table: JAI_AP_ETDS_ERRORS_T

[top of page]

JA.JAI_AP_ETDS_ERRORS_T does not reference any database object

JA.JAI_AP_ETDS_ERRORS_T is referenced by following:

APPS

SYNONYM - JAI_AP_ETDS_ERRORS_T

[top of page]

Table: JAI_AP_ETDS_REQUESTS

Primary Key: JAI_AP_ETDS_REQUESTS_PK

1. BATCH_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_AP_ETDS_REQUESTS does not reference any database object

JA.JAI_AP_ETDS_REQUESTS is referenced by following:

APPS

SYNONYM - JAI_AP_ETDS_REQUESTS

[top of page]

Table: JAI_AP_ETDS_T

Foreign Keys from this table:

[top of page]

JA.JAI_AP_ETDS_T does not reference any database object

JA.JAI_AP_ETDS_T is referenced by following:

APPS

SYNONYM - JAI_AP_ETDS_T

[top of page]

Table: JAI_AP_INVOICE_LINES

Primary Key: JAI_AP_INVOICE_LINES_PK

1. JAI_AP_INVOICE_LINES_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_INVOICE_LINES does not reference any database object

JA.JAI_AP_INVOICE_LINES is referenced by following:

APPS

SYNONYM - JAI_AP_INVOICE_LINES

[top of page]

Table: JAI_AP_MATCH_ERS_T

Foreign Keys from this table:

[top of page]

JA.JAI_AP_MATCH_ERS_T does not reference any database object

JA.JAI_AP_MATCH_ERS_T is referenced by following:

APPS

SYNONYM - JAI_AP_MATCH_ERS_T

[top of page]

Table: JAI_AP_MATCH_INV_TAXES

Primary Key: JAI_AP_MATCH_INV_TAXES_PK

1. TAX_DISTRIBUTION_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_MATCH_INV_TAXES does not reference any database object

JA.JAI_AP_MATCH_INV_TAXES is referenced by following:

APPS

SYNONYM - JAI_AP_MATCH_INV_TAXES

[top of page]

Table: JAI_AP_RGM_PAYMENTS

Primary Key: JAI_AP_RGM_PAYMENTS_PK

1. PAYMENT_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_RGM_PAYMENTS does not reference any database object

JA.JAI_AP_RGM_PAYMENTS is referenced by following:

APPS

SYNONYM - JAI_AP_RGM_PAYMENTS

[top of page]

Table: JAI_AP_TDS_CERT_NUMS

Primary Key: JAI_AP_TDS_CERT_NUMS_PK

1. FIN_YR_CERT_ID

Primary Key: JAI_AP_TDS_CERT_NUMS_UK1

1. ORGANIZATION_ID
2. LEGAL_ENTITY
3. FIN_YR

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_CERT_NUMS does not reference any database object

JA.JAI_AP_TDS_CERT_NUMS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_CERT_NUMS

[top of page]

Table: JAI_AP_TDS_F16_DTLS_ALL

Primary Key: JAI_AP_TDS_F16_DTLS_ALL_PK

1. FORM16_DTL_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_F16_DTLS_ALL does not reference any database object

JA.JAI_AP_TDS_F16_DTLS_ALL is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_F16_DTLS_ALL

[top of page]

Table: JAI_AP_TDS_F16_HDRS_ALL

Primary Key: JAI_AP_TDS_F16_HDRS_ALL_PK

1. FORM16_HDR_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_AP_TDS_F16_HDRS_ALL does not reference any database object

JA.JAI_AP_TDS_F16_HDRS_ALL is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_F16_HDRS_ALL

[top of page]

Table: JAI_AP_TDS_INVOICES

Primary Key: JAI_AP_TDS_INVOICES_PK

1. TDS_INVOICE_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_INVOICES does not reference any database object

JA.JAI_AP_TDS_INVOICES is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_INVOICES

[top of page]

Table: JAI_AP_TDS_INV_CANCELS

Primary Key: JAI_AP_TDS_INV_CANCELS_PK

1. TDS_INV_CANCEL_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_INV_CANCELS does not reference any database object

JA.JAI_AP_TDS_INV_CANCELS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_INV_CANCELS

[top of page]

Table: JAI_AP_TDS_INV_PAYMENTS

Primary Key: JAI_AP_TDS_INV_PAYMENTS_PK

1. TDS_PAYMENT_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_INV_PAYMENTS does not reference any database object

JA.JAI_AP_TDS_INV_PAYMENTS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_INV_PAYMENTS

[top of page]

Table: JAI_AP_TDS_INV_TAXES

Primary Key: JAI_AP_TDS_INV_TAXES_PK

1. TDS_INV_TAX_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_INV_TAXES does not reference any database object

JA.JAI_AP_TDS_INV_TAXES is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_INV_TAXES

[top of page]

Table: JAI_AP_TDS_PAN_CHANGES

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_PAN_CHANGES does not reference any database object

JA.JAI_AP_TDS_PAN_CHANGES is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_PAN_CHANGES

[top of page]

Table: JAI_AP_TDS_PAYMENTS

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_PAYMENTS does not reference any database object

JA.JAI_AP_TDS_PAYMENTS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_PAYMENTS

[top of page]

Table: JAI_AP_TDS_PREPAYMENTS

Primary Key: JAI_AP_TDS_PREPAYMENTS_PK

1. TDS_PREPAYMENT_ID

Primary Key: JAI_AP_TDS_PREPAYMENTS_UK1

1. INVOICE_ID
2. INVOICE_DISTRIBUTION_ID_PREPAY
3. INVOICE_DISTRIBUTION_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_PREPAYMENTS does not reference any database object

JA.JAI_AP_TDS_PREPAYMENTS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_PREPAYMENTS

[top of page]

Table: JAI_AP_TDS_THGRP_AUDITS

Primary Key: JAI_AP_TDS_THGRP_AUDITS_PK

1. THRESHOLD_GRP_AUDIT_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_THGRP_AUDITS does not reference any database object

JA.JAI_AP_TDS_THGRP_AUDITS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_THGRP_AUDITS

[top of page]

Table: JAI_AP_TDS_THHOLD_GRPS

Primary Key: JAI_AP_TDS_THHOLD_GRPS_PK

1. THRESHOLD_GRP_ID

Primary Key: JAI_AP_TDS_THHOLD_GRPS_UK1

1. VENDOR_ID
2. ORG_TAN_NUM
3. VENDOR_PAN_NUM
4. SECTION_TYPE
5. SECTION_CODE
6. FIN_YEAR

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_AP_TDS_THHOLD_GRPS does not reference any database object

JA.JAI_AP_TDS_THHOLD_GRPS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_THHOLD_GRPS

[top of page]

Table: JAI_AP_TDS_THHOLD_HDRS

Primary Key: JAI_AP_TDS_THHOLD_HDRS_PK

1. THRESHOLD_HDR_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_AP_TDS_THHOLD_HDRS does not reference any database object

JA.JAI_AP_TDS_THHOLD_HDRS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_THHOLD_HDRS

[top of page]

Table: JAI_AP_TDS_THHOLD_SLABS

Primary Key: JAI_AP_TDS_THHOLD_SLABS_PK

1. THRESHOLD_SLAB_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_AP_TDS_THHOLD_SLABS does not reference any database object

JA.JAI_AP_TDS_THHOLD_SLABS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_THHOLD_SLABS

[top of page]

Table: JAI_AP_TDS_THHOLD_TAXES

Primary Key: JAI_AP_TDS_THHOLD_TAXES_PK

1. THRESHOLD_TAX_ID

Primary Key: JAI_AP_TDS_THHOLD_TAXES_UK1

1. THRESHOLD_HDR_ID
2. THRESHOLD_TYPE_ID
3. THRESHOLD_SLAB_ID
4. OPERATING_UNIT_ID
5. TAX_ID
6. TAX_CATEGORY_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_THHOLD_TAXES does not reference any database object

JA.JAI_AP_TDS_THHOLD_TAXES is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_THHOLD_TAXES

[top of page]

Table: JAI_AP_TDS_THHOLD_TRXS

Primary Key: JAI_AP_TDS_THHOLD_TRXS_PK

1. THRESHOLD_TRX_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_AP_TDS_THHOLD_TRXS does not reference any database object

JA.JAI_AP_TDS_THHOLD_TRXS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_THHOLD_TRXS

[top of page]

Table: JAI_AP_TDS_THHOLD_TYPES

Primary Key: JAI_AP_TDS_THHOLD_TYPES_PK

1. THRESHOLD_TYPE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_AP_TDS_THHOLD_TYPES does not reference any database object

JA.JAI_AP_TDS_THHOLD_TYPES is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_THHOLD_TYPES

[top of page]

Table: JAI_AP_TDS_THHOLD_XCEPS

Primary Key: JAI_AP_TDS_THHOLD_XCEPS_PK

1. THRESHOLD_EXCEPTION_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_THHOLD_XCEPS does not reference any database object

JA.JAI_AP_TDS_THHOLD_XCEPS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_THHOLD_XCEPS

[top of page]

Table: JAI_AP_TDS_VENDOR_HDRS

Primary Key: JAI_AP_TDS_VENDOR_HDRS_PK

1. VENDOR_ID
2. VENDOR_SITE_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_VENDOR_HDRS does not reference any database object

JA.JAI_AP_TDS_VENDOR_HDRS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_VENDOR_HDRS

[top of page]

Table: JAI_AP_TDS_YEARS

Primary Key: JAI_AP_TDS_YEARS_PK

1. LEGAL_ENTITY_ID
2. FIN_YEAR

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TDS_YEARS does not reference any database object

JA.JAI_AP_TDS_YEARS is referenced by following:

APPS

SYNONYM - JAI_AP_TDS_YEARS

TRIGGER - JAI_JAP_TY_ARIUD_T1

[top of page]

Table: JAI_AP_TOL_SETUPS_ALL

Primary Key: JAI_AP_TOL_SETUPS_ALL_PK

1. ORG_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AP_TOL_SETUPS_ALL does not reference any database object

JA.JAI_AP_TOL_SETUPS_ALL is referenced by following:

APPS

SYNONYM - JAI_AP_TOL_SETUPS_ALL

[top of page]

Table: JAI_AR_CASH_RECEIPTS_ALL

Primary Key: JAI_AR_CASH_RECEIPTS_PK

1. LOC_CASH_RECEIPT_ID

[top of page]

JA.JAI_AR_CASH_RECEIPTS_ALL does not reference any database object

JA.JAI_AR_CASH_RECEIPTS_ALL is referenced by following:

APPS

SYNONYM - JAI_AR_CASH_RECEIPTS_ALL

[top of page]

Table: JAI_AR_DRB_CLAIMS

Primary Key: JAI_AR_DRB_CLAIMS_PK

1. CLAIM_NO

Foreign Keys from this table:

[top of page]

JA.JAI_AR_DRB_CLAIMS does not reference any database object

JA.JAI_AR_DRB_CLAIMS is referenced by following:

APPS

SYNONYM - JAI_AR_DRB_CLAIMS

[top of page]

Table: JAI_AR_ETCS_T

Primary Key: JA_IN_AR_ETCS_T_PK

1. BATCH_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AR_ETCS_T does not reference any database object

JA.JAI_AR_ETCS_T is referenced by following:

APPS

SYNONYM - JAI_AR_ETCS_T

[top of page]

Table: JAI_AR_EXCISE_UOM

Primary Key: JAI_AR_EXCISE_UOM_PK

1. EXCISE_UOM_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AR_EXCISE_UOM does not reference any database object

JA.JAI_AR_EXCISE_UOM is referenced by following:

APPS

SYNONYM - JAI_AR_EXCISE_UOM

[top of page]

Table: JAI_AR_PAYMENT_AUDITS

Primary Key: JAI_AR_PAYMENT_AUDITS_PK

1. PAYMENT_AUDIT_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AR_PAYMENT_AUDITS does not reference any database object

JA.JAI_AR_PAYMENT_AUDITS is referenced by following:

APPS

SYNONYM - JAI_AR_PAYMENT_AUDITS

[top of page]

Table: JAI_AR_REC_APPL_AUDITS

Primary Key: JAI_AR_REC_APPL_AUDITS_PK

1. REC_APPL_AUDIT_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AR_REC_APPL_AUDITS does not reference any database object

JA.JAI_AR_REC_APPL_AUDITS is referenced by following:

APPS

SYNONYM - JAI_AR_REC_APPL_AUDITS

[top of page]

Table: JAI_AR_SUP_CHANGES_ALL

Primary Key: JAI_AR_SUP_CHANGES_ALL_PK

1. MAPPING_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_AR_SUP_CHANGES_ALL does not reference any database object

JA.JAI_AR_SUP_CHANGES_ALL is referenced by following:

APPS

SYNONYM - JAI_AR_SUP_CHANGES_ALL

[top of page]

Table: JAI_AR_SUP_HDRS_ALL

Primary Key: JAI_AR_SUP_HDRS_ALL_PK

1. SUP_HDR_ID

Primary Key: JAI_AR_SUP_HDRS_ALL_UK1

1. SUPP_INV_TYPE
2. CUSTOMER_TRX_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AR_SUP_HDRS_ALL does not reference any database object

JA.JAI_AR_SUP_HDRS_ALL is referenced by following:

APPS

SYNONYM - JAI_AR_SUP_HDRS_ALL

[top of page]

Table: JAI_AR_SUP_INV_T

Foreign Keys from this table:

[top of page]

JA.JAI_AR_SUP_INV_T does not reference any database object

JA.JAI_AR_SUP_INV_T is referenced by following:

APPS

SYNONYM - JAI_AR_SUP_INV_T

[top of page]

Table: JAI_AR_SUP_LINES

Primary Key: JAI_AR_SUP_LINES_PK

1. CUSTOMER_TRX_LINE_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AR_SUP_LINES does not reference any database object

JA.JAI_AR_SUP_LINES is referenced by following:

APPS

SYNONYM - JAI_AR_SUP_LINES

[top of page]

Table: JAI_AR_SUP_TAXES

Primary Key: JAI_AR_SUP_TAXES_PK

1. CUSTOMER_TRX_LINE_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AR_SUP_TAXES does not reference any database object

JA.JAI_AR_SUP_TAXES is referenced by following:

APPS

SYNONYM - JAI_AR_SUP_TAXES

[top of page]

Table: JAI_AR_TDS_CERTIFICATES

Primary Key: JAI_AR_TDS_CERTIFICATES_PK

1. TDS_CERTIFICATE_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AR_TDS_CERTIFICATES does not reference any database object

JA.JAI_AR_TDS_CERTIFICATES is referenced by following:

APPS

SYNONYM - JAI_AR_TDS_CERTIFICATES

[top of page]

Table: JAI_AR_TRXS

Primary Key: JAI_AR_TRXS_PK

1. CUSTOMER_TRX_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_AR_TRXS does not reference any database object

JA.JAI_AR_TRXS is referenced by following:

APPS

SYNONYM - JAI_AR_TRXS

TRIGGER - JAI_JAR_T_ARIUD_T1

[top of page]

Table: JAI_AR_TRX_CM_T

Foreign Keys from this table:

[top of page]

JA.JAI_AR_TRX_CM_T does not reference any database object

JA.JAI_AR_TRX_CM_T is referenced by following:

APPS

SYNONYM - JAI_AR_TRX_CM_T

[top of page]

Table: JAI_AR_TRX_COPY_HDR_T

Foreign Keys from this table:

[top of page]

JA.JAI_AR_TRX_COPY_HDR_T does not reference any database object

JA.JAI_AR_TRX_COPY_HDR_T is referenced by following:

APPS

SYNONYM - JAI_AR_TRX_COPY_HDR_T

[top of page]

Table: JAI_AR_TRX_INS_HDRS_T

Foreign Keys from this table:

[top of page]

JA.JAI_AR_TRX_INS_HDRS_T does not reference any database object

JA.JAI_AR_TRX_INS_HDRS_T is referenced by following:

APPS

SYNONYM - JAI_AR_TRX_INS_HDRS_T

[top of page]

Table: JAI_AR_TRX_INS_LINES_T

Foreign Keys from this table:

[top of page]

JA.JAI_AR_TRX_INS_LINES_T does not reference any database object

JA.JAI_AR_TRX_INS_LINES_T is referenced by following:

APPS

SYNONYM - JAI_AR_TRX_INS_LINES_T

[top of page]

Table: JAI_AR_TRX_LINES

Primary Key: JAI_AR_TRX_LINES_PK

1. CUSTOMER_TRX_LINE_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AR_TRX_LINES does not reference any database object

JA.JAI_AR_TRX_LINES is referenced by following:

APPS

SYNONYM - JAI_AR_TRX_LINES

TRIGGER - JAI_JAR_TL_ARIUD_T1

[top of page]

Table: JAI_AR_TRX_POE_DTLS

Primary Key: JAI_AR_TRX_POE_DTLS_PK

1. POE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_AR_TRX_POE_DTLS does not reference any database object

JA.JAI_AR_TRX_POE_DTLS is referenced by following:

APPS

SYNONYM - JAI_AR_TRX_POE_DTLS

[top of page]

Table: JAI_AR_TRX_SUP_INV_T

Foreign Keys from this table:

[top of page]

JA.JAI_AR_TRX_SUP_INV_T does not reference any database object

JA.JAI_AR_TRX_SUP_INV_T is referenced by following:

APPS

SYNONYM - JAI_AR_TRX_SUP_INV_T

[top of page]

Table: JAI_AR_TRX_TAX_CALC_T

Foreign Keys from this table:

[top of page]

JA.JAI_AR_TRX_TAX_CALC_T does not reference any database object

JA.JAI_AR_TRX_TAX_CALC_T is referenced by following:

APPS

SYNONYM - JAI_AR_TRX_TAX_CALC_T

[top of page]

Table: JAI_AR_TRX_TAX_LINES

Primary Key: JAI_AR_TRX_TAX_LINES_PK

1. CUSTOMER_TRX_LINE_ID
2. TAX_ID

Primary Key: JAI_AR_TRX_TAX_LINES_UK

1. CUSTOMER_TRX_LINE_ID
2. TAX_ID

Foreign Keys from this table:

[top of page]

JA.JAI_AR_TRX_TAX_LINES does not reference any database object

JA.JAI_AR_TRX_TAX_LINES is referenced by following:

APPS

SYNONYM - JAI_AR_TRX_TAX_LINES

[top of page]

Table: JAI_AR_TRX_UPDATE_T

Foreign Keys from this table:

[top of page]

JA.JAI_AR_TRX_UPDATE_T does not reference any database object

JA.JAI_AR_TRX_UPDATE_T is referenced by following:

APPS

SYNONYM - JAI_AR_TRX_UPDATE_T

[top of page]

Table: JAI_BOM_FINISHED_GOODS

[top of page]

JA.JAI_BOM_FINISHED_GOODS does not reference any database object

JA.JAI_BOM_FINISHED_GOODS is referenced by following:

APPS

SYNONYM - JAI_BOM_FINISHED_GOODS

[top of page]

Table: JAI_BOM_RAW_MATERIALS

[top of page]

JA.JAI_BOM_RAW_MATERIALS does not reference any database object

JA.JAI_BOM_RAW_MATERIALS is referenced by following:

APPS

SYNONYM - JAI_BOM_RAW_MATERIALS

[top of page]

Table: JAI_CMN_BOE_AGENTS

Primary Key: JAI_CMN_BOE_AGENTS_PK

1. AGENT_ID

Primary Key: JAI_CMN_BOE_AGENTS_UK1

1. AGENT_CODE

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_BOE_AGENTS does not reference any database object

JA.JAI_CMN_BOE_AGENTS is referenced by following:

APPS

SYNONYM - JAI_CMN_BOE_AGENTS

[top of page]

Table: JAI_CMN_BOE_DTLS

Primary Key: JAI_CMN_BOE_DTLS_PK

1. BOE_ID
2. LINE_NUMBER

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_BOE_DTLS does not reference any database object

JA.JAI_CMN_BOE_DTLS is referenced by following:

APPS

SYNONYM - JAI_CMN_BOE_DTLS

[top of page]

Table: JAI_CMN_BOE_HDRS

Primary Key: JAI_CMN_BOE_HDRS_PK

1. BOE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_BOE_HDRS does not reference any database object

JA.JAI_CMN_BOE_HDRS is referenced by following:

APPS

SYNONYM - JAI_CMN_BOE_HDRS

[top of page]

Table: JAI_CMN_BOE_MATCHINGS

Primary Key: JAI_CMN_BOE_MATCHINGS_PK

1. BOE_MATCHING_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_BOE_MATCHINGS does not reference any database object

JA.JAI_CMN_BOE_MATCHINGS is referenced by following:

APPS

SYNONYM - JAI_CMN_BOE_MATCHINGS

[top of page]

Table: JAI_CMN_BOE_WRITEOFFS

Primary Key: JAI_CMN_BOE_WRITEOFFS_PK

1. BOE_WRITEOFF_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_BOE_WRITEOFFS does not reference any database object

JA.JAI_CMN_BOE_WRITEOFFS is referenced by following:

APPS

SYNONYM - JAI_CMN_BOE_WRITEOFFS

[top of page]

Table: JAI_CMN_CUS_ADDRESSES

Primary Key: JAI_CMN_CUS_ADDRESSES_PK

1. CUSTOMER_ADDRESS_ID

Primary Key: JAI_CMN_CUS_ADDRESSES_UK1

1. CUSTOMER_ID
2. ADDRESS_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_CUS_ADDRESSES does not reference any database object

JA.JAI_CMN_CUS_ADDRESSES is referenced by following:

APPS

SYNONYM - JAI_CMN_CUS_ADDRESSES

[top of page]

Table: JAI_CMN_DEBUG_CONTEXTS

Primary Key: JAI_CMN_DEBUG_CONTEXTS_PK

1. DEBUG_LOG_ID

[top of page]

JA.JAI_CMN_DEBUG_CONTEXTS does not reference any database object

JA.JAI_CMN_DEBUG_CONTEXTS is referenced by following:

APPS

SYNONYM - JAI_CMN_DEBUG_CONTEXTS

[top of page]

Table: JAI_CMN_DOCUMENT_TAXES

Primary Key: JAI_CMN_DOCUMENT_TAXES_PK

1. DOC_TAX_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_DOCUMENT_TAXES does not reference any database object

JA.JAI_CMN_DOCUMENT_TAXES is referenced by following:

APPS

SYNONYM - JAI_CMN_DOCUMENT_TAXES

[top of page]

Table: JAI_CMN_ERRORS_T

[top of page]

JA.JAI_CMN_ERRORS_T does not reference any database object

JA.JAI_CMN_ERRORS_T is referenced by following:

APPS

SYNONYM - JAI_CMN_ERRORS_T

[top of page]

Table: JAI_CMN_FIN_YEARS

Primary Key: JAI_CMN_FIN_YEARS_PK

1. ORGANIZATION_ID
2. FIN_YEAR

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_FIN_YEARS does not reference any database object

JA.JAI_CMN_FIN_YEARS is referenced by following:

APPS

SYNONYM - JAI_CMN_FIN_YEARS

[top of page]

Table: JAI_CMN_INVENTORY_ORGS

Primary Key: JAI_CMN_INVENTORY_ORGS_PK

1. ORG_UNIT_ID

Primary Key: JAI_CMN_INVENTORY_ORGS_UK1

1. ORGANIZATION_ID
2. LOCATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_INVENTORY_ORGS does not reference any database object

JA.JAI_CMN_INVENTORY_ORGS is referenced by following:

APPS

SYNONYM - JAI_CMN_INVENTORY_ORGS

[top of page]

Table: JAI_CMN_JOURNAL_ENTRIES

Primary Key: JAI_CMN_JOURNAL_ENTRIES_PK

1. JOURNAL_ENTRY_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_JOURNAL_ENTRIES does not reference any database object

JA.JAI_CMN_JOURNAL_ENTRIES is referenced by following:

APPS

SYNONYM - JAI_CMN_JOURNAL_ENTRIES

[top of page]

Table: JAI_CMN_LINES

Primary Key: JAI_CMN_LINES_PK

1. CMN_LINE_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_LINES does not reference any database object

JA.JAI_CMN_LINES is referenced by following:

APPS

SYNONYM - JAI_CMN_LINES

[top of page]

Table: JAI_CMN_MATCH_RECEIPTS

Primary Key: JAI_CMN_MATCH_RECEIPTS_PK

1. RECEIPT_ID
2. REF_LINE_ID
3. ORDER_INVOICE

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_MATCH_RECEIPTS does not reference any database object

JA.JAI_CMN_MATCH_RECEIPTS is referenced by following:

APPS

SYNONYM - JAI_CMN_MATCH_RECEIPTS

TRIGGER - JAI_JCMR_ARIUD_T1

[top of page]

Table: JAI_CMN_MATCH_TAXES

Primary Key: JAI_CMN_MATCH_TAXES_PK

1. MATCH_TAX_ID

Primary Key: JAI_CMN_MATCH_TAXES_UK1

1. REF_LINE_ID
2. ORDER_INVOICE
3. RECEIPT_ID
4. TAX_LINE_NO

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_MATCH_TAXES does not reference any database object

JA.JAI_CMN_MATCH_TAXES is referenced by following:

APPS

SYNONYM - JAI_CMN_MATCH_TAXES

[top of page]

Table: JAI_CMN_MTAX_HDRS_ALL

Primary Key: JAI_CMN_MTAX_HDRS_ALL_PK

1. BATCH_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_MTAX_HDRS_ALL does not reference any database object

JA.JAI_CMN_MTAX_HDRS_ALL is referenced by following:

APPS

SYNONYM - JAI_CMN_MTAX_HDRS_ALL

[top of page]

Table: JAI_CMN_MTAX_UPD_DTLS

Primary Key: JAI_CMN_MTAX_UPD_DTLS_PK

1. MTAX_DTL_ID

Primary Key: JAI_CMN_MTAX_UPD_DTLS_UK1

1. BATCH_ID
2. DOCUMENT_NO
3. RELEASE_NO
4. DOCUMENT_LINE_NO
5. SHIPMENT_NO

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_MTAX_UPD_DTLS does not reference any database object

JA.JAI_CMN_MTAX_UPD_DTLS is referenced by following:

APPS

SYNONYM - JAI_CMN_MTAX_UPD_DTLS

[top of page]

Table: JAI_CMN_OM_AR_AR3_FORMS

Primary Key: JAI_CMN_OM_AR_AR3_FORMS_PK

1. FORM_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_OM_AR_AR3_FORMS does not reference any database object

JA.JAI_CMN_OM_AR_AR3_FORMS is referenced by following:

APPS

SYNONYM - JAI_CMN_OM_AR_AR3_FORMS

[top of page]

Table: JAI_CMN_RG_23AC_II_TRXS

Primary Key: JAI_CMN_RG_23AC_II_TRXS_PK

1. REGISTER_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_RG_23AC_II_TRXS does not reference any database object

JA.JAI_CMN_RG_23AC_II_TRXS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_23AC_II_TRXS

TRIGGER - JAI_JRG_23AC2_BRIUD_T1

[top of page]

Table: JAI_CMN_RG_23AC_I_TRXS

Primary Key: JAI_CMN_RG_23AC_I_TRXS_PK

1. REGISTER_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_RG_23AC_I_TRXS does not reference any database object

JA.JAI_CMN_RG_23AC_I_TRXS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_23AC_I_TRXS

TRIGGER - JAI_JRG_23AC1_BRIUD_T1

[top of page]

Table: JAI_CMN_RG_23D_TRXS

Primary Key: JAI_CMN_RG_23D_TRXS_PK

1. REGISTER_ID

Primary Key: JAI_CMN_RG_23D_TRXS_UK1

1. ORGANIZATION_ID
2. LOCATION_ID
3. FIN_YEAR
4. INVENTORY_ITEM_ID
5. SLNO

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_RG_23D_TRXS does not reference any database object

JA.JAI_CMN_RG_23D_TRXS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_23D_TRXS

[top of page]

Table: JAI_CMN_RG_BALANCES

Primary Key: JAI_CMN_RG_BALANCES_PK

1. ORG_UNIT_ID

Primary Key: JAI_CMN_RG_BALANCES_UK1

1. ORGANIZATION_ID
2. LOCATION_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_BALANCES does not reference any database object

JA.JAI_CMN_RG_BALANCES is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_BALANCES

[top of page]

Table: JAI_CMN_RG_COMP_BALS

Primary Key: JAI_CMN_RG_COMP_BALS_PK

1. COMPONENT_BALANCE_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_COMP_BALS does not reference any database object

JA.JAI_CMN_RG_COMP_BALS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_COMP_BALS

[top of page]

Table: JAI_CMN_RG_COMP_DTLS

Primary Key: JAI_CMN_RG_COMP_DTLS_PK

1. EXCISE_COMP_DTL_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_COMP_DTLS does not reference any database object

JA.JAI_CMN_RG_COMP_DTLS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_COMP_DTLS

[top of page]

Table: JAI_CMN_RG_CONSLDATIONS

Primary Key: JAI_CMN_RG_CONSLDATIONS_PK

1. CONSOLIDATION_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_CONSLDATIONS does not reference any database object

JA.JAI_CMN_RG_CONSLDATIONS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_CONSLDATIONS

[top of page]

Table: JAI_CMN_RG_EXC_INV_NOS

Primary Key: JAI_CMN_RG_EXC_INV_NOS_PK

1. EXC_INV_NUM_ID

Primary Key: JAI_CMN_RG_EXC_INV_NOS_UK1

1. ORGANIZATION_ID
2. LOCATION_ID
3. FIN_YEAR
4. TRANSACTION_TYPE
5. ORDER_INVOICE_TYPE
6. REGISTER_CODE

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_EXC_INV_NOS does not reference any database object

JA.JAI_CMN_RG_EXC_INV_NOS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_EXC_INV_NOS

[top of page]

Table: JAI_CMN_RG_I_TRXS

Primary Key: JAI_CMN_RG_I_TRXS_PK

1. REGISTER_ID

Primary Key: JAI_CMN_RG_I_TRXS_UK1

1. ORGANIZATION_ID
2. LOCATION_ID
3. FIN_YEAR
4. INVENTORY_ITEM_ID
5. SLNO

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_I_TRXS does not reference any database object

JA.JAI_CMN_RG_I_TRXS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_I_TRXS

[top of page]

Table: JAI_CMN_RG_OTHERS

Primary Key: JAI_CMN_RG_OTHERS_PK

1. RG_OTHER_ID

Primary Key: JAI_CMN_RG_OTHERS_UK1

1. SOURCE_TYPE
2. SOURCE_REGISTER_ID
3. TAX_TYPE

[top of page]

JA.JAI_CMN_RG_OTHERS does not reference any database object

JA.JAI_CMN_RG_OTHERS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_OTHERS

TRIGGER - JAI_JRG_OTH_BRIUD_T1

[top of page]

Table: JAI_CMN_RG_OTH_BALANCES

Primary Key: JAI_CMN_RG_OTH_BALANCES_PK

1. ORG_UNIT_ID
2. REGISTER_TYPE
3. TAX_TYPE

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_OTH_BALANCES does not reference any database object

JA.JAI_CMN_RG_OTH_BALANCES is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_OTH_BALANCES

[top of page]

Table: JAI_CMN_RG_PERIOD_BALS

Primary Key: JAI_CMN_RG_PERIOD_BALS_PK

1. PERIOD_BALANCE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_RG_PERIOD_BALS does not reference any database object

JA.JAI_CMN_RG_PERIOD_BALS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_PERIOD_BALS

[top of page]

Table: JAI_CMN_RG_PLA_CMP_DTLS

Primary Key: JAI_CMN_RG_PLA_CMP_DTLS_PK

1. REGISTER_ID

Primary Key: JAI_CMN_RG_PLA_CMP_DTLS_UK1

1. ORGANIZATION_ID
2. LOCATION_ID
3. FIN_YEAR
4. INVENTORY_ITEM_ID
5. SLNO

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_PLA_CMP_DTLS does not reference any database object

JA.JAI_CMN_RG_PLA_CMP_DTLS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_PLA_CMP_DTLS

[top of page]

Table: JAI_CMN_RG_PLA_DTLS

Primary Key: JAI_CMN_RG_PLA_DTLS_PK

1. PLA_ID
2. LINE_NUMBER

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_PLA_DTLS does not reference any database object

JA.JAI_CMN_RG_PLA_DTLS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_PLA_DTLS

[top of page]

Table: JAI_CMN_RG_PLA_HDRS

Primary Key: JAI_CMN_RG_PLA_HDRS_PK

1. PLA_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_RG_PLA_HDRS does not reference any database object

JA.JAI_CMN_RG_PLA_HDRS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_PLA_HDRS

[top of page]

Table: JAI_CMN_RG_PLA_TRXS

Primary Key: JAI_CMN_RG_PLA_TRXS_PK

1. REGISTER_ID

Primary Key: JAI_CMN_RG_PLA_TRXS_UK1

1. ORGANIZATION_ID
2. LOCATION_ID
3. FIN_YEAR
4. SLNO

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_RG_PLA_TRXS does not reference any database object

JA.JAI_CMN_RG_PLA_TRXS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_PLA_TRXS

TRIGGER - JAI_JRG_PLA_BRIUD_T1

[top of page]

Table: JAI_CMN_RG_ROUND_HDRS

Primary Key: JAI_CMN_RG_ROUND_HDRS_PK

1. ROUNDING_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_RG_ROUND_HDRS does not reference any database object

JA.JAI_CMN_RG_ROUND_HDRS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_ROUND_HDRS

[top of page]

Table: JAI_CMN_RG_ROUND_LINES

Primary Key: JAI_CMN_RG_ROUND_LINES_PK

1. ROUNDING_LINE_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_ROUND_LINES does not reference any database object

JA.JAI_CMN_RG_ROUND_LINES is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_ROUND_LINES

[top of page]

Table: JAI_CMN_RG_SLNOS

Primary Key: JAI_CMN_RG_SLNOS_PK

1. ORGANIZATION_ID
2. LOCATION_ID
3. REGISTER_TYPE

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_SLNOS does not reference any database object

JA.JAI_CMN_RG_SLNOS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_SLNOS

[top of page]

Table: JAI_CMN_RG_TRANSFERS

Primary Key: JAI_CMN_RG_TRANSFERS_PK

1. TRANSFER_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_RG_TRANSFERS does not reference any database object

JA.JAI_CMN_RG_TRANSFERS is referenced by following:

APPS

SYNONYM - JAI_CMN_RG_TRANSFERS

[top of page]

Table: JAI_CMN_STFORM_HDRS_ALL

Primary Key: JAI_CMN_STFORM_HDRS_ALL_PK

1. ST_HDR_ID

Primary Key: JAI_CMN_STFORM_HDRS_ALL_UK

1. PARTY_ID
2. PARTY_SITE_ID
3. FORM_TYPE
4. ORG_ID
5. PARTY_TYPE_FLAG

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_STFORM_HDRS_ALL does not reference any database object

JA.JAI_CMN_STFORM_HDRS_ALL is referenced by following:

APPS

SYNONYM - JAI_CMN_STFORM_HDRS_ALL

[top of page]

Table: JAI_CMN_ST_FORMS

Primary Key: JAI_CMN_ST_FORMS_PK

1. FORM_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_ST_FORMS does not reference any database object

JA.JAI_CMN_ST_FORMS is referenced by following:

APPS

SYNONYM - JAI_CMN_ST_FORMS

[top of page]

Table: JAI_CMN_ST_FORM_DTLS

Primary Key: JAI_CMN_ST_FORM_DTLS_PK

1. ST_DTL_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_ST_FORM_DTLS does not reference any database object

JA.JAI_CMN_ST_FORM_DTLS is referenced by following:

APPS

SYNONYM - JAI_CMN_ST_FORM_DTLS

[top of page]

Table: JAI_CMN_ST_MATCH_DTLS

Primary Key: JAI_CMN_ST_MATCH_DTLS_PK

1. ST_HDR_ID
2. ST_DTL_ID
3. FORM_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_ST_MATCH_DTLS does not reference any database object

JA.JAI_CMN_ST_MATCH_DTLS is referenced by following:

APPS

SYNONYM - JAI_CMN_ST_MATCH_DTLS

[top of page]

Table: JAI_CMN_TAXCTG_UPDATES

Primary Key: JAI_CMN_TAXCTG_UPDATES_PK

1. TAX_CATEGORY_UPDATE_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_TAXCTG_UPDATES does not reference any database object

JA.JAI_CMN_TAXCTG_UPDATES is referenced by following:

APPS

SYNONYM - JAI_CMN_TAXCTG_UPDATES

[top of page]

Table: JAI_CMN_TAXES_ALL

Primary Key: JAI_CMN_TAXES_ALL_PK

1. TAX_ID

Primary Key: JAI_CMN_TAXES_ALL_UK1

1. TAX_NAME

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_TAXES_ALL does not reference any database object

JA.JAI_CMN_TAXES_ALL is referenced by following:

APPS

SYNONYM - JAI_CMN_TAXES_ALL

[top of page]

Table: JAI_CMN_TAX_CTGS_ALL

Primary Key: JAI_CMN_TAX_CTGS_ALL_PK

1. TAX_CATEGORY_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_TAX_CTGS_ALL does not reference any database object

JA.JAI_CMN_TAX_CTGS_ALL is referenced by following:

APPS

SYNONYM - JAI_CMN_TAX_CTGS_ALL

[top of page]

Table: JAI_CMN_TAX_CTG_LINES

Primary Key: JAI_CMN_TAX_CTG_LINES_PK

1. TAX_CATEGORY_ID
2. TAX_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_TAX_CTG_LINES does not reference any database object

JA.JAI_CMN_TAX_CTG_LINES is referenced by following:

APPS

SYNONYM - JAI_CMN_TAX_CTG_LINES

[top of page]

Table: JAI_CMN_TRANSACTIONS_T

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_TRANSACTIONS_T does not reference any database object

JA.JAI_CMN_TRANSACTIONS_T is referenced by following:

APPS

SYNONYM - JAI_CMN_TRANSACTIONS_T

[top of page]

Table: JAI_CMN_VENDOR_SITES

Primary Key: JAI_CMN_VENDOR_SITES_PK

1. VENDOR_ID
2. VENDOR_SITE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_CMN_VENDOR_SITES does not reference any database object

JA.JAI_CMN_VENDOR_SITES is referenced by following:

APPS

SYNONYM - JAI_CMN_VENDOR_SITES

[top of page]

Table: JAI_CMN_WRITEOFFS_T

Foreign Keys from this table:

[top of page]

JA.JAI_CMN_WRITEOFFS_T does not reference any database object

JA.JAI_CMN_WRITEOFFS_T is referenced by following:

APPS

SYNONYM - JAI_CMN_WRITEOFFS_T

[top of page]

Table: JAI_CRM_QUOTE_TAXES

Primary Key: JAI_CRM_QUOTE_TAXES_PK

1. SHIPMENT_ID
2. TAX_ID

Foreign Keys from this table:

[top of page]

JA.JAI_CRM_QUOTE_TAXES does not reference any database object

JA.JAI_CRM_QUOTE_TAXES is referenced by following:

APPS

SYNONYM - JAI_CRM_QUOTE_TAXES

[top of page]

Table: JAI_DIST_TAX_TYPE

Primary Key: JAI_DIST_TAX_TYPE_PK

1. DIST_TAX_TYPE_ID

[top of page]

JA.JAI_DIST_TAX_TYPE does not reference any database object

JA.JAI_DIST_TAX_TYPE is referenced by following:

APPS

SYNONYM - JAI_DIST_TAX_TYPE

[top of page]

Table: JAI_ENCUM_TAX_DETAILS

Foreign Keys from this table:

[top of page]

JA.JAI_ENCUM_TAX_DETAILS does not reference any database object

JA.JAI_ENCUM_TAX_DETAILS is referenced by following:

APPS

SYNONYM - JAI_ENCUM_TAX_DETAILS

[top of page]

Table: JAI_ENCUM_TAX_RVRSL_DTLS

Foreign Keys from this table:

[top of page]

JA.JAI_ENCUM_TAX_RVRSL_DTLS does not reference any database object

JA.JAI_ENCUM_TAX_RVRSL_DTLS is referenced by following:

APPS

SYNONYM - JAI_ENCUM_TAX_RVRSL_DTLS

[top of page]

Table: JAI_FA_AST_BLOCKS

Primary Key: JAI_FA_AST_BLOCKS_PK

1. BLOCK_ID

Primary Key: JAI_FA_AST_BLOCKS_UK1

1. TYPE
2. START_DATE
3. BOOK_TYPE_CODE

Foreign Keys to this table:

[top of page]

JA.JAI_FA_AST_BLOCKS does not reference any database object

JA.JAI_FA_AST_BLOCKS is referenced by following:

APPS

SYNONYM - JAI_FA_AST_BLOCKS

[top of page]

Table: JAI_FA_AST_BLOCK_DTLS

Foreign Keys from this table:

[top of page]

JA.JAI_FA_AST_BLOCK_DTLS does not reference any database object

JA.JAI_FA_AST_BLOCK_DTLS is referenced by following:

APPS

SYNONYM - JAI_FA_AST_BLOCK_DTLS

[top of page]

Table: JAI_FA_AST_BLOCK_H

Primary Key: JAI_FA_AST_BLOCK_H_PK

1. BLOCK_HISTORY_ID

Foreign Keys from this table:

[top of page]

JA.JAI_FA_AST_BLOCK_H does not reference any database object

JA.JAI_FA_AST_BLOCK_H is referenced by following:

APPS

SYNONYM - JAI_FA_AST_BLOCK_H

[top of page]

Table: JAI_FA_AST_PERIOD_RATES

Primary Key: JAI_FA_AST_PERIOD_RATES_PK

1. PERIOD_RATE_ID

Foreign Keys from this table:

[top of page]

JA.JAI_FA_AST_PERIOD_RATES does not reference any database object

JA.JAI_FA_AST_PERIOD_RATES is referenced by following:

APPS

SYNONYM - JAI_FA_AST_PERIOD_RATES

[top of page]

Table: JAI_FA_AST_YEARS

Primary Key: JAI_FA_AST_YEARS_PK

1. YEAR_ID

Primary Key: JAI_FA_AST_YEARS_UK1

1. YEAR_START
2. YEAR_END

[top of page]

JA.JAI_FA_AST_YEARS does not reference any database object

JA.JAI_FA_AST_YEARS is referenced by following:

APPS

SYNONYM - JAI_FA_AST_YEARS

[top of page]

Table: JAI_FA_DEP_BLOCKS

Primary Key: JAI_FA_DEP_BLOCKS_PK

1. BLOCK_DEPN_ID

Foreign Keys from this table:

[top of page]

JA.JAI_FA_DEP_BLOCKS does not reference any database object

JA.JAI_FA_DEP_BLOCKS is referenced by following:

APPS

SYNONYM - JAI_FA_DEP_BLOCKS

[top of page]

Table: JAI_FA_DEP_BLOCKS_T

Foreign Keys from this table:

[top of page]

JA.JAI_FA_DEP_BLOCKS_T does not reference any database object

JA.JAI_FA_DEP_BLOCKS_T is referenced by following:

APPS

SYNONYM - JAI_FA_DEP_BLOCKS_T

[top of page]

Table: JAI_FA_EXEMPTIONS

Primary Key: JAI_FA_EXEMPTIONS_PK

1. FA_EXEMPTION_ID

Foreign Keys from this table:

[top of page]

JA.JAI_FA_EXEMPTIONS does not reference any database object

JA.JAI_FA_EXEMPTIONS is referenced by following:

APPS

SYNONYM - JAI_FA_EXEMPTIONS

[top of page]

Table: JAI_FA_MASS_ADDITIONS

Primary Key: JAI_FA_MASS_ADDITIONS_PK

1. MASS_ADDITION_ID

Foreign Keys from this table:

[top of page]

JA.JAI_FA_MASS_ADDITIONS does not reference any database object

JA.JAI_FA_MASS_ADDITIONS is referenced by following:

APPS

SYNONYM - JAI_FA_MASS_ADDITIONS

[top of page]

Table: JAI_FBT_PAYMENT

Primary Key: JAI_FBT_PAYMENT_PK

1. FBT_PAYMENT_ID

Foreign Keys from this table:

[top of page]

JA.JAI_FBT_PAYMENT does not reference any database object

JA.JAI_FBT_PAYMENT is referenced by following:

APPS

SYNONYM - JAI_FBT_PAYMENT

[top of page]

Table: JAI_FBT_PROCESS_DATE

Primary Key: JAI_FBT_PROCESS_DATE_PK

1. FBT_YEAR
2. LEGAL_ENTITY_ID

[top of page]

JA.JAI_FBT_PROCESS_DATE does not reference any database object

JA.JAI_FBT_PROCESS_DATE is referenced by following:

APPS

SYNONYM - JAI_FBT_PROCESS_DATE

[top of page]

Table: JAI_FBT_REPOSITORY

Primary Key: JAI_FBT_REPOSITORY_PK

1. FBT_TRANSACTION_ID

Foreign Keys from this table:

[top of page]

JA.JAI_FBT_REPOSITORY does not reference any database object

JA.JAI_FBT_REPOSITORY is referenced by following:

APPS

SYNONYM - JAI_FBT_REPOSITORY

[top of page]

Table: JAI_FBT_SETTLEMENT

Primary Key: JAI_FBT_SETTLEMENT_PK

1. SETTLEMENT_ID

Foreign Keys from this table:

[top of page]

JA.JAI_FBT_SETTLEMENT does not reference any database object

JA.JAI_FBT_SETTLEMENT is referenced by following:

APPS

SYNONYM - JAI_FBT_SETTLEMENT

[top of page]

Table: JAI_FBT_SETUP

Foreign Keys from this table:

[top of page]

JA.JAI_FBT_SETUP does not reference any database object

JA.JAI_FBT_SETUP is referenced by following:

APPS

SYNONYM - JAI_FBT_SETUP

[top of page]

Table: JAI_FBT_SETUP_HEADERS

Primary Key: JAI_FBT_SETUP_HEADERS_PK

1. LEGAL_ENTITY_ID
2. FBT_YEAR

[top of page]

JA.JAI_FBT_SETUP_HEADERS does not reference any database object

JA.JAI_FBT_SETUP_HEADERS is referenced by following:

APPS

SYNONYM - JAI_FBT_SETUP_HEADERS

[top of page]

Table: JAI_FBT_SETUP_LINES

Primary Key: JAI_FBT_SETUP_LINES_PK

1. LEGAL_ENTITY_ID
2. FBT_YEAR

[top of page]

JA.JAI_FBT_SETUP_LINES does not reference any database object

JA.JAI_FBT_SETUP_LINES is referenced by following:

APPS

SYNONYM - JAI_FBT_SETUP_LINES

[top of page]

Table: JAI_INV_ITM_SETUPS

Primary Key: JAI_INV_ITM_SETUPS_PK

1. INVENTORY_ITEM_ID
2. ORGANIZATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_INV_ITM_SETUPS does not reference any database object

JA.JAI_INV_ITM_SETUPS is referenced by following:

APPS

SYNONYM - JAI_INV_ITM_SETUPS

[top of page]

Table: JAI_INV_ITM_TAXCTG_DTLS

Primary Key: JAI_INV_ITM_TAXCTG_DTLS_PK

1. TAX_CATEGORY_ID
2. INVENTORY_ITEM_ID
3. TAX_CATEGORY_LIST

Foreign Keys from this table:

[top of page]

JA.JAI_INV_ITM_TAXCTG_DTLS does not reference any database object

JA.JAI_INV_ITM_TAXCTG_DTLS is referenced by following:

APPS

SYNONYM - JAI_INV_ITM_TAXCTG_DTLS

[top of page]

Table: JAI_INV_ITM_TAXCTG_HDRS

Primary Key: JAI_INV_ITM_TAXCTG_HDRS_PK

1. TAX_CATEGORY_LIST

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_INV_ITM_TAXCTG_HDRS does not reference any database object

JA.JAI_INV_ITM_TAXCTG_HDRS is referenced by following:

APPS

SYNONYM - JAI_INV_ITM_TAXCTG_HDRS

[top of page]

Table: JAI_INV_SUBINV_DTLS

Primary Key: JAI_INV_SUBINV_DTLS_PK

1. ORGANIZATION_ID
2. LOCATION_ID
3. SUB_INVENTORY_NAME

Foreign Keys from this table:

[top of page]

JA.JAI_INV_SUBINV_DTLS does not reference any database object

JA.JAI_INV_SUBINV_DTLS is referenced by following:

APPS

SYNONYM - JAI_INV_SUBINV_DTLS

[top of page]

Table: JAI_INV_SUBINV_HDRS

Primary Key: JAI_INV_SUBINV_HDRS_PK

1. ORGANIZATION_ID
2. LOCATION_ID

Foreign Keys from this table:

[top of page]

JA.JAI_INV_SUBINV_HDRS does not reference any database object

JA.JAI_INV_SUBINV_HDRS is referenced by following:

APPS

SYNONYM - JAI_INV_SUBINV_HDRS

[top of page]

Table: JAI_INV_TXN_EXT_DTLS

Primary Key: JAI_INV_TXN_EXT_DTLS_PK

1. TRANSACTION_NAME
2. TRANSACTION_HEADER_ID
3. SERIAL_NO

Foreign Keys from this table:

[top of page]

JA.JAI_INV_TXN_EXT_DTLS does not reference any database object

JA.JAI_INV_TXN_EXT_DTLS is referenced by following:

APPS

SYNONYM - JAI_INV_TXN_EXT_DTLS

[top of page]

Table: JAI_INV_TXN_EXT_HDRS

Primary Key: JAI_INV_TXN_EXT_HDRS_PK

1. TRANSACTION_NAME
2. TRANSACTION_HEADER_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_INV_TXN_EXT_HDRS does not reference any database object

JA.JAI_INV_TXN_EXT_HDRS is referenced by following:

APPS

SYNONYM - JAI_INV_TXN_EXT_HDRS

[top of page]

Table: JAI_MTL_MATCH_RECEIPTS

Primary Key: JAI_MTL_MATCH_RECEIPTS_PK

1. MATCH_RECEIPT_ID

Foreign Keys from this table:

[top of page]

JA.JAI_MTL_MATCH_RECEIPTS does not reference any database object

JA.JAI_MTL_MATCH_RECEIPTS is referenced by following:

APPS

SYNONYM - JAI_MTL_MATCH_RECEIPTS

[top of page]

Table: JAI_MTL_TRXS

Primary Key: JAI_MTL_TRXS_PK

1. TRANSACTION_ID

Foreign Keys from this table:

[top of page]

JA.JAI_MTL_TRXS does not reference any database object

JA.JAI_MTL_TRXS is referenced by following:

APPS

SYNONYM - JAI_MTL_TRXS

[top of page]

Table: JAI_MTL_TRX_JRNLS

Primary Key: JAI_MTL_TRX_JRNLS_PK

1. JOURNAL_ENTRY_ID

Foreign Keys from this table:

[top of page]

JA.JAI_MTL_TRX_JRNLS does not reference any database object

JA.JAI_MTL_TRX_JRNLS is referenced by following:

APPS

SYNONYM - JAI_MTL_TRX_JRNLS

[top of page]

Table: JAI_MTL_TXN_CST_DTL_T

[top of page]

JA.JAI_MTL_TXN_CST_DTL_T does not reference any database object

JA.JAI_MTL_TXN_CST_DTL_T is referenced by following:

APPS

SYNONYM - JAI_MTL_TXN_CST_DTL_T

[top of page]

Table: JAI_MTL_TXN_CST_HDR_T

[top of page]

JA.JAI_MTL_TXN_CST_HDR_T does not reference any database object

JA.JAI_MTL_TXN_CST_HDR_T is referenced by following:

APPS

SYNONYM - JAI_MTL_TXN_CST_HDR_T

[top of page]

Table: JAI_OM_LC_AMENDMENTS

Primary Key: JAI_OM_LC_AMENDMENTS_PK

1. LC_AMMENDMENT_ID

Foreign Keys from this table:

[top of page]

JA.JAI_OM_LC_AMENDMENTS does not reference any database object

JA.JAI_OM_LC_AMENDMENTS is referenced by following:

APPS

SYNONYM - JAI_OM_LC_AMENDMENTS

[top of page]

Table: JAI_OM_LC_HDRS

Primary Key: JAI_OM_LC_HDRS_PK

1. LC_NUMBER

Foreign Keys from this table:

[top of page]

JA.JAI_OM_LC_HDRS does not reference any database object

JA.JAI_OM_LC_HDRS is referenced by following:

APPS

SYNONYM - JAI_OM_LC_HDRS

[top of page]

Table: JAI_OM_LC_MATCHINGS

Primary Key: JAI_OM_LC_MATCHINGS_PK

1. MATCHING_ID

Foreign Keys from this table:

[top of page]

JA.JAI_OM_LC_MATCHINGS does not reference any database object

JA.JAI_OM_LC_MATCHINGS is referenced by following:

APPS

TRIGGER - JAI_JOM_LM_ARIUD_T1

SYNONYM - JAI_OM_LC_MATCHINGS

[top of page]

Table: JAI_OM_OE_BOND_REG_DTLS

Primary Key: JAI_OM_OE_BOND_REG_DTLS_PK

1. REGISTER_ID
2. ORDER_TYPE_ID
3. ORDER_FLAG

Foreign Keys from this table:

[top of page]

JA.JAI_OM_OE_BOND_REG_DTLS does not reference any database object

JA.JAI_OM_OE_BOND_REG_DTLS is referenced by following:

APPS

SYNONYM - JAI_OM_OE_BOND_REG_DTLS

[top of page]

Table: JAI_OM_OE_BOND_REG_HDRS

Primary Key: JAI_OM_OE_BOND_REG_HDRS_PK

1. REGISTER_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

JA.JAI_OM_OE_BOND_REG_HDRS does not reference any database object

JA.JAI_OM_OE_BOND_REG_HDRS is referenced by following:

APPS

SYNONYM - JAI_OM_OE_BOND_REG_HDRS

[top of page]

Table: JAI_OM_OE_BOND_TRXS

Primary Key: JAI_OM_OE_BOND_TRXS_PK

1. TRANSACTION_ID

Foreign Keys from this table:

[top of page]

JA.JAI_OM_OE_BOND_TRXS does not reference any database object

JA.JAI_OM_OE_BOND_TRXS is referenced by following:

APPS

SYNONYM - JAI_OM_OE_BOND_TRXS

[top of page]

Table: JAI_OM_OE_GEN_TAXINV_T

Foreign Keys from this table:

[top of page]

JA.JAI_OM_OE_GEN_TAXINV_T does not reference any database object

JA.JAI_OM_OE_GEN_TAXINV_T is referenced by following:

APPS

SYNONYM - JAI_OM_OE_GEN_TAXINV_T

[top of page]

Table: JAI_OM_OE_RMA_LINES

Primary Key: JAI_OM_OE_RMA_LINES_PK

1. RMA_LINE_ID

Foreign Keys from this table: