You are browsing the archive for JL.

by oracleguru

Oracle Latin America Localizations Tables

ORACLE APPS COMMUNITY > Tutorial > JL

Oracle Latin America Localizations – List of database tables:

  • JL_AR_AP_AWT_CERTIF_ALL
  • JL_AR_AP_PROVINCES
  • JL_AR_AP_SUP_AWT_CR_LTS
  • JL_AR_AP_TRX_DGI_CODES
  • JL_AR_AR_DOC_LETTER_ALL
  • JL_AR_FA_EXHIBIT_GROUPS
  • JL_AR_FA_EXHIBIT_REPORT
  • JL_BR_AP_COLLECTION_DOCS_ALL
  • JL_BR_AP_CONSOLID_INVOICES_ALL
  • JL_BR_AP_INT_COLLECTION_TMP
  • JL_BR_AP_INT_COLLECT_ALL
  • JL_BR_AP_INT_COLLECT_EXT_ALL
  • JL_BR_AP_OPERATIONS
  • JL_BR_AP_TAX_CALENDAR_HEADERS
  • JL_BR_AP_TAX_CALENDAR_LINES
  • JL_BR_AR_BANK_INSTRUCTIONS
  • JL_BR_AR_BANK_OCCURRENCES
  • JL_BR_AR_BANK_RETURNS_ALL
  • JL_BR_AR_BORDEROS_ALL
  • JL_BR_AR_COLLECTION_DOCS_ALL
  • JL_BR_AR_COMP_INV_ALL
  • JL_BR_AR_CUST_INT_ERR
  • JL_BR_AR_DISTRIBUTNS_ALL
  • JL_BR_AR_MC_OCC_DOCS
  • JL_BR_AR_OCCURRENCE_DOCS_ALL
  • JL_BR_AR_PAY_SCHED_AUX
  • JL_BR_AR_POSTING_TMP
  • JL_BR_AR_REC_MET_ACCTS_EXT_ALL
  • JL_BR_AR_REMIT_BORDEROS_ALL
  • JL_BR_AR_RET_INTERFACE_ALL
  • JL_BR_AR_RET_INTERFACE_EXT_ALL
  • JL_BR_AR_RET_INTERFACE_TMP
  • JL_BR_AR_SELECT_ACCOUNTS_ALL
  • JL_BR_AR_SELECT_CONTROLS_ALL
  • JL_BR_AR_TX_CATEG_ALL
  • JL_BR_AR_TX_EXC_FSC_ALL
  • JL_BR_AR_TX_EXC_ITM_ALL
  • JL_BR_AR_TX_FSC_CLS_ALL
  • JL_BR_AR_TX_GROUP_ALL
  • JL_BR_AR_TX_LOCN_ALL
  • JL_BR_AR_TX_RULES_ALL
  • JL_BR_BALANCES_ALL
  • JL_BR_COMPANY_INFOS
  • JL_BR_GL_LEGAL_REP
  • JL_BR_JOURNALS_ALL
  • JL_BR_LOCAL_HOLIDAY_DATES
  • JL_BR_LOCAL_HOLIDAY_SETS
  • JL_BR_PO_FISC_CLASSIF_ALL
  • JL_BR_PO_FUNCTIONAL_MATRIX
  • JL_BR_PO_TAX_EXCEPTIONS_ALL
  • JL_BR_PO_TAX_EXC_ITEMS_ALL
  • JL_BR_PO_TAX_LOCATIONS_ALL
  • JL_BR_TAX_LMSG_ALL
  • JL_CANCEL_GT
  • JL_CL_AP_AWT_CERT
  • JL_CL_GL_ACCT_HIER_TMP
  • JL_CO_FA_ADJUSTMENTS
  • JL_CO_FA_APPRAISALS
  • JL_CO_FA_APPRAISAL_BOOKS
  • JL_CO_FA_ASSET_APPRS
  • JL_CO_FA_PURGE
  • JL_CO_GL_BALANCES
  • JL_CO_GL_CONC_CTRL
  • JL_CO_GL_CONC_ERRS
  • JL_CO_GL_MG_CONFIGS
  • JL_CO_GL_MG_HEADERS
  • JL_CO_GL_MG_LINES
  • JL_CO_GL_MG_LITERALS
  • JL_CO_GL_MG_RANGES
  • JL_CO_GL_NITS
  • JL_CO_GL_NIT_ACCTS
  • JL_CO_GL_TRX
  • JL_MX_FA_ISR_IMPAC
  • JL_REMIT3_GT
  • JL_REMIT_GT
  • JL_ZZ_AP_AWT_TYPES
  • JL_ZZ_AP_COMP_AWT_TYPES
  • JL_ZZ_AP_INV_DIS_WH_ALL
  • JL_ZZ_AP_INV_DIS_WH_ALL_T
  • JL_ZZ_AP_SUPP_AWT_TYPES
  • JL_ZZ_AP_SUP_AWT_CD_ALL
  • JL_ZZ_AR_TX_ATT_CLS_ALL
  • JL_ZZ_AR_TX_ATT_VAL_ALL
  • JL_ZZ_AR_TX_CATEG_ALL
  • JL_ZZ_AR_TX_CAT_ATT_ALL
  • JL_ZZ_AR_TX_CAT_DTL_ALL
  • JL_ZZ_AR_TX_CUS_CLS_ALL
  • JL_ZZ_AR_TX_EXC_CUS_ALL
  • JL_ZZ_AR_TX_EXC_FSC_ALL
  • JL_ZZ_AR_TX_EXC_ITM_ALL
  • JL_ZZ_AR_TX_FSC_CLS_ALL
  • JL_ZZ_AR_TX_GROUPS_ALL
  • JL_ZZ_AR_TX_LGL_MSG_ALL
  • JL_ZZ_AR_TX_LOCN_ALL
  • JL_ZZ_AR_TX_NAT_RAT_ALL
  • JL_ZZ_AR_TX_RULES_ALL
  • JL_ZZ_AR_TX_SCHEDULES_ALL
  • JL_ZZ_FA_RETIREMNT_ADJS
  • JL_ZZ_FA_RETIREMNT_JES
  • JL_ZZ_GL_AXI
  • JL_ZZ_GL_AXI_ACCOUNTS
  • JL_ZZ_GL_AXI_MODELS
  • JL_ZZ_GL_AXI_MODEL_RANGES
  • JL_ZZ_GL_AXI_TMP

