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

TABLE - JL.JL_AR_AP_AWT_CERTIF_ALL
TABLE - JL.JL_AR_AP_MTBT_THRESHOLDS
TABLE - JL.JL_AR_AP_PROVINCES
TABLE - JL.JL_AR_AP_SUP_AWT_CR_LTS
TABLE - JL.JL_AR_AP_TRX_DGI_CODES
TABLE - JL.JL_AR_AR_DOC_LETTER_ALL
TABLE - JL.JL_AR_FA_EXHIBIT_GROUPS
TABLE - JL.JL_AR_FA_EXHIBIT_REPORT
TABLE - JL.JL_AR_TURN_UPL_ALL
TABLE - JL.JL_AR_TURN_UPL_T
TABLE - JL.JL_BR_AP_COLLECTION_DOCS_ALL
TABLE - JL.JL_BR_AP_CONSOLID_INVOICES_ALL
TABLE - JL.JL_BR_AP_INT_COLLECTION_TMP
TABLE - JL.JL_BR_AP_INT_COLLECT_ALL
TABLE - JL.JL_BR_AP_INT_COLLECT_EXT_ALL
TABLE - JL.JL_BR_AP_OPERATIONS
TABLE - JL.JL_BR_AP_TAX_CALENDAR_HEADERS
TABLE - JL.JL_BR_AP_TAX_CALENDAR_LINES
TABLE - JL.JL_BR_AR_BANK_INSTRUCTIONS
TABLE - JL.JL_BR_AR_BANK_OCCURRENCES
TABLE - JL.JL_BR_AR_BANK_RETURNS_ALL
TABLE - JL.JL_BR_AR_BORDEROS_ALL
TABLE - JL.JL_BR_AR_COLLECTION_DOCS_ALL
TABLE - JL.JL_BR_AR_COMP_INV_ALL
TABLE - JL.JL_BR_AR_CUST_INT_ERR
TABLE - JL.JL_BR_AR_DISTRIBUTNS_ALL
TABLE - JL.JL_BR_AR_MC_OCC_DOCS
TABLE - JL.JL_BR_AR_OCCURRENCE_DOCS_ALL
TABLE - JL.JL_BR_AR_PAY_SCHED_AUX
TABLE - JL.JL_BR_AR_POSTING_TMP
TABLE - JL.JL_BR_AR_REC_MET_ACCTS_EXT_ALL
TABLE - JL.JL_BR_AR_REMIT_BORDEROS_ALL
TABLE - JL.JL_BR_AR_RET_INTERFACE_ALL
TABLE - JL.JL_BR_AR_RET_INTERFACE_EXT_ALL
TABLE - JL.JL_BR_AR_RET_INTERFACE_TMP
TABLE - JL.JL_BR_AR_SELECT_ACCOUNTS_ALL
TABLE - JL.JL_BR_AR_SELECT_CONTROLS_ALL
TABLE - JL.JL_BR_AR_TX_CATEG_ALL
TABLE - JL.JL_BR_AR_TX_EXC_FSC_ALL
TABLE - JL.JL_BR_AR_TX_EXC_ITM_ALL
TABLE - JL.JL_BR_AR_TX_FSC_CLS_ALL
TABLE - JL.JL_BR_AR_TX_GROUP_ALL
TABLE - JL.JL_BR_AR_TX_LOCN_ALL
TABLE - JL.JL_BR_AR_TX_RULES_ALL
TABLE - JL.JL_BR_BALANCES_ALL
TABLE - JL.JL_BR_CINFOS_BOOKS
TABLE - JL.JL_BR_COMPANY_INFOS
TABLE - JL.JL_BR_CUSTOMER_TRX_EXTS
TABLE - JL.JL_BR_CUST_TRX_LINES_EXTS
TABLE - JL.JL_BR_EILOG
TABLE - JL.JL_BR_GL_LEGAL_REP
TABLE - JL.JL_BR_INTERFACE_LINES_EXTS
TABLE - JL.JL_BR_INV_API_TRX_LINES_T
TABLE - JL.JL_BR_JOURNALS_ALL
TABLE - JL.JL_BR_LOCAL_HOLIDAY_DATES
TABLE - JL.JL_BR_LOCAL_HOLIDAY_SETS
TABLE - JL.JL_BR_SPED_EXTR_DATA_H
TABLE - JL.JL_BR_SPED_EXTR_DATA_T
TABLE - JL.JL_BR_SPED_EXTR_MSGS
TABLE - JL.JL_BR_SPED_EXTR_PARAM
TABLE - JL.JL_BR_SPED_PARTIC_CODES
TABLE - JL.JL_BR_SPED_PARTIC_REL
TABLE - JL.JL_BR_TAX_LMSG_ALL
TABLE - JL.JL_CANCEL_GT
TABLE - JL.JL_CL_AP_AWT_CERT
TABLE - JL.JL_CL_GL_ACCT_HIER_TMP
TABLE - JL.JL_CO_FA_ADJUSTMENTS
TABLE - JL.JL_CO_FA_APPRAISALS
TABLE - JL.JL_CO_FA_APPRAISAL_BOOKS
TABLE - JL.JL_CO_FA_ASSET_APPRS
TABLE - JL.JL_CO_FA_PURGE
TABLE - JL.JL_CO_GL_BALANCES
TABLE - JL.JL_CO_GL_CONC_CTRL
TABLE - JL.JL_CO_GL_CONC_ERRS
TABLE - JL.JL_CO_GL_MG_CONFIGS
TABLE - JL.JL_CO_GL_MG_HEADERS
TABLE - JL.JL_CO_GL_MG_LINES
TABLE - JL.JL_CO_GL_MG_LITERALS
TABLE - JL.JL_CO_GL_MG_RANGES
TABLE - JL.JL_CO_GL_NITS
TABLE - JL.JL_CO_GL_NIT_ACCTS
TABLE - JL.JL_CO_GL_TRX
TABLE - JL.JL_MX_FA_ISR_IMPAC
TABLE - JL.JL_REMIT3_GT
TABLE - JL.JL_REMIT_GT
TABLE - JL.JL_ZZ_AP_AWT_TYPES
TABLE - JL.JL_ZZ_AP_COMP_AWT_TYPES
TABLE - JL.JL_ZZ_AP_INV_DIS_WH_ALL
TABLE - JL.JL_ZZ_AP_INV_DIS_WH_ALL_T
TABLE - JL.JL_ZZ_AP_SUPP_AWT_TYPES
TABLE - JL.JL_ZZ_AP_SUP_AWT_CD_ALL
TABLE - JL.JL_ZZ_AR_TX_ATT_CLS_ALL
TABLE - JL.JL_ZZ_AR_TX_ATT_VAL_ALL
TABLE - JL.JL_ZZ_AR_TX_CATEG_ALL
TABLE - JL.JL_ZZ_AR_TX_CAT_ATT_ALL
TABLE - JL.JL_ZZ_AR_TX_CAT_DTL_ALL
TABLE - JL.JL_ZZ_AR_TX_CUS_CLS_ALL
TABLE - JL.JL_ZZ_AR_TX_EXC_CUS_ALL
TABLE - JL.JL_ZZ_AR_TX_EXC_FSC_ALL
TABLE - JL.JL_ZZ_AR_TX_EXC_ITM_ALL
TABLE - JL.JL_ZZ_AR_TX_FSC_CLS_ALL
TABLE - JL.JL_ZZ_AR_TX_GROUPS_ALL
TABLE - JL.JL_ZZ_AR_TX_LGL_MSG_ALL
TABLE - JL.JL_ZZ_AR_TX_LOCN_ALL
TABLE - JL.JL_ZZ_AR_TX_NAT_RAT_ALL
TABLE - JL.JL_ZZ_AR_TX_RULES_ALL
TABLE - JL.JL_ZZ_AR_TX_SCHEDULES_ALL
TABLE - JL.JL_ZZ_FA_RETIREMNT_ADJS
TABLE - JL.JL_ZZ_FA_RETIREMNT_JES
TABLE - JL.JL_ZZ_GL_AXI
TABLE - JL.JL_ZZ_GL_AXI_ACCOUNTS
TABLE - JL.JL_ZZ_GL_AXI_MODELS
TABLE - JL.JL_ZZ_GL_AXI_MODEL_RANGES
TABLE - JL.JL_ZZ_GL_AXI_TMP
TABLE - JL.JL_ZZ_INFO_T
VIEW - APPS.AS_TAX_LINES_SUMMARY_VBR
VIEW - APPS.JL_AR_AR_CUST_TRX_TYPES_V
VIEW - APPS.JL_AR_AR_DOC_LETTER_V
VIEW - APPS.JL_BR_AP_COLLECTION_DOCS_V
VIEW - APPS.JL_BR_AP_CONSOLID_INVOICES_V
VIEW - APPS.JL_BR_AP_INT_COLLECT_EXT_V
VIEW - APPS.JL_BR_AP_INVOICES_SHIP_V
VIEW - APPS.JL_BR_AP_SICI_INVOICES_TN_V
VIEW - APPS.JL_BR_AP_SICI_INVOICES_V
VIEW - APPS.JL_BR_AR_BANK_RETURNS_V
VIEW - APPS.JL_BR_AR_BORDEROS_SAB_V
VIEW - APPS.JL_BR_AR_BORDEROS_V
VIEW - APPS.JL_BR_AR_COLLECTION_DOCS_IOB_V
VIEW - APPS.JL_BR_AR_COLL_DOCS_SAB_V
VIEW - APPS.JL_BR_AR_COLL_DOC_DISTS_L_V
VIEW - APPS.JL_BR_AR_COLL_OCC_DOCS_H_V
VIEW - APPS.JL_BR_AR_OCCURRENCE_DOCS_V
VIEW - APPS.JL_BR_AR_OCC_DOCS_ALL_MRC_V
VIEW - APPS.JL_BR_AR_OCC_DOCS_MRC_V
VIEW - APPS.JL_BR_AR_PAYMENT_SCH_IOB_V
VIEW - APPS.JL_BR_AR_RCT_MTHD_1_V
VIEW - APPS.JL_BR_AR_RCT_MTHD_2_V
VIEW - APPS.JL_BR_AR_REC_MET_ACCTS_EXT_R_V
VIEW - APPS.JL_BR_AR_REC_MET_ACCTS_EXT_V
VIEW - APPS.JL_BR_AR_RET_INTERFACE_EXT_V
VIEW - APPS.JL_BR_AR_RET_INTER_V
VIEW - APPS.JL_BR_AR_SELECT_ACCOUNTS_V
VIEW - APPS.JL_BR_AR_SELECT_CONTROLS_V
VIEW - APPS.JL_CO_FA_AEL_GL_V
VIEW - APPS.JL_CO_FA_AEL_SL_V
VIEW - APPS.JL_CO_FA_APPRAISAL_BOOKS_V
VIEW - APPS.JL_CO_FA_ASSET_APPRS_V
VIEW - APPS.JL_CO_GL_ACCOUNTS_V
VIEW - APPS.JL_CO_GL_BALANCES_V
VIEW - APPS.JL_CO_GL_NIT_ACCTS_V
VIEW - APPS.JL_ZZ_AR_PO_TX_FSC_CLS_V
VIEW - APPS.JL_ZZ_AR_PO_TX_TXN_NAT_V
VIEW - APPS.JL_ZZ_AR_TX_ATTCLS_VAL_V
VIEW - APPS.JL_ZZ_AR_TX_ATT_CLS_LOOKUP_V
VIEW - APPS.JL_ZZ_AR_TX_ATT_CLS_V
VIEW - APPS.JL_ZZ_AR_TX_ATT_VAL_V
VIEW - APPS.JL_ZZ_AR_TX_CATEGRY
VIEW - APPS.JL_ZZ_AR_TX_CATEGRY_V
VIEW - APPS.JL_ZZ_AR_TX_CAT_ATT_TN_V
VIEW - APPS.JL_ZZ_AR_TX_CAT_ATT_V
VIEW - APPS.JL_ZZ_AR_TX_CAT_DTL_V
VIEW - APPS.JL_ZZ_AR_TX_CUS_CLS_V
VIEW - APPS.JL_ZZ_AR_TX_EXC_CUS_V
VIEW - APPS.JL_ZZ_AR_TX_EXC_FSC_V
VIEW - APPS.JL_ZZ_AR_TX_EXC_ITM_V
VIEW - APPS.JL_ZZ_AR_TX_FSC_CLS_V
VIEW - APPS.JL_ZZ_AR_TX_FSC_LOOKUP_V
VIEW - APPS.JL_ZZ_AR_TX_GROUPS_V
VIEW - APPS.JL_ZZ_AR_TX_LGL_MSG_V
VIEW - APPS.JL_ZZ_AR_TX_LGM_V
VIEW - APPS.JL_ZZ_AR_TX_LOCN_V
VIEW - APPS.JL_ZZ_AR_TX_NAT_RAT_V
VIEW - APPS.JL_ZZ_AR_TX_RULES_V
VIEW - APPS.JL_ZZ_AR_TX_SCHEDULES_V
VIEW - APPS.JL_ZZ_FA_ADJ_SUMMARY_V
VIEW - APPS.JL_ZZ_FA_BOOKS_PERIODS_V

Table: JL_AR_AP_AWT_CERTIF_ALL

Description: Argentine withholding certificate information
Primary Key: JL_AR_AP_AWT_CERTIF_ALL_PK
  1. CERTIFICATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_AR_AP_AWT_CERTIF_ALL.PAYMENT_INSTRUCTION_ID IBY_PAY_INSTRUCTIONS_ALL

[top of page]

JL.JL_AR_AP_AWT_CERTIF_ALL does not reference any database object

JL.JL_AR_AP_AWT_CERTIF_ALL is referenced by following:

JL
VIEW - JL_AR_AP_AWT_CERTIF_ALL#

[top of page]

Table: JL_AR_AP_MTBT_THRESHOLDS

Description: JL_AR_AP_MTBT_THRESHOLDS is used to capture Threshold values of simplified regime contributor type for Monotributa Suppliers

[top of page]

JL.JL_AR_AP_MTBT_THRESHOLDS does not reference any database object

JL.JL_AR_AP_MTBT_THRESHOLDS is referenced by following:

JL
VIEW - JL_AR_AP_MTBT_THRESHOLDS#

[top of page]

Table: JL_AR_AP_PROVINCES

Description: Argentine province records
Primary Key: JL_AR_AP_PROVINCES_PK
  1. PROVINCE_CODE

[top of page]

JL.JL_AR_AP_PROVINCES does not reference any database object

JL.JL_AR_AP_PROVINCES is referenced by following:

JL
VIEW - JL_AR_AP_PROVINCES#

[top of page]

Table: JL_AR_AP_SUP_AWT_CR_LTS

Description: Argentine supplier withholding credit letter information
Primary Key: JL_AR_AP_SUP_AWT_CR_LTS_PK
  1. SEQ_NUM

[top of page]

JL.JL_AR_AP_SUP_AWT_CR_LTS does not reference any database object

JL.JL_AR_AP_SUP_AWT_CR_LTS is referenced by following:

JL
VIEW - JL_AR_AP_SUP_AWT_CR_LTS#

[top of page]

Table: JL_AR_AP_TRX_DGI_CODES

Description: Argentine DGI transaction type codes
Primary Key: JL_AR_AP_TRX_DGI_CODES_PK
  1. TRX_CATEGORY_LETTER_ID

[top of page]

JL.JL_AR_AP_TRX_DGI_CODES does not reference any database object

JL.JL_AR_AP_TRX_DGI_CODES is referenced by following:

JL
VIEW - JL_AR_AP_TRX_DGI_CODES#

[top of page]

Table: JL_AR_AR_DOC_LETTER_ALL

Description: Argentine Document Letter Assignments information
Primary Key: JL_AR_AR_DOC_LETTER_ALL_PK
  1. TAX_CATEGORY_ID
  2. ORG_TAX_ATTRIBUTE_NAME
  3. ORG_TAX_ATTRIBUTE_VALUE
  4. CON_TAX_ATTRIBUTE_NAME
  5. CON_TAX_ATTRIBUTE_VALUE
  6. END_DATE_ACTIVE

[top of page]

JL.JL_AR_AR_DOC_LETTER_ALL does not reference any database object

JL.JL_AR_AR_DOC_LETTER_ALL is referenced by following:

JL
VIEW - JL_AR_AR_DOC_LETTER_ALL#

[top of page]

Table: JL_AR_FA_EXHIBIT_GROUPS

Description: Information about exhibit of fixed assets groups
Primary Key: JL_AR_FA_EXHIBIT_GROUPS_PK
  1. EXHIBIT_GROUP_ID

[top of page]

JL.JL_AR_FA_EXHIBIT_GROUPS does not reference any database object

JL.JL_AR_FA_EXHIBIT_GROUPS is referenced by following:

JL
VIEW - JL_AR_FA_EXHIBIT_GROUPS#

[top of page]

Table: JL_AR_FA_EXHIBIT_REPORT

Description: Release 11i: Data extraction table for Argentine Fixed Assets Exhibit report

[top of page]

JL.JL_AR_FA_EXHIBIT_REPORT does not reference any database object

JL.JL_AR_FA_EXHIBIT_REPORT is referenced by following:

JL
VIEW - JL_AR_FA_EXHIBIT_REPORT#

[top of page]

Table: JL_AR_TURN_UPL_ALL

Description: Stores data for Argentine Applicable Tax Rates
Primary Key: JL_AR_TURN_UPL_ALL_PK
  1. START_DATE
  2. END_DATE
  3. TAXPAYER_ID

[top of page]

JL.JL_AR_TURN_UPL_ALL does not reference any database object

JL.JL_AR_TURN_UPL_ALL is referenced by following:

JL
VIEW - JL_AR_TURN_UPL_ALL#

[top of page]

Table: JL_AR_TURN_UPL_T

Description: Interface table for Argentine Applicable Tax Rates
Primary Key: JL_AR_TURN_UPL_T_PK
  1. START_DATE
  2. END_DATE
  3. TAXPAYER_ID

[top of page]

JL.JL_AR_TURN_UPL_T does not reference any database object

JL.JL_AR_TURN_UPL_T is referenced by following:

JL
VIEW - JL_AR_TURN_UPL_T#

[top of page]

Table: JL_BR_AP_COLLECTION_DOCS_ALL

Description: Detailed Brazilian bank collection document records
Primary Key: JL_BR_AP_COLLEC_DOC_PK
  1. BANK_COLLECTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AP_COLLECTION_DOCS_ALL.INVOICE_ID
JL_BR_AP_COLLECTION_DOCS_ALL.PAYMENT_NUM 		AP_PAYMENT_SCHEDULES_ALL
JL_BR_AP_COLLECTION_DOCS_ALL.CURRENCY_CODE FND_CURRENCIES
JL_BR_AP_COLLECTION_DOCS_ALL.VENDOR_SITE_ID PO_VENDOR_SITES_ALL
JL_BR_AP_COLLECTION_DOCS_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
JL_BR_AP_COLLECTION_DOCS_ALL.VENDOR_ID PO_VENDORS
JL_BR_AP_COLLECTION_DOCS_ALL.BANK_BRANCH_ID AP_BANK_BRANCHES

[top of page]

JL.JL_BR_AP_COLLECTION_DOCS_ALL does not reference any database object

JL.JL_BR_AP_COLLECTION_DOCS_ALL is referenced by following:

JL
VIEW - JL_BR_AP_COLLECTION_DOCS_ALL#

[top of page]

Table: JL_BR_AP_CONSOLID_INVOICES_ALL

Description: Detailed Brazilian consolidated invoice records
Primary Key: JL_BR_AP_CONS_INVOICES_PK
  1. CONSOLIDATED_INVOICE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AP_CONSOLID_INVOICES_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
JL_BR_AP_CONSOLID_INVOICES_ALL.VENDOR_SITE_ID PO_VENDOR_SITES_ALL
JL_BR_AP_CONSOLID_INVOICES_ALL.VENDOR_ID PO_VENDORS
JL_BR_AP_CONSOLID_INVOICES_ALL.INVOICE_CURRENCY_CODE FND_CURRENCIES

[top of page]

JL.JL_BR_AP_CONSOLID_INVOICES_ALL does not reference any database object

JL.JL_BR_AP_CONSOLID_INVOICES_ALL is referenced by following:

JL
VIEW - JL_BR_AP_CONSOLID_INVOICES_AL#

[top of page]

Table: JL_BR_AP_INT_COLLECTION_TMP

Description: Temporary information of bank collection documents interface

[top of page]

JL.JL_BR_AP_INT_COLLECTION_TMP does not reference any database object

JL.JL_BR_AP_INT_COLLECTION_TMP is referenced by following:

JL
VIEW - JL_BR_AP_INT_COLLECTION_TMP#

[top of page]

Table: JL_BR_AP_INT_COLLECT_ALL

Description: Bank collection document loaded from the file of supplier's bank
Primary Key: JL_BR_AP_INT_COLLECT_PK
  1. FILE_CONTROL
  2. ENTRY_SEQUENTIAL_NUMBER

[top of page]

JL.JL_BR_AP_INT_COLLECT_ALL does not reference any database object

JL.JL_BR_AP_INT_COLLECT_ALL is referenced by following:

JL
VIEW - JL_BR_AP_INT_COLLECT_ALL#

[top of page]

Table: JL_BR_AP_INT_COLLECT_EXT_ALL

Description: Invalid records from the JL_BR_AP_INT_COLLECT table
Primary Key: JL_BR_AP_COLLECT_EXT_PK
  1. FILE_CONTROL
  2. ENTRY_SEQUENTIAL_NUMBER

[top of page]

JL.JL_BR_AP_INT_COLLECT_EXT_ALL does not reference any database object

JL.JL_BR_AP_INT_COLLECT_EXT_ALL is referenced by following:

JL
VIEW - JL_BR_AP_INT_COLLECT_EXT_ALL#

[top of page]

Table: JL_BR_AP_OPERATIONS

Description: Brazilian operations fiscal codes
Primary Key: JL_BR_AP_OPERATIONS_PK
  1. CFO_CODE

[top of page]

JL.JL_BR_AP_OPERATIONS does not reference any database object

JL.JL_BR_AP_OPERATIONS is referenced by following:

JL
VIEW - JL_BR_AP_OPERATIONS#

[top of page]

Table: JL_BR_AP_TAX_CALENDAR_HEADERS

Description: Brazilian withholding tax calendar header information
Primary Key: JL_BR_AP_TAX_CALENDAR_HEAD_PK
  1. TAX_CALENDAR_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_BR_AP_TAX_CALENDAR_LINES.TAX_CALENDAR_NAME JL_BR_AP_TAX_CALENDAR_HEADERS

[top of page]

JL.JL_BR_AP_TAX_CALENDAR_HEADERS does not reference any database object

JL.JL_BR_AP_TAX_CALENDAR_HEADERS is referenced by following:

JL
VIEW - JL_BR_AP_TAX_CALENDAR_HEADERS#

[top of page]

Table: JL_BR_AP_TAX_CALENDAR_LINES

Description: Brazilian withholding tax calendar line information
Primary Key: JL_BR_AP_TAX_CALENDAR_LINE_PK
  1. TAX_CALENDAR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AP_TAX_CALENDAR_LINES.TAX_CALENDAR_NAME JL_BR_AP_TAX_CALENDAR_HEADERS

[top of page]

JL.JL_BR_AP_TAX_CALENDAR_LINES does not reference any database object

JL.JL_BR_AP_TAX_CALENDAR_LINES is referenced by following:

JL
VIEW - JL_BR_AP_TAX_CALENDAR_LINES#

[top of page]

Table: JL_BR_AR_BANK_INSTRUCTIONS

Description: Bank Instruction Codes
Primary Key: JL_BR_AR_BANK_INSTRUCTIONS_PK
  1. BANK_PARTY_ID
  2. BANK_INSTRUCTION_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_BANK_INSTRUCTIONS.BANK_PARTY_ID HZ_PARTIES

[top of page]

JL.JL_BR_AR_BANK_INSTRUCTIONS does not reference any database object

JL.JL_BR_AR_BANK_INSTRUCTIONS is referenced by following:

JL
VIEW - JL_BR_AR_BANK_INSTRUCTIONS#

[top of page]

Table: JL_BR_AR_BANK_OCCURRENCES

Description: Bank Occurrence codes
Primary Key: JL_BR_AR_BANK_OCCURRENCES_PK
  1. BANK_PARTY_ID
  2. BANK_OCCURRENCE_CODE
  3. BANK_OCCURRENCE_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_BANK_OCCURRENCES.BANK_PARTY_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_OCCURRENCE_CODE
JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_NUMBER
JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_OCCURRENCE_TYPE 		JL_BR_AR_BANK_OCCURRENCES

[top of page]

JL.JL_BR_AR_BANK_OCCURRENCES does not reference any database object

JL.JL_BR_AR_BANK_OCCURRENCES is referenced by following:

JL
VIEW - JL_BR_AR_BANK_OCCURRENCES#

[top of page]

Table: JL_BR_AR_BANK_RETURNS_ALL

Description: Validated Bank Returns
Primary Key: JL_BR_AR_BANK_RETURNS_ALL_PK
  1. RETURN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_BANK_RETURNS_ALL.DOCUMENT_ID JL_BR_AR_COLLECTION_DOCS_ALL
JL_BR_AR_BANK_RETURNS_ALL.BATCH_SOURCE_ID AR_BATCH_SOURCES_ALL
JL_BR_AR_BANK_RETURNS_ALL.CUSTOMER_ID HZ_CUST_ACCOUNTS
JL_BR_AR_BANK_RETURNS_ALL.BANK_PARTY_ID HZ_PARTIES
JL_BR_AR_BANK_RETURNS_ALL.COLLECTOR_BANK_PARTY_ID HZ_PARTIES
JL_BR_AR_BANK_RETURNS_ALL.COLLECTOR_BRANCH_PARTY_ID HZ_PARTIES

[top of page]

JL.JL_BR_AR_BANK_RETURNS_ALL does not reference any database object

JL.JL_BR_AR_BANK_RETURNS_ALL is referenced by following:

JL
VIEW - JL_BR_AR_BANK_RETURNS_ALL#

[top of page]

Table: JL_BR_AR_BORDEROS_ALL

Description: Bank Transfer Batches
Primary Key: JL_BR_AR_BORDEROS_ALL_PK
  1. BORDERO_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_BORDEROS_ALL.SELECT_ACCOUNT_ID JL_BR_AR_SELECT_ACCOUNTS_ALL
JL_BR_AR_BORDEROS_ALL.BANK_ACCOUNT_ID AP_BANK_ACCOUNTS_ALL
JL_BR_AR_BORDEROS_ALL.SELECTION_CONTROL_ID JL_BR_AR_SELECT_CONTROLS_ALL
JL_BR_AR_BORDEROS_ALL.BANK_ACCT_USE_ID CE_BANK_ACCT_USES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_BR_AR_COLLECTION_DOCS_ALL.BORDERO_ID JL_BR_AR_BORDEROS_ALL
JL_BR_AR_OCCURRENCE_DOCS_ALL.BORDERO_ID JL_BR_AR_BORDEROS_ALL
JL_BR_AR_REMIT_BORDEROS_ALL.BORDERO_ID JL_BR_AR_BORDEROS_ALL

[top of page]

JL.JL_BR_AR_BORDEROS_ALL does not reference any database object

JL.JL_BR_AR_BORDEROS_ALL is referenced by following:

JL
VIEW - JL_BR_AR_BORDEROS_ALL#

[top of page]

Table: JL_BR_AR_COLLECTION_DOCS_ALL

Description: Collection Documents
Primary Key: JL_BR_AR_COLLEC_DOCS_ALL_PK
  1. DOCUMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_COLLECTION_DOCS_ALL.UNAPPLIED_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.BORDERO_ID JL_BR_AR_BORDEROS_ALL
JL_BR_AR_COLLECTION_DOCS_ALL.UNEARNED_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.UNIDENTIFIED_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.BANK_CHARGES_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.COLL_ENDORSEMENTS_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.BILLS_COLLECTION_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.OTHER_CREDITS_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.FACTORING_DOCS_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.CALCULATED_INTEREST_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.INTEREST_WRITEOFF_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.FACTORING_INTEREST_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.BANK_ACCOUNT_ID
JL_BR_AR_COLLECTION_DOCS_ALL.RECEIPT_METHOD_ID 		AR_RECEIPT_METHOD_ACCOUNTS_ALL
JL_BR_AR_COLLECTION_DOCS_ALL.ABATEMENT_WRITEOFF_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.ABATEMENT_REVENUE_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.INTEREST_REVENUE_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.CALCULATED_INTEREST_RECTRX_ID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.INTEREST_WRITEOFF_RECTRX_ID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.INTEREST_REVENUE_RECTRX_ID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.ABATEMENT_WRITEOFF_RECTRX_ID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.ABATE_REVENUE_RECTRX_ID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.BANK_ACCT_USE_ID CE_BANK_ACCT_USES_ALL
JL_BR_AR_COLLECTION_DOCS_ALL.COLLECTOR_BANK_PARTY_ID HZ_PARTIES
JL_BR_AR_COLLECTION_DOCS_ALL.PAYMENT_SCHEDULE_ID AR_PAYMENT_SCHEDULES_ALL
JL_BR_AR_COLLECTION_DOCS_ALL.COLLECTOR_BRANCH_PARTY_ID HZ_PARTIES
JL_BR_AR_COLLECTION_DOCS_ALL.BATCH_SOURCE_ID AR_BATCH_SOURCES_ALL
JL_BR_AR_COLLECTION_DOCS_ALL.CUSTOMER_TRX_ID RA_CUSTOMER_TRX_ALL
JL_BR_AR_COLLECTION_DOCS_ALL.CASH_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.EARNED_CCID GL_CODE_COMBINATIONS
JL_BR_AR_COLLECTION_DOCS_ALL.ON_ACCOUNT_CCID GL_CODE_COMBINATIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_BR_AR_BANK_RETURNS_ALL.DOCUMENT_ID JL_BR_AR_COLLECTION_DOCS_ALL
JL_BR_AR_OCCURRENCE_DOCS_ALL.DOCUMENT_ID JL_BR_AR_COLLECTION_DOCS_ALL