Tags: No Comments »

by oracleguru

Latin America Localizations Forms

ORACLE APPS COMMUNITY > Tutorial > JL

Oracle Latin America Localizations Forms:

FORM SHORT CODE ORACLE FORM NAME
JLARFEAG Exhibit of Fixed Assets Groups
JLARPDTC Set up DGI transaction codes
JLARPPRO Set up provinces
JLARPWHL Enter supplier withholding credit letters
JLARRDOL VAT Document Letter Assignments
JLBRPACD Manual Association of Collection Documents
JLBRPCCD Imported Collection Documents
JLBRPECD Enter Collection Documents
JLBRPECI Enter Consolidated Invoices
JLBRPETC Define Tax Calendars
JLBRPOFC Define Operation Fiscal Codes
JLBRRCDB Correct Bank Returns
JLBRRCOI Complementary Invoice
JLBRRDBO Bank Occurrence Codes
JLBRRDIC Bank Instruction Codes
JLBRRDPM Define Global Receipt Method Accounts
JLBRREMR Bank Returns
JLBRRIOB Bank Occurrences
JLBRRPRB Post Bank Return
JLBRRSAB Create Bank Transfer Remittance Batches
JLBRRSBO Create Occurrences Remittance Batches
JLBRRSEB Format Remittance Batches
JLBRSDCI Define Company Information
JLBRSDLH Define Local Holidays Sets
JLBRUDFC Define Fiscal Classification Code
JLBRUDFM Define Tax Functional Matrix
JLBRUDTL Define Tax Locations
JLBRUTEF Define Tax Exceptions by FCC
JLBRUTEI Define Tax Exceptions by Items
JLCOFTAA Maintain Technical Appraisals
JLCOGLCA Define Control Accounts
JLCOGLIM Define Literals
JLCOGLTP Define Third Party Information
JLZZGAAM Accounting Models
JLZZGSUB Run Inflation Adjustments
JLZZPCWH Set up company withholding applicability
JLZZPDWT Set up withholding tax types
JLZZPIDW Define invoice distribution withholdings
JLZZPSWH Set up supplier withholding applicability
JLZZTATC Tax Condition Classes
JLZZTCAC Define Customer Site Tax Profile
JLZZTCAV Associate Tax Category with Conditions and Values
JLZZTCTD Tax Category Details
JLZZTCTG Tax Categories
JLZZTCTS Tax Category Schedules
JLZZTECS Tax Exceptions by Customer Site
JLZZTEFS Tax Exceptions by Fiscal Classification
JLZZTEIT Tax Exceptions by Items
JLZZTFSC Fiscal Classifications
JLZZTLMR Associate Tax Legal Messages
JLZZTLOC Tax Locations
JLZZTLTG Tax Groups
JLZZTTNR Tax Exceptions by Transaction Condition Values
JLZZTTXR Tax Rules
JLBRPSUP Define Participant Setup
JLBRPRSP Define Participant Relationship Setup
JLBRBKTP Define Bookkeeping Types
JLBREINV Electronic Invoice Attributes
JLBREISH Electronic Invoice Status History

Tags: No Comments »

by oracleguru

Views in Latin America Localizations Module

ORACLE APPS COMMUNITY > Tutorial > JL

List of views in Latin America Localizations Module

JL_AR_AR_CUST_TRX_TYPES_V
JL_AR_AR_DOC_LETTER_V
JL_AR_FA_EXHIBIT_GROUPS_DFV
JL_BR_AP_COLLECTION_DOCS_A_DFV
JL_BR_AP_COLLECTION_DOCS_V
JL_BR_AP_CONSOLID_INVOICES_V
JL_BR_AP_INT_COLLECT_ALL_DFV
JL_BR_AP_INT_COLLECT_EXT_A_DFV
JL_BR_AP_INT_COLLECT_EXT_V
JL_BR_AP_INVOICES_SHIP_V
JL_BR_AP_SICI_INVOICES_TN_V
JL_BR_AP_SICI_INVOICES_V
JL_BR_AR_BANK_INSTRUCTIONS_DFV
JL_BR_AR_BANK_OCCURRENCES_DFV
JL_BR_AR_BANK_RETURNS_V
JL_BR_AR_BORDEROS_SAB_V
JL_BR_AR_BORDEROS_V
JL_BR_AR_COLL_DOC_DISTS_L_V
JL_BR_AR_COLL_DOCS_SAB_V
JL_BR_AR_COLL_OCC_DOCS_H_V
JL_BR_AR_COLLECTION_DOCS_A_DFV
JL_BR_AR_COLLECTION_DOCS_IOB_V
JL_BR_AR_COMP_INV_ALL_DFV
JL_BR_AR_OCC_DOCS_ALL_MRC_V
JL_BR_AR_OCC_DOCS_MRC_V
JL_BR_AR_OCCURRENCE_DOCS_A_DFV
JL_BR_AR_OCCURRENCE_DOCS_V
JL_BR_AR_PAYMENT_SCH_IOB_V
JL_BR_AR_RCT_MTHD_1_V
JL_BR_AR_RCT_MTHD_2_V
JL_BR_AR_REC_MET_ACCTS_EXT_R_V
JL_BR_AR_REC_MET_ACCTS_EXT_V
JL_BR_AR_RET_INTER_V
JL_BR_AR_RET_INTERFACE_EXT_V
JL_BR_AR_SELECT_ACCOUNTS_A_DFV
JL_BR_AR_SELECT_ACCOUNTS_V
JL_BR_AR_SELECT_CONTROLS_A_DFV
JL_BR_AR_SELECT_CONTROLS_V
JL_BR_LOCAL_HOLIDAY_DATES_DFV
JL_BR_LOCAL_HOLIDAY_SETS_DFV
JL_CO_FA_AEL_GL_V
JL_CO_FA_AEL_SL_V
JL_CO_FA_APPRAISAL_BOOKS_V
JL_CO_FA_ASSET_APPRS_V
JL_CO_GL_ACCOUNTS_V
JL_CO_GL_BALANCES_V
JL_CO_GL_NIT_ACCTS_V
JL_ZZ_AR_PO_TX_FSC_CLS_V
JL_ZZ_AR_PO_TX_TXN_NAT_V
JL_ZZ_AR_TX_ATT_CLS_LOOKUP_V
JL_ZZ_AR_TX_ATT_CLS_V
JL_ZZ_AR_TX_ATT_VAL_V
JL_ZZ_AR_TX_ATTCLS_VAL_V
JL_ZZ_AR_TX_CAT_ATT_TN_V
JL_ZZ_AR_TX_CAT_ATT_V
JL_ZZ_AR_TX_CAT_DTL_V
JL_ZZ_AR_TX_CATEGRY
JL_ZZ_AR_TX_CATEGRY_V
JL_ZZ_AR_TX_CUS_CLS_V
JL_ZZ_AR_TX_EXC_CUS_V
JL_ZZ_AR_TX_EXC_FSC_V
JL_ZZ_AR_TX_EXC_ITM_V
JL_ZZ_AR_TX_FSC_CLS_V
JL_ZZ_AR_TX_FSC_LOOKUP_V
JL_ZZ_AR_TX_GROUPS_V
JL_ZZ_AR_TX_LGL_MSG_V
JL_ZZ_AR_TX_LGM_V
JL_ZZ_AR_TX_LOCN_V
JL_ZZ_AR_TX_NAT_RAT_V
JL_ZZ_AR_TX_RULES_V
JL_ZZ_AR_TX_SCHEDULES_V
JL_ZZ_FA_ADJ_SUMMARY_V
JL_ZZ_FA_BOOKS_PERIODS_V
JL_ZZ_GL_AXI_ACCOUNTS_DFV
JL_ZZ_GL_AXI_DFV
JL_ZZ_GL_AXI_MODEL_RANGES_DFV
JL_ZZ_GL_AXI_MODELS_DFV

Tags: No Comments »