[top of page]

JL.JL_BR_AR_COLLECTION_DOCS_ALL does not reference any database object

JL.JL_BR_AR_COLLECTION_DOCS_ALL is referenced by following:

JL
VIEW - JL_BR_AR_COLLECTION_DOCS_ALL#

[top of page]

Table: JL_BR_AR_COMP_INV_ALL

Description: Complementary Invoices
Primary Key: JL_BR_AR_COMP_INV_ALL_PK
  1. COMP_INVOICE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_COMP_INV_ALL.CUSTOMER_TRX_LINE_ID RA_CUSTOMER_TRX_LINES_ALL
JL_BR_AR_COMP_INV_ALL.CUSTOMER_TRX_ID RA_CUSTOMER_TRX_ALL

[top of page]

JL.JL_BR_AR_COMP_INV_ALL does not reference any database object

JL.JL_BR_AR_COMP_INV_ALL is referenced by following:

JL
VIEW - JL_BR_AR_COMP_INV_ALL#

[top of page]

Table: JL_BR_AR_CUST_INT_ERR

Description: Customer interface import errors

[top of page]

JL.JL_BR_AR_CUST_INT_ERR does not reference any database object

JL.JL_BR_AR_CUST_INT_ERR is referenced by following:

JL
VIEW - JL_BR_AR_CUST_INT_ERR#

[top of page]

Table: JL_BR_AR_DISTRIBUTNS_ALL

Description: A new table required for SLA uptake
Primary Key: JL_BR_AR_DISTRIBUTNS_PK
  1. DISTRIBUTION_ID

[top of page]

JL.JL_BR_AR_DISTRIBUTNS_ALL does not reference any database object

JL.JL_BR_AR_DISTRIBUTNS_ALL is referenced by following:

JL
VIEW - JL_BR_AR_DISTRIBUTNS_ALL#

[top of page]

Table: JL_BR_AR_MC_OCC_DOCS

Description: Multiple reporting currency sub-table for JL_BR_AR_OCCURRENCE_DOCS_ALL
Primary Key: JL_BR_AR_MC_OCC_DOCS_PK
  1. OCCURRENCE_ID
  2. SET_OF_BOOKS_ID

[top of page]

JL.JL_BR_AR_MC_OCC_DOCS does not reference any database object

JL.JL_BR_AR_MC_OCC_DOCS is referenced by following:

JL
VIEW - JL_BR_AR_MC_OCC_DOCS#

[top of page]

Table: JL_BR_AR_OCCURRENCE_DOCS_ALL

Description: Occurrences for collection documents
Primary Key: JL_BR_AR_OCCUR_DOCS_ALL_PK
  1. OCCURRENCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_OCCURRENCE_DOCS_ALL.DOCUMENT_ID JL_BR_AR_COLLECTION_DOCS_ALL
JL_BR_AR_OCCURRENCE_DOCS_ALL.DISCOUNT_CRED_ACCT_CCID GL_CODE_COMBINATIONS
JL_BR_AR_OCCURRENCE_DOCS_ALL.FACTORING_DEBIT_CCID GL_CODE_COMBINATIONS
JL_BR_AR_OCCURRENCE_DOCS_ALL.FACTORING_CREDIT_CCID GL_CODE_COMBINATIONS
JL_BR_AR_OCCURRENCE_DOCS_ALL.FACTOR_INTEREST_CREDIT_CCID GL_CODE_COMBINATIONS
JL_BR_AR_OCCURRENCE_DOCS_ALL.FACTOR_INTEREST_DEBIT_CCID GL_CODE_COMBINATIONS
JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_PARTY_ID HZ_PARTIES
JL_BR_AR_OCCURRENCE_DOCS_ALL.BORDERO_ID JL_BR_AR_BORDEROS_ALL
JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_OCCURRENCE_CODE
JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_NUMBER
JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_OCCURRENCE_TYPE 		JL_BR_AR_BANK_OCCURRENCES
JL_BR_AR_OCCURRENCE_DOCS_ALL.CUSTOMER_ID HZ_CUST_ACCOUNTS
JL_BR_AR_OCCURRENCE_DOCS_ALL.SITE_USE_ID HZ_CUST_SITE_USES_ALL
JL_BR_AR_OCCURRENCE_DOCS_ALL.ENDORSEMENT_CREDIT_CCID GL_CODE_COMBINATIONS
JL_BR_AR_OCCURRENCE_DOCS_ALL.ENDORSEMENT_DEBIT_CCID GL_CODE_COMBINATIONS
JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_CHARGES_CREDIT_CCID GL_CODE_COMBINATIONS
JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_CHARGES_DEBIT_CCID GL_CODE_COMBINATIONS

[top of page]

JL.JL_BR_AR_OCCURRENCE_DOCS_ALL does not reference any database object

JL.JL_BR_AR_OCCURRENCE_DOCS_ALL is referenced by following:

JL
VIEW - JL_BR_AR_OCCURRENCE_DOCS_ALL#

[top of page]

Table: JL_BR_AR_PAY_SCHED_AUX

Description: Temporary table for Bank Transfer batches creation
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_PAY_SCHED_AUX.PAYMENT_SCHEDULE_ID AR_PAYMENT_SCHEDULES_ALL
JL_BR_AR_PAY_SCHED_AUX.BRANCH_PARTY_ID HZ_PARTIES
JL_BR_AR_PAY_SCHED_AUX.BANK_ACCT_USE_ID CE_BANK_ACCT_USES_ALL
JL_BR_AR_PAY_SCHED_AUX.BANK_ACCOUNT_ID AP_BANK_ACCOUNTS_ALL
JL_BR_AR_PAY_SCHED_AUX.BATCH_SOURCE_ID AR_BATCH_SOURCES_ALL
JL_BR_AR_PAY_SCHED_AUX.BANK_ACCOUNT_ID
JL_BR_AR_PAY_SCHED_AUX.RECEIPT_METHOD_ID 		JL_BR_AR_REC_MET_ACCTS_EXT_ALL
JL_BR_AR_PAY_SCHED_AUX.CUSTOMER_TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL
JL_BR_AR_PAY_SCHED_AUX.CUSTOMER_TRX_ID RA_CUSTOMER_TRX_ALL
JL_BR_AR_PAY_SCHED_AUX.CUSTOMER_SITE_USE_ID HZ_CUST_SITE_USES_ALL
JL_BR_AR_PAY_SCHED_AUX.SELECT_ACCOUNT_ID JL_BR_AR_SELECT_ACCOUNTS_ALL
JL_BR_AR_PAY_SCHED_AUX.BANK_PARTY_ID HZ_PARTIES

[top of page]

JL.JL_BR_AR_PAY_SCHED_AUX does not reference any database object

JL.JL_BR_AR_PAY_SCHED_AUX is referenced by following:

JL
VIEW - JL_BR_AR_PAY_SCHED_AUX#

[top of page]

Table: JL_BR_AR_POSTING_TMP

Description: Temporary table for Bank collection GL Interface report
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_POSTING_TMP.CURRENCY_CODE FND_CURRENCIES
JL_BR_AR_POSTING_TMP.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I

[top of page]

JL.JL_BR_AR_POSTING_TMP does not reference any database object

JL.JL_BR_AR_POSTING_TMP is referenced by following:

JL
VIEW - JL_BR_AR_POSTING_TMP#

[top of page]

Table: JL_BR_AR_REC_MET_ACCTS_EXT_ALL

Description: Receipt Method accounts
Primary Key: JL_BR_AR_REC_MET_ACC_EXT_PK
  1. BANK_ACCT_USE_ID
  2. RECEIPT_METHOD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.BANK_ACCOUNT_ID
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.RECEIPT_METHOD_ID 		AR_RECEIPT_METHOD_ACCOUNTS_ALL
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.INTEREST_REVENUE_CCID GL_CODE_COMBINATIONS
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.CALCULATED_INTEREST_RECTRX_ID AR_RECEIVABLES_TRX_ALL
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.INTEREST_WRITEOFF_RECTRX_ID AR_RECEIVABLES_TRX_ALL
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.INTEREST_REVENUE_RECTRX_ID AR_RECEIVABLES_TRX_ALL
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.ABATEMENT_WRITEOFF_RECTRX_ID AR_RECEIVABLES_TRX_ALL
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.ABATEMENT_REVENUE_RECTRX_ID AR_RECEIVABLES_TRX_ALL
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.BATCH_SOURCE_ID AR_BATCH_SOURCES_ALL
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.FACTOR_FORMAT_PGM_ID AP_PAYMENT_PROGRAMS
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.COLL_FORMAT_PGM_ID AP_PAYMENT_PROGRAMS
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.BANK_ACCT_USE_ID CE_BANK_ACCT_USES_ALL
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.BANK_CHARGES_CCID GL_CODE_COMBINATIONS
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.COLL_ENDORSEMENT_CCID GL_CODE_COMBINATIONS
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.OTHER_CREDITS_CCID GL_CODE_COMBINATIONS
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.FACTORING_DOCS_CCID GL_CODE_COMBINATIONS
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.CALCULATED_INTEREST_CCID GL_CODE_COMBINATIONS
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.INTEREST_WRITEOFF_CCID GL_CODE_COMBINATIONS
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.BILLS_COLLECTION_CCID GL_CODE_COMBINATIONS
JL_BR_AR_REC_MET_ACCTS_EXT_ALL.ABATEMENT_WRITEOFF_CCID GL_CODE_COMBINATIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_BR_AR_PAY_SCHED_AUX.BANK_ACCOUNT_ID
JL_BR_AR_PAY_SCHED_AUX.RECEIPT_METHOD_ID 		JL_BR_AR_REC_MET_ACCTS_EXT_ALL

[top of page]

JL.JL_BR_AR_REC_MET_ACCTS_EXT_ALL does not reference any database object

JL.JL_BR_AR_REC_MET_ACCTS_EXT_ALL is referenced by following:

JL
VIEW - JL_BR_AR_REC_MET_ACCTS_EXT_AL#

[top of page]

Table: JL_BR_AR_REMIT_BORDEROS_ALL

Description: Request IDs of Formatted Bank Transfer Batches
Primary Key: JL_BR_AR_REMIT_BORDEROS_ALL_PK
  1. FORMAT_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_REMIT_BORDEROS_ALL.BORDERO_ID JL_BR_AR_BORDEROS_ALL
JL_BR_AR_REMIT_BORDEROS_ALL.OUTPUT_PROGRAM_ID AP_PAYMENT_PROGRAMS

[top of page]

JL.JL_BR_AR_REMIT_BORDEROS_ALL does not reference any database object

JL.JL_BR_AR_REMIT_BORDEROS_ALL is referenced by following:

JL
VIEW - JL_BR_AR_REMIT_BORDEROS_ALL#

[top of page]

Table: JL_BR_AR_RET_INTERFACE_ALL

Description: Interface table for importing bank returns
Primary Key: JL_BR_AR_RET_INTERFACE_ALL_PK
  1. FILE_CONTROL
  2. ENTRY_SEQUENTIAL_NUMBER

[top of page]

JL.JL_BR_AR_RET_INTERFACE_ALL does not reference any database object

JL.JL_BR_AR_RET_INTERFACE_ALL is referenced by following:

JL
VIEW - JL_BR_AR_RET_INTERFACE_ALL#

[top of page]

Table: JL_BR_AR_RET_INTERFACE_EXT_ALL

Description: Interface table with erroneous bank returns rows
Primary Key: JL_BR_AR_RET_INTER_EXT_ALL_PK
  1. FILE_CONTROL
  2. ENTRY_SEQUENTIAL_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_RET_INTERFACE_EXT_ALL.BANK_PARTY_ID HZ_PARTIES
JL_BR_AR_RET_INTERFACE_EXT_ALL.COLLECTOR_BANK_PARTY_ID HZ_PARTIES
JL_BR_AR_RET_INTERFACE_EXT_ALL.COLLECTOR_BRANCH_PARTY_ID HZ_PARTIES

[top of page]

JL.JL_BR_AR_RET_INTERFACE_EXT_ALL does not reference any database object

JL.JL_BR_AR_RET_INTERFACE_EXT_ALL is referenced by following:

JL
VIEW - JL_BR_AR_RET_INTERFACE_EXT_AL#

[top of page]

Table: JL_BR_AR_RET_INTERFACE_TMP

Description: Temporary table for post bank returns report
Primary Key: JL_BR_AR_RET_INTERFACE_TMP_PK
  1. RETURN_REQUEST_ID

[top of page]

JL.JL_BR_AR_RET_INTERFACE_TMP does not reference any database object

JL.JL_BR_AR_RET_INTERFACE_TMP is referenced by following:

JL
VIEW - JL_BR_AR_RET_INTERFACE_TMP#

[top of page]

Table: JL_BR_AR_SELECT_ACCOUNTS_ALL

Description: Bank Account distribution criteria for Bank Transfer batches
Primary Key: JL_BR_AR_SELECT_ACCOUNTS_PK
  1. SELECT_ACCOUNT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_SELECT_ACCOUNTS_ALL.SELECTION_CONTROL_ID JL_BR_AR_SELECT_CONTROLS_ALL
JL_BR_AR_SELECT_ACCOUNTS_ALL.BANK_ACCOUNT_ID AP_BANK_ACCOUNTS_ALL
JL_BR_AR_SELECT_ACCOUNTS_ALL.BATCH_SOURCE_ID AR_BATCH_SOURCES_ALL
JL_BR_AR_SELECT_ACCOUNTS_ALL.BANK_ACCT_USE_ID CE_BANK_ACCT_USES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_BR_AR_BORDEROS_ALL.SELECT_ACCOUNT_ID JL_BR_AR_SELECT_ACCOUNTS_ALL
JL_BR_AR_PAY_SCHED_AUX.SELECT_ACCOUNT_ID JL_BR_AR_SELECT_ACCOUNTS_ALL

[top of page]

JL.JL_BR_AR_SELECT_ACCOUNTS_ALL does not reference any database object

JL.JL_BR_AR_SELECT_ACCOUNTS_ALL is referenced by following:

JL
VIEW - JL_BR_AR_SELECT_ACCOUNTS_ALL#

[top of page]

Table: JL_BR_AR_SELECT_CONTROLS_ALL

Description: Selection Criteria for invoices sent to Bank transfer batches
Primary Key: JL_BR_AR_SELECT_CONTROL_ALL_PK
  1. SELECTION_CONTROL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_SELECT_CONTROLS_ALL.CUST_TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_BR_AR_BORDEROS_ALL.SELECTION_CONTROL_ID JL_BR_AR_SELECT_CONTROLS_ALL
JL_BR_AR_SELECT_ACCOUNTS_ALL.SELECTION_CONTROL_ID JL_BR_AR_SELECT_CONTROLS_ALL

[top of page]

JL.JL_BR_AR_SELECT_CONTROLS_ALL does not reference any database object

JL.JL_BR_AR_SELECT_CONTROLS_ALL is referenced by following:

JL
VIEW - JL_BR_AR_SELECT_CONTROLS_ALL#

[top of page]

Table: JL_BR_AR_TX_CATEG_ALL

Description: Brazilian Tax Categories;no longer used
Primary Key: JL_BR_AR_TX_CATEG_ALL_PK
  1. TAX_CATEGORY_ID
  2. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_TX_CATEG_ALL.TAX_CATEG_TO_REDUCE_ID
JL_BR_AR_TX_CATEG_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_BR_AR_TX_CATEG_ALL.TAX_CATEG_TO_REDUCE_ID
JL_BR_AR_TX_CATEG_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL
JL_BR_AR_TX_EXC_FSC_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_EXC_FSC_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL
JL_BR_AR_TX_EXC_ITM_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_EXC_ITM_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL
JL_BR_AR_TX_FSC_CLS_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_FSC_CLS_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL
JL_BR_AR_TX_GROUP_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_GROUP_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL
JL_BR_AR_TX_GROUP_ALL.TAX_CATEGORY_TO_REDUCE_ID
JL_BR_AR_TX_GROUP_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL
JL_BR_AR_TX_LOCN_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_LOCN_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL
JL_BR_AR_TX_RULES_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_RULES_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL

[top of page]

JL.JL_BR_AR_TX_CATEG_ALL does not reference any database object

JL.JL_BR_AR_TX_CATEG_ALL is referenced by following:

JL
VIEW - JL_BR_AR_TX_CATEG_ALL#

[top of page]

Table: JL_BR_AR_TX_EXC_FSC_ALL

Description: Brazilian Tax Exception By Fiscal Classification Information;no longer used
Primary Key: JL_BR_AR_TX_EXC_FSC_ALL_PK
  1. SHIP_FROM_CODE
  2. SHIP_TO_SEGMENT_ID
  3. FISCAL_CLASSIFICATION_CODE
  4. TAX_CATEGORY_ID
  5. END_DATE_ACTIVE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_TX_EXC_FSC_ALL.SHIP_TO_SEGMENT_ID AR_LOCATION_VALUES_OLD
JL_BR_AR_TX_EXC_FSC_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_EXC_FSC_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL

[top of page]

JL.JL_BR_AR_TX_EXC_FSC_ALL does not reference any database object

JL.JL_BR_AR_TX_EXC_FSC_ALL is referenced by following:

JL
VIEW - JL_BR_AR_TX_EXC_FSC_ALL#

[top of page]

Table: JL_BR_AR_TX_EXC_ITM_ALL

Description: Brazilian Tax Excption By Item Information;no longer used
Primary Key: JL_BR_AR_TX_EXC_ITM_ALL_PK
  1. SHIP_FROM_CODE
  2. SHIP_TO_SEGMENT_ID
  3. INVENTORY_ITEM_ID
  4. ORGANIZATION_ID
  5. TAX_CATEGORY_ID
  6. END_DATE_ACTIVE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_TX_EXC_ITM_ALL.SHIP_TO_SEGMENT_ID AR_LOCATION_VALUES_OLD
JL_BR_AR_TX_EXC_ITM_ALL.INVENTORY_ITEM_ID
JL_BR_AR_TX_EXC_ITM_ALL.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
JL_BR_AR_TX_EXC_ITM_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_EXC_ITM_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL

[top of page]

JL.JL_BR_AR_TX_EXC_ITM_ALL does not reference any database object

JL.JL_BR_AR_TX_EXC_ITM_ALL is referenced by following:

JL
VIEW - JL_BR_AR_TX_EXC_ITM_ALL#

[top of page]

Table: JL_BR_AR_TX_FSC_CLS_ALL

Description: Brazilian Tax Fiscal Classification Information;no longer used
Primary Key: JL_BR_AR_TX_FSC_CLS_ALL_PK
  1. FISCAL_CLASSIFICATION_CODE
  2. TAX_CATEGORY_ID
  3. END_DATE_ACTIVE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_TX_FSC_CLS_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_FSC_CLS_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL

[top of page]

JL.JL_BR_AR_TX_FSC_CLS_ALL does not reference any database object

JL.JL_BR_AR_TX_FSC_CLS_ALL is referenced by following:

JL
VIEW - JL_BR_AR_TX_FSC_CLS_ALL#

[top of page]

Table: JL_BR_AR_TX_GROUP_ALL

Description: Brazilian Tax Groups;no longer used
Primary Key: JL_BR_AR_TX_GROUP_ALL_PK
  1. GROUP_TAX_ID
  2. TAX_CATEGORY_ID
  3. END_DATE_ACTIVE
  4. TRANSACTION_NATURE
  5. CONTRIBUTOR_TYPE
  6. ESTABLISHMENT_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_TX_GROUP_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_GROUP_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL
JL_BR_AR_TX_GROUP_ALL.GROUP_TAX_ID AR_VAT_TAX_ALL_B
JL_BR_AR_TX_GROUP_ALL.TAX_CATEGORY_TO_REDUCE_ID
JL_BR_AR_TX_GROUP_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL

[top of page]

JL.JL_BR_AR_TX_GROUP_ALL does not reference any database object

JL.JL_BR_AR_TX_GROUP_ALL is referenced by following:

JL
VIEW - JL_BR_AR_TX_GROUP_ALL#

[top of page]

Table: JL_BR_AR_TX_LOCN_ALL

Description: Brazilian Tax Location Information;no longer used
Primary Key: JL_BR_AR_TX_LOCN_ALL_PK
  1. SHIP_FROM_CODE
  2. SHIP_TO_SEGMENT_ID
  3. TAX_CATEGORY_ID
  4. END_DATE_ACTIVE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_TX_LOCN_ALL.SHIP_TO_SEGMENT_ID AR_LOCATION_VALUES_OLD
JL_BR_AR_TX_LOCN_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_LOCN_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL

[top of page]

JL.JL_BR_AR_TX_LOCN_ALL does not reference any database object

JL.JL_BR_AR_TX_LOCN_ALL is referenced by following:

JL
VIEW - JL_BR_AR_TX_LOCN_ALL#

[top of page]

Table: JL_BR_AR_TX_RULES_ALL

Description: Brazilian Tax Rules Information;no longer used
Primary Key: JL_BR_AR_TX_RULES_ALL_PK
  1. TAX_RULE_LEVEL
  2. TAX_CATEGORY_ID
  3. CONTRIBUTOR_TYPE
  4. CUST_TRX_TYPE_ID
  5. PRIORITY
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_AR_TX_RULES_ALL.TAX_CATEGORY_ID
JL_BR_AR_TX_RULES_ALL.ORG_ID 		JL_BR_AR_TX_CATEG_ALL
JL_BR_AR_TX_RULES_ALL.CUST_TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL

[top of page]

JL.JL_BR_AR_TX_RULES_ALL does not reference any database object

JL.JL_BR_AR_TX_RULES_ALL is referenced by following:

JL
VIEW - JL_BR_AR_TX_RULES_ALL#

[top of page]

Table: JL_BR_BALANCES_ALL

Description: Oracle Payables and Oracle Receivables transaction balances
Primary Key: JL_BR_BALANCES_ALL_PK
  1. APPLICATION_ID
  2. SET_OF_BOOKS_ID
  3. PERIOD_SET_NAME
  4. PERIOD_NAME
  5. CODE_COMBINATION_ID
  6. PERSONNEL_ID

[top of page]

JL.JL_BR_BALANCES_ALL does not reference any database object

JL.JL_BR_BALANCES_ALL is referenced by following:

JL
VIEW - JL_BR_BALANCES_ALL#

[top of page]

Table: JL_BR_CINFOS_BOOKS

Description: A table to store the Company Accounting Books setup information

[top of page]

JL.JL_BR_CINFOS_BOOKS does not reference any database object

JL.JL_BR_CINFOS_BOOKS is referenced by following:

JL
VIEW - JL_BR_CINFOS_BOOKS#

[top of page]

Table: JL_BR_COMPANY_INFOS

Description: No Longer Used in R12
Primary Key: JL_BR_COMPANY_INFOS_PK
  1. SET_OF_BOOKS_ID
  2. ACCOUNTING_BALANCING_SEGMENT
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_COMPANY_INFOS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_BR_GL_LEGAL_REP.SET_OF_BOOKS_ID
JL_BR_GL_LEGAL_REP.ACCOUNTING_BALANCING_SEGMENT 		JL_BR_COMPANY_INFOS

[top of page]

JL.JL_BR_COMPANY_INFOS does not reference any database object

JL.JL_BR_COMPANY_INFOS is referenced by following:

JL
VIEW - JL_BR_COMPANY_INFOS#

[top of page]

Table: JL_BR_CUSTOMER_TRX_EXTS

Description: Stores transactions for Brazilian SPED

[top of page]

JL.JL_BR_CUSTOMER_TRX_EXTS does not reference any database object

JL.JL_BR_CUSTOMER_TRX_EXTS is referenced by following:

JL
VIEW - JL_BR_CUSTOMER_TRX_EXTS#

[top of page]

Table: JL_BR_CUST_TRX_LINES_EXTS

Description: Stores Brazilian Electronic Invoice Line Attributes (1:1 extension to RA_CUSTOMER_TRX_LINES_ALL table

[top of page]

JL.JL_BR_CUST_TRX_LINES_EXTS does not reference any database object

JL.JL_BR_CUST_TRX_LINES_EXTS is referenced by following:

JL
VIEW - JL_BR_CUST_TRX_LINES_EXTS#

[top of page]

Table: JL_BR_EILOG

Description: Stores log data for Brazilian SPED

[top of page]

JL.JL_BR_EILOG does not reference any database object

JL.JL_BR_EILOG is referenced by following:

JL
VIEW - JL_BR_EILOG#

[top of page]

Table: JL_BR_GL_LEGAL_REP

Description: Ledger Book and Subledger Information
Primary Key: JL_BR_GL_LEGAL_REP_PK
  1. CONCURRENT_REQUEST_ID
  2. BOOK_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_GL_LEGAL_REP.SET_OF_BOOKS_ID
JL_BR_GL_LEGAL_REP.ACCOUNTING_BALANCING_SEGMENT 		JL_BR_COMPANY_INFOS

[top of page]

JL.JL_BR_GL_LEGAL_REP does not reference any database object

JL.JL_BR_GL_LEGAL_REP is referenced by following:

JL
VIEW - JL_BR_GL_LEGAL_REP#

[top of page]

Table: JL_BR_INTERFACE_LINES_EXTS

Description: Stores Brazilian Electronic Invoice Line Attributes at Receivables Interface Line Level (1:1 extension to RA_INTERFACE_LINES_ALL table)

[top of page]

JL.JL_BR_INTERFACE_LINES_EXTS does not reference any database object

JL.JL_BR_INTERFACE_LINES_EXTS is referenced by following:

JL
VIEW - JL_BR_INTERFACE_LINES_EXTS#

[top of page]

Table: JL_BR_INV_API_TRX_LINES_T

Description: Temporary Table to Store Brazilian Electronic Invoice Line Attributes during Invoice API process (1:1 extension to Receivables Invoice API PLSQL table for Line details

[top of page]

JL.JL_BR_INV_API_TRX_LINES_T does not reference any database object

JL.JL_BR_INV_API_TRX_LINES_T is referenced by following:

JL
VIEW - JL_BR_INV_API_TRX_LINES_T#

[top of page]

Table: JL_BR_JOURNALS_ALL

Description: Accounting entries successfully transferred from the subledgers to GL
Primary Key: JL_BR_JOURNALS_ALL_PK
  1. APPLICATION_ID
  2. SET_OF_BOOKS_ID
  3. CODE_COMBINATION_ID
  4. PERSONNEL_ID
  5. ACCOUNTING_DATE
  6. TRANS_DESCRIPTION
  7. TRANS_ID
  8. INSTALLMENT
  9. PERIOD_SET_NAME
  10. PERIOD_NAME

[top of page]

JL.JL_BR_JOURNALS_ALL does not reference any database object

JL.JL_BR_JOURNALS_ALL is referenced by following:

JL
VIEW - JL_BR_JOURNALS_ALL#

[top of page]

Table: JL_BR_LOCAL_HOLIDAY_DATES

Description: Brazilian local holiday dates
Primary Key: JL_BR_LOCAL_HOLIDAY_DATES_PK
  1. LOCAL_HOLIDAY_SET_ID
  2. LOCAL_HOLIDAY_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_LOCAL_HOLIDAY_DATES.LOCAL_HOLIDAY_SET_ID JL_BR_LOCAL_HOLIDAY_SETS

[top of page]

JL.JL_BR_LOCAL_HOLIDAY_DATES does not reference any database object

JL.JL_BR_LOCAL_HOLIDAY_DATES is referenced by following:

JL
VIEW - JL_BR_LOCAL_HOLIDAY_DATES#

[top of page]

Table: JL_BR_LOCAL_HOLIDAY_SETS

Description: Brazilian local holiday sets
Primary Key: JL_BR_LOCAL_HOLIDAY_SETS_PK
  1. LOCAL_HOLIDAY_SET_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_BR_LOCAL_HOLIDAY_DATES.LOCAL_HOLIDAY_SET_ID JL_BR_LOCAL_HOLIDAY_SETS

[top of page]

JL.JL_BR_LOCAL_HOLIDAY_SETS does not reference any database object

JL.JL_BR_LOCAL_HOLIDAY_SETS is referenced by following:

JL
VIEW - JL_BR_LOCAL_HOLIDAY_SETS#

[top of page]

Table: JL_BR_SPED_EXTR_DATA_H

Description: A history table to store the finally submitted Accounting SPED Text file data

[top of page]

JL.JL_BR_SPED_EXTR_DATA_H does not reference any database object

JL.JL_BR_SPED_EXTR_DATA_H is referenced by following:

JL
VIEW - JL_BR_SPED_EXTR_DATA_H#

[top of page]

Table: JL_BR_SPED_EXTR_DATA_T

Description: A table to store data required for generating the Accounting SPED text file

[top of page]

JL.JL_BR_SPED_EXTR_DATA_T does not reference any database object

JL.JL_BR_SPED_EXTR_DATA_T is referenced by following:

JL
VIEW - JL_BR_SPED_EXTR_DATA_T#

[top of page]

Table: JL_BR_SPED_EXTR_MSGS

Description: A table to store information about the Accounting SPED Text File Validation Rules that have failed

[top of page]

JL.JL_BR_SPED_EXTR_MSGS does not reference any database object

JL.JL_BR_SPED_EXTR_MSGS is referenced by following:

JL
VIEW - JL_BR_SPED_EXTR_MSGS#

[top of page]

Table: JL_BR_SPED_EXTR_PARAM

Description: A table to store the parameters of every Accounting SPED Data extract program submitted

[top of page]

JL.JL_BR_SPED_EXTR_PARAM does not reference any database object

JL.JL_BR_SPED_EXTR_PARAM is referenced by following:

JL
VIEW - JL_BR_SPED_EXTR_PARAM#

[top of page]

Table: JL_BR_SPED_PARTIC_CODES

Description: A table to store the Participant Codes setup information

[top of page]

JL.JL_BR_SPED_PARTIC_CODES does not reference any database object

JL.JL_BR_SPED_PARTIC_CODES is referenced by following:

JL
VIEW - JL_BR_SPED_PARTIC_CODES#

[top of page]

Table: JL_BR_SPED_PARTIC_REL

Description: A table to store the Participant Relationship setup information

[top of page]

JL.JL_BR_SPED_PARTIC_REL does not reference any database object

JL.JL_BR_SPED_PARTIC_REL is referenced by following:

JL
VIEW - JL_BR_SPED_PARTIC_REL#

[top of page]

Table: JL_BR_TAX_LMSG_ALL

Description: Brazilian Tax Legal Messages;no longer used
Primary Key: JL_BR_TAX_LMSG_ALL_PK
  1. RULE_ID
  2. RULE_DATA_ID
  3. EXCEPTION_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_BR_TAX_LMSG_ALL.MESSAGE_ID AR_STANDARD_TEXT_B

[top of page]

JL.JL_BR_TAX_LMSG_ALL does not reference any database object

JL.JL_BR_TAX_LMSG_ALL is referenced by following:

JL
VIEW - JL_BR_TAX_LMSG_ALL#

[top of page]

Table: JL_CANCEL_GT

Description:

[top of page]

JL.JL_CANCEL_GT does not reference any database object

JL.JL_CANCEL_GT is referenced by following:

APPS
SYNONYM - JL_CANCEL_GT

[top of page]

Table: JL_CL_AP_AWT_CERT

Description: Chilean withholding certificate information
Primary Key: JL_CL_AP_AWT_CERT_PK
  1. CERTIFICATE_ID

[top of page]

JL.JL_CL_AP_AWT_CERT does not reference any database object

JL.JL_CL_AP_AWT_CERT is referenced by following:

JL
VIEW - JL_CL_AP_AWT_CERT#

[top of page]

Table: JL_CL_GL_ACCT_HIER_TMP

Description: Chilean General Ledger "8 Columns Trial Balance" Report Account Hierarchy
Primary Key: JL_CL_GL_ACCT_HIER_TMP_PK
  1. FLEX_VALUE_SET_ID

[top of page]

JL.JL_CL_GL_ACCT_HIER_TMP does not reference any database object

JL.JL_CL_GL_ACCT_HIER_TMP is referenced by following:

JL
VIEW - JL_CL_GL_ACCT_HIER_TMP#

[top of page]

Table: JL_CO_FA_ADJUSTMENTS

Description: Accounting information pertaining to Colombian Oracle Assets
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_FA_ADJUSTMENTS.CODE_COMBINATION_ID GL_CODE_COMBINATIONS
JL_CO_FA_ADJUSTMENTS.BOOK_TYPE_CODE FA_BOOK_CONTROLS
JL_CO_FA_ADJUSTMENTS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
JL_CO_FA_ADJUSTMENTS.ASSET_ID FA_ADDITIONS_B

[top of page]

JL.JL_CO_FA_ADJUSTMENTS does not reference any database object

JL.JL_CO_FA_ADJUSTMENTS is referenced by following:

JL
VIEW - JL_CO_FA_ADJUSTMENTS#

[top of page]

Table: JL_CO_FA_APPRAISALS

Description: Information about the technical appraisal header
Primary Key: JL_CO_FA_APPRAISALS_PK
  1. APPRAISAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_FA_APPRAISALS.CURRENCY_CODE FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_CO_FA_APPRAISAL_BOOKS.APPRAISAL_ID JL_CO_FA_APPRAISALS
JL_CO_FA_ASSET_APPRS.APPRAISAL_ID JL_CO_FA_APPRAISALS

[top of page]

JL.JL_CO_FA_APPRAISALS does not reference any database object

JL.JL_CO_FA_APPRAISALS is referenced by following:

JL
VIEW - JL_CO_FA_APPRAISALS#

[top of page]

Table: JL_CO_FA_APPRAISAL_BOOKS

Description: Information about the book for which the appraisal has been revaluated successfully
Primary Key: JL_CO_APPRAISAL_BOOK_PK
  1. APPRAISAL_ID
  2. BOOK_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_FA_APPRAISAL_BOOKS.APPRAISAL_ID JL_CO_FA_APPRAISALS
JL_CO_FA_APPRAISAL_BOOKS.BOOK_TYPE_CODE FA_BOOK_CONTROLS

[top of page]

JL.JL_CO_FA_APPRAISAL_BOOKS does not reference any database object

JL.JL_CO_FA_APPRAISAL_BOOKS is referenced by following:

JL
VIEW - JL_CO_FA_APPRAISAL_BOOKS#

[top of page]

Table: JL_CO_FA_ASSET_APPRS

Description: Information about assets appraised
Primary Key: JL_CO_FA_ASSET_APPRS_PK
  1. APPRAISAL_ID
  2. ASSET_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_FA_ASSET_APPRS.APPRAISAL_ID JL_CO_FA_APPRAISALS

[top of page]

JL.JL_CO_FA_ASSET_APPRS does not reference any database object

JL.JL_CO_FA_ASSET_APPRS is referenced by following:

JL
VIEW - JL_CO_FA_ASSET_APPRS#

[top of page]

Table: JL_CO_FA_PURGE

Description: Information about the Colombian archive, purge and restore requests
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_FA_PURGE.BOOK_TYPE_CODE FA_BOOK_CONTROLS

[top of page]

JL.JL_CO_FA_PURGE does not reference any database object

JL.JL_CO_FA_PURGE is referenced by following:

JL
VIEW - JL_CO_FA_PURGE#

[top of page]

Table: JL_CO_GL_BALANCES

Description: Third Party Balances Table Summarized By Third Party Identifier And Period For A Code Combination And Set Of Books ID
Primary Key: JL_CO_GL_BALANCES_PK
  1. BALANCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_GL_BALANCES.NIT_ID JL_CO_GL_NITS
JL_CO_GL_BALANCES.CODE_COMBINATION_ID GL_CODE_COMBINATIONS
JL_CO_GL_BALANCES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I

[top of page]

JL.JL_CO_GL_BALANCES does not reference any database object

JL.JL_CO_GL_BALANCES is referenced by following:

JL
VIEW - JL_CO_GL_BALANCES#

[top of page]

Table: JL_CO_GL_CONC_CTRL

Description: Third Party Control Table Containing Log For Every Submission Of 'Generate Third Party Balances' Concurrent Program
Primary Key: JL_CO_GL_CONC_CTRL_PK
  1. PROCESS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_GL_CONC_CTRL.REVERSED_PROCESS_ID JL_CO_GL_CONC_CTRL
JL_CO_GL_CONC_CTRL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_CO_GL_CONC_CTRL.REVERSED_PROCESS_ID JL_CO_GL_CONC_CTRL
JL_CO_GL_CONC_ERRS.PROCESS_ID JL_CO_GL_CONC_CTRL
JL_CO_GL_TRX.PROCESS_ID JL_CO_GL_CONC_CTRL

[top of page]

JL.JL_CO_GL_CONC_CTRL does not reference any database object

JL.JL_CO_GL_CONC_CTRL is referenced by following:

JL
VIEW - JL_CO_GL_CONC_CTRL#

[top of page]

Table: JL_CO_GL_CONC_ERRS

Description: Third Party Errors Table Containing Error Log That Is Refreshed On Every New Submission Of 'Generate Third Party Balances' Concurrent Program
Primary Key: JL_CO_GL_CONC_ERRS_PK
  1. PROCESS_ID
  2. JE_HEADER_ID
  3. JE_LINE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_GL_CONC_ERRS.JE_HEADER_ID
JL_CO_GL_CONC_ERRS.JE_LINE_NUM 		GL_JE_LINES
JL_CO_GL_CONC_ERRS.PROCESS_ID JL_CO_GL_CONC_CTRL

[top of page]

JL.JL_CO_GL_CONC_ERRS does not reference any database object

JL.JL_CO_GL_CONC_ERRS is referenced by following:

JL
VIEW - JL_CO_GL_CONC_ERRS#

[top of page]

Table: JL_CO_GL_MG_CONFIGS

Description: Magnetic Media Report Grouping Configurations
Primary Key: JL_CO_GL_MG_CONFIGS_PK
  1. CONFIG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_GL_MG_CONFIGS.CONFIG_ID_PARENT JL_CO_GL_MG_CONFIGS
JL_CO_GL_MG_CONFIGS.LITERAL_ID JL_CO_GL_MG_LITERALS
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_CO_GL_MG_CONFIGS.CONFIG_ID_PARENT JL_CO_GL_MG_CONFIGS
JL_CO_GL_MG_LINES.CONFIG_ID JL_CO_GL_MG_CONFIGS
JL_CO_GL_MG_RANGES.CONFIG_ID JL_CO_GL_MG_CONFIGS

[top of page]

JL.JL_CO_GL_MG_CONFIGS does not reference any database object

JL.JL_CO_GL_MG_CONFIGS is referenced by following:

JL
VIEW - JL_CO_GL_MG_CONFIGS#

[top of page]

Table: JL_CO_GL_MG_HEADERS

Description: Magnetic Media Movement Headers
Primary Key: JL_CO_GL_MG_HEADERS_PK
  1. MG_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_GL_MG_HEADERS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_CO_GL_MG_LINES.MG_HEADER_ID JL_CO_GL_MG_HEADERS

[top of page]

JL.JL_CO_GL_MG_HEADERS does not reference any database object

JL.JL_CO_GL_MG_HEADERS is referenced by following:

JL
VIEW - JL_CO_GL_MG_HEADERS#

[top of page]

Table: JL_CO_GL_MG_LINES

Description: Magnetic Media Movement lines
Primary Key: JL_CO_GL_MG_LINES_PK
  1. MG_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_GL_MG_LINES.MG_HEADER_ID JL_CO_GL_MG_HEADERS
JL_CO_GL_MG_LINES.LITERAL_ID JL_CO_GL_MG_LITERALS
JL_CO_GL_MG_LINES.CONFIG_ID JL_CO_GL_MG_CONFIGS
JL_CO_GL_MG_LINES.RANGE_ID JL_CO_GL_MG_RANGES
JL_CO_GL_MG_LINES.NIT_ID JL_CO_GL_NITS

[top of page]

JL.JL_CO_GL_MG_LINES does not reference any database object

JL.JL_CO_GL_MG_LINES is referenced by following:

JL
VIEW - JL_CO_GL_MG_LINES#

[top of page]

Table: JL_CO_GL_MG_LITERALS

Description: Magnetic Media Literals
Primary Key: JL_CO_GL_MG_LITERALS_PK
  1. LITERAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_GL_MG_LITERALS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_CO_GL_MG_CONFIGS.LITERAL_ID JL_CO_GL_MG_LITERALS
JL_CO_GL_MG_LINES.LITERAL_ID JL_CO_GL_MG_LITERALS

[top of page]

JL.JL_CO_GL_MG_LITERALS does not reference any database object

JL.JL_CO_GL_MG_LITERALS is referenced by following:

JL
VIEW - JL_CO_GL_MG_LITERALS#

[top of page]

Table: JL_CO_GL_MG_RANGES

Description: Magnetic Media Account Ranges
Primary Key: JL_CO_GL_MG_RANGES_PK
  1. RANGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_GL_MG_RANGES.CONFIG_ID JL_CO_GL_MG_CONFIGS
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_CO_GL_MG_LINES.RANGE_ID JL_CO_GL_MG_RANGES

[top of page]

JL.JL_CO_GL_MG_RANGES does not reference any database object

JL.JL_CO_GL_MG_RANGES is referenced by following:

JL
VIEW - JL_CO_GL_MG_RANGES#

[top of page]

Table: JL_CO_GL_NITS

Description: Third Party Master Table
Primary Key: JL_CO_GL_NITS_PK
  1. NIT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_CO_GL_BALANCES.NIT_ID JL_CO_GL_NITS
JL_CO_GL_MG_LINES.NIT_ID JL_CO_GL_NITS
JL_CO_GL_TRX.NIT_ID JL_CO_GL_NITS

[top of page]

JL.JL_CO_GL_NITS does not reference any database object

JL.JL_CO_GL_NITS is referenced by following:

JL
VIEW - JL_CO_GL_NITS#

[top of page]

Table: JL_CO_GL_NIT_ACCTS

Description: Third Party Control Accounts Table Used For Referring NIT Required Accounts
Primary Key: JL_CO_GL_NIT_ACCTS_PK
  1. ACCOUNT_CODE
  2. CHART_OF_ACCOUNTS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_GL_NIT_ACCTS.FLEX_VALUE_ID FND_FLEX_VALUES

[top of page]

JL.JL_CO_GL_NIT_ACCTS does not reference any database object

JL.JL_CO_GL_NIT_ACCTS is referenced by following:

JL
VIEW - JL_CO_GL_NIT_ACCTS#

[top of page]

Table: JL_CO_GL_TRX

Description: Third Party Transaction Table Containing Posted Transactions Of GL From Different Sources For NIT Required Accounts
Primary Key: JL_CO_GL_TRX_PK
  1. TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_CO_GL_TRX.NIT_ID JL_CO_GL_NITS
JL_CO_GL_TRX.PROCESS_ID JL_CO_GL_CONC_CTRL
JL_CO_GL_TRX.CODE_COMBINATION_ID GL_CODE_COMBINATIONS
JL_CO_GL_TRX.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
JL_CO_GL_TRX.JE_BATCH_ID GL_JE_BATCHES
JL_CO_GL_TRX.JE_HEADER_ID
JL_CO_GL_TRX.JE_LINE_NUM 		GL_JE_LINES

[top of page]

JL.JL_CO_GL_TRX does not reference any database object

JL.JL_CO_GL_TRX is referenced by following:

JL
VIEW - JL_CO_GL_TRX#

[top of page]

Table: JL_MX_FA_ISR_IMPAC

Description: Holds information generated during the execution of ISR and IMPAC reports
Primary Key: JL_MX_FA_ISR_IMPAC_PK
  1. PROCESS_ID
  2. ASSET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_MX_FA_ISR_IMPAC.ASSET_ID FA_ADDITIONS_B

[top of page]

JL.JL_MX_FA_ISR_IMPAC does not reference any database object

JL.JL_MX_FA_ISR_IMPAC is referenced by following:

JL
VIEW - JL_MX_FA_ISR_IMPAC#

[top of page]

Table: JL_REMIT3_GT

Description:

[top of page]

JL.JL_REMIT3_GT does not reference any database object

JL.JL_REMIT3_GT is referenced by following:

APPS
SYNONYM - JL_REMIT3_GT

[top of page]

Table: JL_REMIT_GT

Description:

[top of page]

JL.JL_REMIT_GT does not reference any database object

JL.JL_REMIT_GT is referenced by following:

APPS
SYNONYM - JL_REMIT_GT

[top of page]

Table: JL_ZZ_AP_AWT_TYPES

Description: Withholding tax type records for Argentina and Colombia
Primary Key: JL_ZZ_AP_AWT_TYPES_PK
  1. AWT_TYPE_CODE

[top of page]

JL.JL_ZZ_AP_AWT_TYPES does not reference any database object

JL.JL_ZZ_AP_AWT_TYPES is referenced by following:

JL
VIEW - JL_ZZ_AP_AWT_TYPES#

[top of page]

Table: JL_ZZ_AP_COMP_AWT_TYPES

Description: Withholding applicability information per company/location for Argentina and Colombia
Primary Key: JL_ZZ_AP_COMP_AWT_TYPES_PK
  1. COMP_AWT_TYPE_ID

[top of page]

JL.JL_ZZ_AP_COMP_AWT_TYPES does not reference any database object

JL.JL_ZZ_AP_COMP_AWT_TYPES is referenced by following:

JL
VIEW - JL_ZZ_AP_COMP_AWT_TYPES#

[top of page]

Table: JL_ZZ_AP_INV_DIS_WH_ALL

Description: Invoice distribution withholding information for Argentina and Colombia
Primary Key: JL_ZZ_AP_INV_DIS_WH_ALL_PK
  1. INV_DISTRIB_AWT_ID

[top of page]

JL.JL_ZZ_AP_INV_DIS_WH_ALL does not reference any database object

JL.JL_ZZ_AP_INV_DIS_WH_ALL is referenced by following:

JL
VIEW - JL_ZZ_AP_INV_DIS_WH_ALL#

[top of page]

Table: JL_ZZ_AP_INV_DIS_WH_ALL_T

Description:

[top of page]

JL.JL_ZZ_AP_INV_DIS_WH_ALL_T does not reference any database object

JL.JL_ZZ_AP_INV_DIS_WH_ALL_T is referenced by following:

JL
VIEW - JL_ZZ_AP_INV_DIS_WH_ALL_T#

[top of page]

Table: JL_ZZ_AP_SUPP_AWT_TYPES

Description: Withholding applicability information per supplier for Argentina and Colombia
Primary Key: JL_ZZ_AP_SUPP_AWT_TYPES_PK
  1. SUPP_AWT_TYPE_ID

[top of page]

JL.JL_ZZ_AP_SUPP_AWT_TYPES does not reference any database object

JL.JL_ZZ_AP_SUPP_AWT_TYPES is referenced by following:

JL
VIEW - JL_ZZ_AP_SUPP_AWT_TYPES#

[top of page]

Table: JL_ZZ_AP_SUP_AWT_CD_ALL

Description: Withholding tax codes applicable to Argentine and Colombian suppliers
Primary Key: JL_ZZ_AP_SUP_AWT_CD_ALL_PK
  1. SUPP_AWT_CODE_ID

[top of page]

JL.JL_ZZ_AP_SUP_AWT_CD_ALL does not reference any database object

JL.JL_ZZ_AP_SUP_AWT_CD_ALL is referenced by following:

JL
VIEW - JL_ZZ_AP_SUP_AWT_CD_ALL#

[top of page]

Table: JL_ZZ_AR_TX_ATT_CLS_ALL

Description: Latin Tax Condition Classes Information
Primary Key: JL_ZZ_AR_TX_ATT_CLS_ALL_PK
  1. ATTRIBUTE_CLASS_ID

[top of page]

JL.JL_ZZ_AR_TX_ATT_CLS_ALL does not reference any database object

JL.JL_ZZ_AR_TX_ATT_CLS_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_ATT_CLS_ALL#

[top of page]

Table: JL_ZZ_AR_TX_ATT_VAL_ALL

Description: Latin Tax Condition Values Information
Primary Key: JL_ZZ_AR_TX_ATT_VAL_ALL_PK
  1. TAX_CATEG_ATTR_VAL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_ZZ_AR_TX_NAT_RAT_ALL.TAX_CATEG_ATTR_VAL_ID JL_ZZ_AR_TX_ATT_VAL_ALL

[top of page]

JL.JL_ZZ_AR_TX_ATT_VAL_ALL does not reference any database object

JL.JL_ZZ_AR_TX_ATT_VAL_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_ATT_VAL_ALL#

[top of page]

Table: JL_ZZ_AR_TX_CATEG_ALL

Description: Latin Tax Category Information
Primary Key: JL_ZZ_AR_TX_CATEGRY_ALL_PK
  1. TAX_CATEGORY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_ZZ_AR_TX_CAT_ATT_ALL.TAX_CATEGORY_ID JL_ZZ_AR_TX_CATEG_ALL

[top of page]

JL.JL_ZZ_AR_TX_CATEG_ALL does not reference any database object

JL.JL_ZZ_AR_TX_CATEG_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_CATEG_ALL#

[top of page]

Table: JL_ZZ_AR_TX_CAT_ATT_ALL

Description: Latin Tax Category - Conditions Association Information
Primary Key: JL_ZZ_AR_TX_CAT_ATT_ALL_PK
  1. TAX_CATEG_ATTR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_AR_TX_CAT_ATT_ALL.TAX_CATEGORY_ID JL_ZZ_AR_TX_CATEG_ALL

[top of page]

JL.JL_ZZ_AR_TX_CAT_ATT_ALL does not reference any database object

JL.JL_ZZ_AR_TX_CAT_ATT_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_CAT_ATT_ALL#

[top of page]

Table: JL_ZZ_AR_TX_CAT_DTL_ALL

Description: Latin Tax Category Detail Information
Primary Key: JL_ZZ_AR_TX_CAT_DTL_ALL_PK
  1. TAX_CATEG_DTL_ID

[top of page]

JL.JL_ZZ_AR_TX_CAT_DTL_ALL does not reference any database object

JL.JL_ZZ_AR_TX_CAT_DTL_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_CAT_DTL_ALL#

[top of page]

Table: JL_ZZ_AR_TX_CUS_CLS_ALL

Description: Latin Tax Customer Site Profile Information
Primary Key: JL_ZZ_AR_TX_CUS_CLS_ALL_PK
  1. CUS_CLASS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_AR_TX_CUS_CLS_ALL.ADDRESS_ID HZ_CUST_ACCT_SITES_ALL

[top of page]

JL.JL_ZZ_AR_TX_CUS_CLS_ALL does not reference any database object

JL.JL_ZZ_AR_TX_CUS_CLS_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_CUS_CLS_ALL#

[top of page]

Table: JL_ZZ_AR_TX_EXC_CUS_ALL

Description: Latin Tax Exception By Customer Site Information
Primary Key: JL_ZZ_AR_TX_EXC_CUS_ALL_PK
  1. EXC_CUS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_AR_TX_EXC_CUS_ALL.ADDRESS_ID HZ_CUST_ACCT_SITES_ALL

[top of page]

JL.JL_ZZ_AR_TX_EXC_CUS_ALL does not reference any database object

JL.JL_ZZ_AR_TX_EXC_CUS_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_EXC_CUS_ALL#

[top of page]

Table: JL_ZZ_AR_TX_EXC_FSC_ALL

Description: Latin Tax Exception By Fiscal Classification Information
Primary Key: JL_ZZ_AR_TX_EXC_FSC_ALL_PK
  1. EXC_FSC_ID

[top of page]

JL.JL_ZZ_AR_TX_EXC_FSC_ALL does not reference any database object

JL.JL_ZZ_AR_TX_EXC_FSC_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_EXC_FSC_ALL#

[top of page]

Table: JL_ZZ_AR_TX_EXC_ITM_ALL

Description: Latin Tax Exception By Item Information
Primary Key: JL_ZZ_AR_TX_EXC_ITM_ALL_PK
  1. EXC_ITM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_AR_TX_EXC_ITM_ALL.INVENTORY_ITEM_ID
JL_ZZ_AR_TX_EXC_ITM_ALL.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B

[top of page]

JL.JL_ZZ_AR_TX_EXC_ITM_ALL does not reference any database object

JL.JL_ZZ_AR_TX_EXC_ITM_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_EXC_ITM_ALL#

[top of page]

Table: JL_ZZ_AR_TX_FSC_CLS_ALL

Description: Latin Tax Fiscal Classification Information
Primary Key: JL_ZZ_AR_TX_FSC_CLS_ALL_PK
  1. FSC_CLS_ID

[top of page]

JL.JL_ZZ_AR_TX_FSC_CLS_ALL does not reference any database object

JL.JL_ZZ_AR_TX_FSC_CLS_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_FSC_CLS_ALL#

[top of page]

Table: JL_ZZ_AR_TX_GROUPS_ALL

Description: Latin Tax Group Information
Primary Key: JL_ZZ_AR_TX_GROUPS_ALL_PK
  1. END_DATE_ACTIVE
  2. TRANSACTION_NATURE
  3. CONTRIBUTOR_TYPE
  4. ESTABLISHMENT_TYPE
  5. TAX_CATEGORY_ID
  6. GROUP_TAX_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_AR_TX_GROUPS_ALL.GROUP_TAX_ID AR_VAT_TAX_ALL_B

[top of page]

JL.JL_ZZ_AR_TX_GROUPS_ALL does not reference any database object

JL.JL_ZZ_AR_TX_GROUPS_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_GROUPS_ALL#

[top of page]

Table: JL_ZZ_AR_TX_LGL_MSG_ALL

Description: Latin Tax Legal Messages Information
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_AR_TX_LGL_MSG_ALL.MESSAGE_ID AR_STANDARD_TEXT_B

[top of page]

JL.JL_ZZ_AR_TX_LGL_MSG_ALL does not reference any database object

JL.JL_ZZ_AR_TX_LGL_MSG_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_LGL_MSG_ALL#

[top of page]

Table: JL_ZZ_AR_TX_LOCN_ALL

Description: Latin Tax Location Information
Primary Key: JL_ZZ_AR_TX_LOCN_ALL_PK
  1. LOCN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_AR_TX_LOCN_ALL.SHIP_TO_SEGMENT_ID AR_LOCATION_VALUES_OLD

[top of page]

JL.JL_ZZ_AR_TX_LOCN_ALL does not reference any database object

JL.JL_ZZ_AR_TX_LOCN_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_LOCN_ALL#

[top of page]

Table: JL_ZZ_AR_TX_NAT_RAT_ALL

Description: Latin Tax Exception By Transaction Condition Values Information
Primary Key: JL_ZZ_AR_TX_NAT_RAT_ALL_PK
  1. TXN_NATURE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_AR_TX_NAT_RAT_ALL.TAX_CATEG_ATTR_VAL_ID JL_ZZ_AR_TX_ATT_VAL_ALL

[top of page]

JL.JL_ZZ_AR_TX_NAT_RAT_ALL does not reference any database object

JL.JL_ZZ_AR_TX_NAT_RAT_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_NAT_RAT_ALL#

[top of page]

Table: JL_ZZ_AR_TX_RULES_ALL

Description: Latin Tax Rules Information
Primary Key: JL_ZZ_AR_TX_RULES_ALL_PK
  1. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_AR_TX_RULES_ALL.CUST_TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL

[top of page]

JL.JL_ZZ_AR_TX_RULES_ALL does not reference any database object

JL.JL_ZZ_AR_TX_RULES_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_RULES_ALL#

[top of page]

Table: JL_ZZ_AR_TX_SCHEDULES_ALL

Description: Latin Tax Schedules Information
Primary Key: JL_ZZ_AR_TX_SCHEDULES_ALL_PK
  1. TAX_CATEG_SLAB_ID

[top of page]

JL.JL_ZZ_AR_TX_SCHEDULES_ALL does not reference any database object

JL.JL_ZZ_AR_TX_SCHEDULES_ALL is referenced by following:

JL
VIEW - JL_ZZ_AR_TX_SCHEDULES_ALL#

[top of page]

Table: JL_ZZ_FA_RETIREMNT_ADJS

Description: Information about retired assets that need to be inflation adjusted
Primary Key: JL_ZZ_FA_RETIREMNT_ADJS_PK
  1. RETIREMENT_ID
  2. PERIOD_COUNTER
  3. DISTRIBUTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_FA_RETIREMNT_ADJS.JE_LINE_ID JL_ZZ_FA_RETIREMNT_JES
JL_ZZ_FA_RETIREMNT_ADJS.DISTRIBUTION_ID FA_DISTRIBUTION_HISTORY
JL_ZZ_FA_RETIREMNT_ADJS.RETIREMENT_ID FA_RETIREMENTS

[top of page]

JL.JL_ZZ_FA_RETIREMNT_ADJS does not reference any database object

JL.JL_ZZ_FA_RETIREMNT_ADJS is referenced by following:

JL
VIEW - JL_ZZ_FA_RETIREMNT_ADJS#

[top of page]

Table: JL_ZZ_FA_RETIREMNT_JES

Description: Audit table that stores inflation adjustment journal entries of retired assets at code combination level
Primary Key: JL_ZZ_FA_RETIREMNT_JES_PK
  1. JE_LINE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_ZZ_FA_RETIREMNT_ADJS.JE_LINE_ID JL_ZZ_FA_RETIREMNT_JES

[top of page]

JL.JL_ZZ_FA_RETIREMNT_JES does not reference any database object

JL.JL_ZZ_FA_RETIREMNT_JES is referenced by following:

JL
VIEW - JL_ZZ_FA_RETIREMNT_JES#

[top of page]

Table: JL_ZZ_GL_AXI

Description: Inflation Adjustment Gain and Loss Accounts
Primary Key: JL_ZZ_GL_AXI_PK
  1. CODE_COMBINATION_ID
  2. SET_OF_BOOKS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_GL_AXI.CODE_COMBINATION_ID GL_CODE_COMBINATIONS
JL_ZZ_GL_AXI.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS

[top of page]

JL.JL_ZZ_GL_AXI does not reference any database object

JL.JL_ZZ_GL_AXI is referenced by following:

JL
VIEW - JL_ZZ_GL_AXI#

[top of page]

Table: JL_ZZ_GL_AXI_ACCOUNTS

Description: Runtime Inflation Adjustment Gain and Loss Account Ranges
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_GL_AXI_ACCOUNTS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS

[top of page]

JL.JL_ZZ_GL_AXI_ACCOUNTS does not reference any database object

JL.JL_ZZ_GL_AXI_ACCOUNTS is referenced by following:

JL
VIEW - JL_ZZ_GL_AXI_ACCOUNTS#

[top of page]

Table: JL_ZZ_GL_AXI_MODELS

Description: Accounting Models
Primary Key: JL_ZZ_GL_AXI_MODELS_PK
  1. MODEL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_GL_AXI_MODELS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
Foreign Keys to this table:
Foreign Key Column Foreign Table
JL_ZZ_GL_AXI_MODEL_RANGES.MODEL_ID JL_ZZ_GL_AXI_MODELS

[top of page]

JL.JL_ZZ_GL_AXI_MODELS does not reference any database object

JL.JL_ZZ_GL_AXI_MODELS is referenced by following:

JL
VIEW - JL_ZZ_GL_AXI_MODELS#

[top of page]

Table: JL_ZZ_GL_AXI_MODEL_RANGES

Description: Accounting Model Account Ranges
Foreign Keys from this table:
Foreign Key Column Foreign Table
JL_ZZ_GL_AXI_MODEL_RANGES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS
JL_ZZ_GL_AXI_MODEL_RANGES.MODEL_ID JL_ZZ_GL_AXI_MODELS

[top of page]

JL.JL_ZZ_GL_AXI_MODEL_RANGES does not reference any database object

JL.JL_ZZ_GL_AXI_MODEL_RANGES is referenced by following:

JL
VIEW - JL_ZZ_GL_AXI_MODEL_RANGES#

[top of page]

Table: JL_ZZ_GL_AXI_TMP

Description: Temporary Table For Inflation Adjustment Report
Primary Key: JL_ZZ_GL_AXI_TMP_PK
  1. PERIOD_FROM
  2. CODE_COMBINATION_ID
  3. AXI_RUN_ID

[top of page]

JL.JL_ZZ_GL_AXI_TMP does not reference any database object

JL.JL_ZZ_GL_AXI_TMP is referenced by following:

JL
VIEW - JL_ZZ_GL_AXI_TMP#

[top of page]

Table: JL_ZZ_INFO_T

Description: JL_ZZ_INFO_T is temporary table

[top of page]

JL.JL_ZZ_INFO_T does not reference any database object

JL.JL_ZZ_INFO_T is referenced by following:

JL
VIEW - JL_ZZ_INFO_T#

[top of page]

View: AS_TAX_LINES_SUMMARY_VBR

[top of page]

APPS.AS_TAX_LINES_SUMMARY_VBR references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.AS_TAX_LINES_SUMMARY_VBR is not referenced by any database object

[top of page]

View: JL_AR_AR_CUST_TRX_TYPES_V

[top of page]

APPS.JL_AR_AR_CUST_TRX_TYPES_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - RA_CUST_TRX_TYPES
SYNONYM - RA_TERMS

APPS.JL_AR_AR_CUST_TRX_TYPES_V is not referenced by any database object

[top of page]

View: JL_AR_AR_DOC_LETTER_V

[top of page]

APPS.JL_AR_AR_DOC_LETTER_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JL_AR_AR_DOC_LETTER

APPS.JL_AR_AR_DOC_LETTER_V is not referenced by any database object

[top of page]

View: JL_BR_AP_COLLECTION_DOCS_V

[top of page]

APPS.JL_BR_AP_COLLECTION_DOCS_V references the following:

APPS
VIEW - CE_BANK_BRANCHES_V
PACKAGE - FND_GLOBAL
SYNONYM - JL_BR_AP_COLLECTION_DOCS
VIEW - PO_VENDORS
- PO_VENDOR_SITES

APPS.JL_BR_AP_COLLECTION_DOCS_V is not referenced by any database object

[top of page]

View: JL_BR_AP_CONSOLID_INVOICES_V

[top of page]

APPS.JL_BR_AP_CONSOLID_INVOICES_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - JL_BR_AP_CONSOLID_INVOICES
VIEW - PO_VENDORS
- PO_VENDOR_SITES
- PO_LOOKUP_CODES
- AP_TERMS

APPS.JL_BR_AP_CONSOLID_INVOICES_V is not referenced by any database object

[top of page]

View: JL_BR_AP_INT_COLLECT_EXT_V

[top of page]

APPS.JL_BR_AP_INT_COLLECT_EXT_V references the following:

APPS
VIEW - CE_BANK_BRANCHES_V
VIEW - FND_CURRENCIES_VL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JL_BR_AP_INT_COLLECT_EXT

APPS.JL_BR_AP_INT_COLLECT_EXT_V is not referenced by any database object

[top of page]

View: JL_BR_AP_INVOICES_SHIP_V

[top of page]

APPS.JL_BR_AP_INVOICES_SHIP_V references the following:

APPS
SYNONYM - AP_INVOICES
- AP_TERMS

APPS.JL_BR_AP_INVOICES_SHIP_V is not referenced by any database object

[top of page]

View: JL_BR_AP_SICI_INVOICES_TN_V

[top of page]

APPS.JL_BR_AP_SICI_INVOICES_TN_V references the following:

APPS
SYNONYM - AP_INVOICES
SYNONYM - JL_BR_AP_CONSOLID_INVOICES

APPS.JL_BR_AP_SICI_INVOICES_TN_V is not referenced by any database object

[top of page]

View: JL_BR_AP_SICI_INVOICES_V

[top of page]

APPS.JL_BR_AP_SICI_INVOICES_V references the following:

APPS
SYNONYM - AP_INVOICES
SYNONYM - JL_BR_AP_CONSOLID_INVOICES

APPS.JL_BR_AP_SICI_INVOICES_V is not referenced by any database object

[top of page]

View: JL_BR_AR_BANK_RETURNS_V

[top of page]

APPS.JL_BR_AR_BANK_RETURNS_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - JL_BR_AR_BANK_OCCURRENCES
SYNONYM - JL_BR_AR_BANK_RETURNS

APPS.JL_BR_AR_BANK_RETURNS_V is not referenced by any database object

[top of page]

View: JL_BR_AR_BORDEROS_SAB_V

[top of page]

APPS.JL_BR_AR_BORDEROS_SAB_V references the following:

APPS
SYNONYM - AP_PAYMENT_PROGRAMS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JL_BR_AR_BORDEROS

APPS.JL_BR_AR_BORDEROS_SAB_V is not referenced by any database object

[top of page]

View: JL_BR_AR_BORDEROS_V

[top of page]

APPS.JL_BR_AR_BORDEROS_V references the following:

APPS
SYNONYM - AP_PAYMENT_PROGRAMS
SYNONYM - AR_SYSTEM_PARAMETERS
SYNONYM - CE_BANK_ACCOUNTS
SYNONYM - CE_BANK_ACCT_USES_ALL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - HZ_CODE_ASSIGNMENTS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - JL_BR_AR_BORDEROS

APPS.JL_BR_AR_BORDEROS_V is not referenced by any database object

[top of page]

View: JL_BR_AR_COLLECTION_DOCS_IOB_V

[top of page]

APPS.JL_BR_AR_COLLECTION_DOCS_IOB_V references the following:

APPS
SYNONYM - CE_BANK_ACCOUNTS
SYNONYM - CE_BANK_ACCT_USES_ALL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - HZ_CODE_ASSIGNMENTS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - JL_BR_AR_BANK_INSTRUCTIONS
SYNONYM - JL_BR_AR_BORDEROS_ALL
SYNONYM - JL_BR_AR_COLLECTION_DOCS

APPS.JL_BR_AR_COLLECTION_DOCS_IOB_V is not referenced by any database object

[top of page]

View: JL_BR_AR_COLL_DOCS_SAB_V

[top of page]

APPS.JL_BR_AR_COLL_DOCS_SAB_V references the following:

APPS
SYNONYM - AR_BATCH_SOURCES
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIPT_METHODS
SYNONYM - CE_BANK_ACCOUNTS
SYNONYM - CE_BANK_ACCT_USES_ALL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - HZ_CODE_ASSIGNMENTS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - JL_BR_AR_BANK_INSTRUCTIONS
SYNONYM - JL_BR_AR_COLLECTION_DOCS
SYNONYM - RA_CUSTOMER_TRX_ALL

APPS.JL_BR_AR_COLL_DOCS_SAB_V is not referenced by any database object

[top of page]

View: JL_BR_AR_COLL_DOC_DISTS_L_V

[top of page]

APPS.JL_BR_AR_COLL_DOC_DISTS_L_V references the following:

APPS
SYNONYM - JL_BR_AR_DISTRIBUTNS_ALL
SYNONYM - JL_BR_AR_OCCURRENCE_DOCS_ALL

APPS.JL_BR_AR_COLL_DOC_DISTS_L_V is not referenced by any database object

[top of page]

View: JL_BR_AR_COLL_OCC_DOCS_H_V

[top of page]

APPS.JL_BR_AR_COLL_OCC_DOCS_H_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - JL_BR_AR_BANK_OCCURRENCES
SYNONYM - JL_BR_AR_BORDEROS_ALL
SYNONYM - JL_BR_AR_COLLECTION_DOCS_ALL
SYNONYM - JL_BR_AR_OCCURRENCE_DOCS_ALL
SYNONYM - JL_BR_AR_SELECT_ACCOUNTS_ALL
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - XLA_EVENTS

APPS.JL_BR_AR_COLL_OCC_DOCS_H_V is not referenced by any database object

[top of page]

View: JL_BR_AR_OCCURRENCE_DOCS_V

[top of page]

APPS.JL_BR_AR_OCCURRENCE_DOCS_V references the following:

APPS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - JL_BR_AR_BANK_OCCURRENCES
SYNONYM - JL_BR_AR_BORDEROS_ALL
SYNONYM - JL_BR_AR_OCCURRENCE_DOCS_ALL

APPS.JL_BR_AR_OCCURRENCE_DOCS_V is not referenced by any database object

[top of page]

View: JL_BR_AR_OCC_DOCS_ALL_MRC_V

[top of page]

APPS.JL_BR_AR_OCC_DOCS_ALL_MRC_V references the following:

APPS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - JL_BR_AR_MC_OCC_DOCS
SYNONYM - JL_BR_AR_OCCURRENCE_DOCS

APPS.JL_BR_AR_OCC_DOCS_ALL_MRC_V is not referenced by any database object

[top of page]

View: JL_BR_AR_OCC_DOCS_MRC_V

[top of page]

APPS.JL_BR_AR_OCC_DOCS_MRC_V references the following:

APPS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - JL_BR_AR_MC_OCC_DOCS
SYNONYM - JL_BR_AR_OCCURRENCE_DOCS_ALL

APPS.JL_BR_AR_OCC_DOCS_MRC_V is not referenced by any database object

[top of page]

View: JL_BR_AR_PAYMENT_SCH_IOB_V

[top of page]

APPS.JL_BR_AR_PAYMENT_SCH_IOB_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - CE_BANK_ACCT_USES_ALL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - JL_BR_AR_BORDEROS
SYNONYM - JL_BR_AR_COLLECTION_DOCS_ALL
SYNONYM - RA_CUSTOMER_TRX_ALL

APPS.JL_BR_AR_PAYMENT_SCH_IOB_V is not referenced by any database object

[top of page]

View: JL_BR_AR_RCT_MTHD_1_V

[top of page]

APPS.JL_BR_AR_RCT_MTHD_1_V references the following:

APPS
SYNONYM - AR_RECEIPT_CLASSES
SYNONYM - AR_RECEIPT_METHODS
SYNONYM - AR_RECEIPT_METHOD_ACCOUNTS
SYNONYM - CE_BANK_ACCOUNTS
SYNONYM - CE_BANK_ACCT_USES_ALL
SYNONYM - RA_CUST_RECEIPT_METHODS
- HR_OPERATING_UNITS

APPS.JL_BR_AR_RCT_MTHD_1_V is not referenced by any database object

[top of page]

View: JL_BR_AR_RCT_MTHD_2_V

[top of page]

APPS.JL_BR_AR_RCT_MTHD_2_V references the following:

APPS
SYNONYM - AR_RECEIPT_CLASSES
SYNONYM - AR_RECEIPT_METHODS
SYNONYM - AR_RECEIPT_METHOD_ACCOUNTS
SYNONYM - CE_BANK_ACCT_USES_ALL
SYNONYM - RA_CUST_RECEIPT_METHODS

APPS.JL_BR_AR_RCT_MTHD_2_V is not referenced by any database object

[top of page]

View: JL_BR_AR_REC_MET_ACCTS_EXT_R_V

[top of page]

APPS.JL_BR_AR_REC_MET_ACCTS_EXT_R_V references the following:

APPS
SYNONYM - JL_BR_AR_REC_MET_ACCTS_EXT

APPS.JL_BR_AR_REC_MET_ACCTS_EXT_R_V is not referenced by any database object

[top of page]

View: JL_BR_AR_REC_MET_ACCTS_EXT_V

[top of page]

APPS.JL_BR_AR_REC_MET_ACCTS_EXT_V references the following:

APPS
SYNONYM - AP_PAYMENT_PROGRAMS
SYNONYM - AR_BATCH_SOURCES
SYNONYM - AR_RECEIPT_CLASSES
SYNONYM - AR_RECEIPT_METHODS
SYNONYM - AR_RECEIVABLES_TRX_ALL
SYNONYM - CE_BANK_ACCOUNTS
SYNONYM - CE_BANK_ACCT_USES_ALL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - JL_BR_AR_BANK_INSTRUCTIONS
SYNONYM - JL_BR_AR_REC_MET_ACCTS_EXT_ALL

APPS.JL_BR_AR_REC_MET_ACCTS_EXT_V is not referenced by any database object

[top of page]

View: JL_BR_AR_RET_INTERFACE_EXT_V

[top of page]

APPS.JL_BR_AR_RET_INTERFACE_EXT_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - JL_BR_AR_BANK_OCCURRENCES
SYNONYM - JL_BR_AR_RET_INTERFACE_EXT

APPS.JL_BR_AR_RET_INTERFACE_EXT_V is not referenced by any database object

[top of page]

View: JL_BR_AR_RET_INTER_V

[top of page]

APPS.JL_BR_AR_RET_INTER_V references the following:

APPS
SYNONYM - JL_BR_AR_RET_INTERFACE

APPS.JL_BR_AR_RET_INTER_V is not referenced by any database object

[top of page]

View: JL_BR_AR_SELECT_ACCOUNTS_V

[top of page]

APPS.JL_BR_AR_SELECT_ACCOUNTS_V references the following:

APPS
SYNONYM - AR_BATCH_SOURCES
SYNONYM - CE_BANK_ACCOUNTS
VIEW - CE_BANK_ACCT_USES
PACKAGE - FND_ACCESS_CONTROL_UTIL
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
SYNONYM - HZ_CODE_ASSIGNMENTS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - JL_BR_AR_BANK_INSTRUCTIONS
SYNONYM - JL_BR_AR_SELECT_ACCOUNTS
PACKAGE - XTR_USER_ACCESS
- MO_GLOBAL

APPS.JL_BR_AR_SELECT_ACCOUNTS_V is not referenced by any database object

[top of page]

View: JL_BR_AR_SELECT_CONTROLS_V

[top of page]

APPS.JL_BR_AR_SELECT_CONTROLS_V references the following:

APPS
SYNONYM - AR_RECEIPT_METHODS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JL_BR_AR_SELECT_CONTROLS
SYNONYM - RA_CUST_TRX_TYPES

APPS.JL_BR_AR_SELECT_CONTROLS_V is not referenced by any database object

[top of page]

View: JL_CO_FA_AEL_GL_V

[top of page]

APPS.JL_CO_FA_AEL_GL_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_LOOKUPS
SYNONYM - FA_SYSTEM_CONTROLS
SYNONYM - FA_TRANSACTION_HEADERS
SYNONYM - GL_IMPORT_REFERENCES
VIEW - GL_SETS_OF_BOOKS
SYNONYM - JL_CO_FA_ADJUSTMENTS
APPS.JL_CO_FA_AEL_GL_V is referenced by following:

APPS
VIEW - XLA_JL_FA_AEL_GL_V

[top of page]

View: JL_CO_FA_AEL_SL_V

[top of page]

APPS.JL_CO_FA_AEL_SL_V references the following:

APPS
SYNONYM - FA_ADDITIONS
SYNONYM - FA_ADJUSTMENTS
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_INQUIRY_TRX_GT
SYNONYM - FA_LOOKUPS
SYNONYM - FA_SYSTEM_CONTROLS
SYNONYM - FA_TRANSACTION_HEADERS
VIEW - GL_SETS_OF_BOOKS
SYNONYM - JL_CO_FA_ADJUSTMENTS
SYNONYM - XLA_AE_HEADERS
SYNONYM - XLA_AE_LINES
SYNONYM - XLA_DISTRIBUTION_LINKS
APPS.JL_CO_FA_AEL_SL_V is referenced by following:

APPS
VIEW - XLA_JL_FA_AEL_SL_V

[top of page]

View: JL_CO_FA_APPRAISAL_BOOKS_V

[top of page]

APPS.JL_CO_FA_APPRAISAL_BOOKS_V references the following:

APPS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - JL_CO_FA_APPRAISAL_BOOKS

APPS.JL_CO_FA_APPRAISAL_BOOKS_V is not referenced by any database object

[top of page]

View: JL_CO_FA_ASSET_APPRS_V

[top of page]

APPS.JL_CO_FA_ASSET_APPRS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JL_CO_FA_ASSET_APPRS
PACKAGE - JL_ZZ_FA_FUNCTIONS_PKG

APPS.JL_CO_FA_ASSET_APPRS_V is not referenced by any database object

[top of page]

View: JL_CO_GL_ACCOUNTS_V

[top of page]

APPS.JL_CO_GL_ACCOUNTS_V references the following:

APPS
SYNONYM - FND_APPLICATION
SYNONYM - FND_FLEX_VALUES
SYNONYM - FND_FLEX_VALUES_TL
SYNONYM - FND_ID_FLEX_SEGMENTS
SYNONYM - FND_SEGMENT_ATTRIBUTE_VALUES
- GL_SETS_OF_BOOKS

APPS.JL_CO_GL_ACCOUNTS_V is not referenced by any database object

[top of page]

View: JL_CO_GL_BALANCES_V

[top of page]

APPS.JL_CO_GL_BALANCES_V references the following:

APPS
SYNONYM - JL_CO_GL_BALANCES

APPS.JL_CO_GL_BALANCES_V is not referenced by any database object

[top of page]

View: JL_CO_GL_NIT_ACCTS_V

[top of page]

APPS.JL_CO_GL_NIT_ACCTS_V references the following:

APPS
SYNONYM - FND_FLEX_VALUES
VIEW - FND_FLEX_VALUES_VL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JL_CO_GL_NIT_ACCTS

APPS.JL_CO_GL_NIT_ACCTS_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_PO_TX_FSC_CLS_V

[top of page]

APPS.JL_ZZ_AR_PO_TX_FSC_CLS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - JL_ZZ_AR_TX_FSC_CLS_ALL
VIEW - ORG_ORGANIZATION_DEFINITIONS

APPS.JL_ZZ_AR_PO_TX_FSC_CLS_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_PO_TX_TXN_NAT_V

[top of page]

APPS.JL_ZZ_AR_PO_TX_TXN_NAT_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - JL_ZZ_AR_TX_ATT_CLS_ALL
VIEW - ORG_ORGANIZATION_DEFINITIONS
- PO_LOOKUP_CODES

APPS.JL_ZZ_AR_PO_TX_TXN_NAT_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_ATTCLS_VAL_V

[top of page]

APPS.JL_ZZ_AR_TX_ATTCLS_VAL_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - JL_ZZ_AR_TX_ATT_CLS
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
PACKAGE - JL_ZZ_AR_TX_LIB_PKG

APPS.JL_ZZ_AR_TX_ATTCLS_VAL_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_ATT_CLS_LOOKUP_V

[top of page]

APPS.JL_ZZ_AR_TX_ATT_CLS_LOOKUP_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES

APPS.JL_ZZ_AR_TX_ATT_CLS_LOOKUP_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_ATT_CLS_V

[top of page]

APPS.JL_ZZ_AR_TX_ATT_CLS_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - JL_ZZ_AR_TX_ATT_CLS
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
PACKAGE - JL_ZZ_AR_TX_LIB_PKG

APPS.JL_ZZ_AR_TX_ATT_CLS_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_ATT_VAL_V

[top of page]

APPS.JL_ZZ_AR_TX_ATT_VAL_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - JL_ZZ_AR_TX_ATT_VAL_ALL
PACKAGE - JL_ZZ_AR_TX_LIB_PKG
APPS.JL_ZZ_AR_TX_ATT_VAL_V is referenced by following:

APPS
VIEW - JL_ZZ_AR_TX_NAT_RAT_V

[top of page]

View: JL_ZZ_AR_TX_CATEGRY

[top of page]

APPS.JL_ZZ_AR_TX_CATEGRY references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JL_ZZ_AR_TX_CATEG

APPS.JL_ZZ_AR_TX_CATEGRY is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_CATEGRY_V

[top of page]

APPS.JL_ZZ_AR_TX_CATEGRY_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - AR_VAT_TAX
SYNONYM - AR_VAT_TAX_ALL_B
SYNONYM - JL_ZZ_AR_TX_CATEG
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
PACKAGE - JL_ZZ_AR_TX_LIB_PKG

APPS.JL_ZZ_AR_TX_CATEGRY_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_CAT_ATT_TN_V

[top of page]

APPS.JL_ZZ_AR_TX_CAT_ATT_TN_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS
SYNONYM - JL_ZZ_AR_TX_CATEG
SYNONYM - JL_ZZ_AR_TX_CAT_ATT
PACKAGE - JL_ZZ_AR_TX_LIB_PKG

APPS.JL_ZZ_AR_TX_CAT_ATT_TN_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_CAT_ATT_V

[top of page]

APPS.JL_ZZ_AR_TX_CAT_ATT_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
SYNONYM - JL_ZZ_AR_TX_CAT_ATT
PACKAGE - JL_ZZ_AR_TX_LIB_PKG

APPS.JL_ZZ_AR_TX_CAT_ATT_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_CAT_DTL_V

[top of page]

APPS.JL_ZZ_AR_TX_CAT_DTL_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - AR_VAT_TAX_ALL_B
SYNONYM - JL_ZZ_AR_TX_CAT_DTL

APPS.JL_ZZ_AR_TX_CAT_DTL_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_CUS_CLS_V

[top of page]

APPS.JL_ZZ_AR_TX_CUS_CLS_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
SYNONYM - JL_ZZ_AR_TX_CUS_CLS
PACKAGE - JL_ZZ_AR_TX_LIB_PKG

APPS.JL_ZZ_AR_TX_CUS_CLS_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_EXC_CUS_V

[top of page]

APPS.JL_ZZ_AR_TX_EXC_CUS_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - AR_VAT_TAX
SYNONYM - AR_VAT_TAX_ALL_B
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
SYNONYM - JL_ZZ_AR_TX_EXC_CUS

APPS.JL_ZZ_AR_TX_EXC_CUS_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_EXC_FSC_V

[top of page]

APPS.JL_ZZ_AR_TX_EXC_FSC_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - AR_VAT_TAX
SYNONYM - AR_VAT_TAX_ALL_B
SYNONYM - HZ_GEOGRAPHIES
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
SYNONYM - JL_ZZ_AR_TX_EXC_FSC
PACKAGE - JL_ZZ_AR_TX_LIB_PKG

APPS.JL_ZZ_AR_TX_EXC_FSC_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_EXC_ITM_V

[top of page]

APPS.JL_ZZ_AR_TX_EXC_ITM_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - AR_VAT_TAX
SYNONYM - AR_VAT_TAX_ALL_B
SYNONYM - HZ_GEOGRAPHIES
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
SYNONYM - JL_ZZ_AR_TX_EXC_ITM
SYNONYM - MTL_SYSTEM_ITEMS

APPS.JL_ZZ_AR_TX_EXC_ITM_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_FSC_CLS_V

[top of page]

APPS.JL_ZZ_AR_TX_FSC_CLS_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - AR_VAT_TAX
SYNONYM - AR_VAT_TAX_ALL_B
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
SYNONYM - JL_ZZ_AR_TX_FSC_CLS

APPS.JL_ZZ_AR_TX_FSC_CLS_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_FSC_LOOKUP_V

[top of page]

APPS.JL_ZZ_AR_TX_FSC_LOOKUP_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL

APPS.JL_ZZ_AR_TX_FSC_LOOKUP_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_GROUPS_V

[top of page]

APPS.JL_ZZ_AR_TX_GROUPS_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - AR_VAT_TAX
SYNONYM - AR_VAT_TAX_ALL_B
SYNONYM - JL_ZZ_AR_TX_CATEG
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
SYNONYM - JL_ZZ_AR_TX_GROUPS
PACKAGE - JL_ZZ_AR_TX_LIB_PKG

APPS.JL_ZZ_AR_TX_GROUPS_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_LGL_MSG_V

[top of page]

APPS.JL_ZZ_AR_TX_LGL_MSG_V references the following:

APPS
SYNONYM - AR_MEMO_LINES
VIEW - AR_STANDARD_TEXT_VL
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_GEOGRAPHIES
SYNONYM - HZ_PARTIES
SYNONYM - JL_ZZ_AR_TX_EXC_FSC_ALL
SYNONYM - JL_ZZ_AR_TX_EXC_ITM_ALL
SYNONYM - JL_ZZ_AR_TX_FSC_CLS_ALL
SYNONYM - JL_ZZ_AR_TX_LGL_MSG
PACKAGE - JL_ZZ_AR_TX_LIB_PKG
SYNONYM - JL_ZZ_AR_TX_LOCN_ALL
SYNONYM - JL_ZZ_AR_TX_RULES_ALL
SYNONYM - MTL_SYSTEM_ITEMS_B
- MO_GLOBAL
- HR_ORGANIZATION_UNITS

APPS.JL_ZZ_AR_TX_LGL_MSG_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_LGM_V

[top of page]

APPS.JL_ZZ_AR_TX_LGM_V references the following:

APPS
VIEW - AR_STANDARD_TEXT_VL
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - JL_ZZ_AR_TX_LGL_MSG
PACKAGE - JL_ZZ_AR_TX_LIB_PKG

APPS.JL_ZZ_AR_TX_LGM_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_LOCN_V

[top of page]

APPS.JL_ZZ_AR_TX_LOCN_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - AR_VAT_TAX
SYNONYM - AR_VAT_TAX_ALL_B
SYNONYM - HZ_GEOGRAPHIES
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
SYNONYM - JL_ZZ_AR_TX_LOCN

APPS.JL_ZZ_AR_TX_LOCN_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_NAT_RAT_V

[top of page]

APPS.JL_ZZ_AR_TX_NAT_RAT_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - AR_VAT_TAX
SYNONYM - AR_VAT_TAX_ALL
VIEW - JL_ZZ_AR_TX_ATT_VAL_V
PACKAGE - JL_ZZ_AR_TX_LIB_PKG
SYNONYM - JL_ZZ_AR_TX_NAT_RAT

APPS.JL_ZZ_AR_TX_NAT_RAT_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_RULES_V

[top of page]

APPS.JL_ZZ_AR_TX_RULES_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - JL_ZZ_AR_TX_CATEG_ALL
PACKAGE - JL_ZZ_AR_TX_LIB_PKG
SYNONYM - JL_ZZ_AR_TX_RULES
SYNONYM - RA_CUST_TRX_TYPES_ALL

APPS.JL_ZZ_AR_TX_RULES_V is not referenced by any database object

[top of page]

View: JL_ZZ_AR_TX_SCHEDULES_V

[top of page]

APPS.JL_ZZ_AR_TX_SCHEDULES_V references the following:

APPS
SYNONYM - AR_SYSTEM_PARAMETERS_ALL
SYNONYM - AR_VAT_TAX_ALL_B
SYNONYM - JL_ZZ_AR_TX_SCHEDULES

APPS.JL_ZZ_AR_TX_SCHEDULES_V is not referenced by any database object

[top of page]

View: JL_ZZ_FA_ADJ_SUMMARY_V

[top of page]

APPS.JL_ZZ_FA_ADJ_SUMMARY_V references the following:

APPS
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_DEPRN_SUMMARY
PACKAGE - JL_ZZ_FA_CALC_ADJUSTMENT_PKG
- FA_ADDITIONS

APPS.JL_ZZ_FA_ADJ_SUMMARY_V is not referenced by any database object

[top of page]

View: JL_ZZ_FA_BOOKS_PERIODS_V

[top of page]

APPS.JL_ZZ_FA_BOOKS_PERIODS_V references the following:

APPS
SYNONYM - FA_ASSET_HISTORY
SYNONYM - FA_BOOKS
SYNONYM - FA_BOOK_CONTROLS
SYNONYM - FA_CALENDAR_PERIODS
SYNONYM - FA_DEPRN_PERIODS
SYNONYM - FA_TRANSACTION_HEADERS
- FA_ADDITIONS

APPS.JL_ZZ_FA_BOOKS_PERIODS_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract