JA Views (179)

JA - Asia/Pacific Localizations — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

ViewDescription
JAI_57F4_PO_V This view lists the Purchase orders and releases that can be sent for outside processing.
JAI_AEL_GL_V
JAI_AEL_SL_V
JAI_AP_BOE_AEL_GL_V
JAI_AP_BOE_AEL_SL_V
JAI_AP_BOE_AEL_V Base view of BOE
JAI_AP_MANUAL_AEL_GL_V
JAI_AP_MANUAL_AEL_SL_V
JAI_AP_MANUAL_AEL_V Base view of Manual entry
JAI_AP_MATCH_INV_TAX_V This view will be used to fetch the taxes for the invoices where are not Standalone invoices
JAI_AP_MATCH_TAXES_V
JAI_AP_ORG_TAN_V A dummy view
JAI_AP_SET_AEL_GL_V
JAI_AP_SET_AEL_SL_V
JAI_AP_SET_AEL_V Base view of service tax settlement
JAI_AP_STANDALONE_TAXES_V This view lists the taxes on a standalone AP Invoice
JAI_AP_STDIST_AEL_GL_V
JAI_AP_STDIST_AEL_SL_V
JAI_AP_STDIST_AEL_V Base view of service tax distribution UI
JAI_AP_STREVIEW_AEL_GL_V
JAI_AP_STREVIEW_AEL_SL_V
JAI_AP_ST_FORMS_DTL_GRPRCPT_V
JAI_AP_ST_MATCH_DTL_GRPRCPT_V
JAI_AP_TAXES_V View to fetch Taxes attached to a Standalone AP Invoice
JAI_AP_TDS_DEFAULT_SECTION_V
JAI_AP_TDS_DISTRIBUTION_V View for TDS Distributions
JAI_AP_TDS_F16_DTLS_V
JAI_AP_TDS_LE_NAME_V
JAI_AP_TDS_NULLSITE_THHOLD_V
JAI_AP_TDS_ORG_TAN_V
JAI_AP_TDS_SECTION_TAX_V
JAI_AP_TDS_SITE_V
JAI_AP_TDS_THHOLD_EXCEPTION_V
JAI_AP_TDS_THHOLD_LE_V View for obtaining Legal Entity
JAI_AP_TDS_THHOLD_VENDOR_V
JAI_AP_TDS_TH_PAN_TAN_V
JAI_AP_TDS_TH_VSITE_V
JAI_AP_TDS_VNDR_TYPE_V
JAI_AR_RG_BAL_V
JAI_AR_ST_MATCH_DTL_GRPISS_V
JAI_AR_TRX_AEL_GL_V
JAI_AR_TRX_AEL_SL_V
JAI_AR_TRX_AEL_V Base view of OFI AR transaction
JAI_AR_TRX_DETAILS_V
JAI_AR_TRX_DTLS_V
JAI_AR_TRX_TMP_E_LINE_V
JAI_BOE_ASBN_V
JAI_BOE_DETAILS_V
JAI_BOE_HEADERS_V
JAI_BOE_MATCHINGS_V
JAI_BOE_WRITEOFF_TAXES_V
JAI_CMN_BASE_CURRENCY_V
JAI_CMN_BOE_APPLIED_V
JAI_CMN_CESS_TRXS_V
JAI_CMN_CUSTOMERS_V
JAI_CMN_CUSTOMER_DTLS_V
JAI_CMN_CUSTOMER_SITES_V
JAI_CMN_CUST_ADDRESS_V
JAI_CMN_HR_LOCATIONS_V
JAI_CMN_ORG_DTLS_V
JAI_CMN_PLA_REGISTER_V
JAI_CMN_RG_23_II_V
JAI_CMN_RG_BALANCES_V
JAI_CMN_UOM_DTLS_V
JAI_CMN_VENDOR_ADDRESS_V
JAI_CMN_VENDOR_CUST_NAME_V A dummy view
JAI_CMN_VENDOR_NAME_V
JAI_CUSTOMERS_V OFI customer views
JAI_DTC_SCTN_ACCOUNT_MAPPING_V View for Section Account Mapping
JAI_EXCISE_INVNO_V A dummy view
JAI_FA_ASSETS_V
JAI_FA_AST_RETIR_INAYR_V
JAI_FBT_SETUP_HEADER_V This view is used to populate the header information in Fringe Benefit Tax Setup form
JAI_FBT_TAX_TYPE_V This view stores the FBT tax type information listing current 4 kinds of FBT taxes
JAI_FINYR_QUARTER_V View to provide values for the end date parameter for the fixed assets schedule report
JAI_IM_TAX_MAPPING_V This is a view based on the mapping table JAI_IM_TAX_MAPPING used to store the mapping relation between the external customer tax code and s
JAI_INV_INTERORG_AEL_GL_V
JAI_INV_INTERORG_AEL_SL_V
JAI_INV_INTERORG_AEL_V Base view of OFI inter org transfer UI
JAI_INV_RG1_AEL_GL_V
JAI_INV_RG1_AEL_SL_V
JAI_INV_RG1_AEL_V
JAI_INV_RG23_AEL_GL_V
JAI_INV_RG23_AEL_SL_V
JAI_INV_RG23_AEL_V Base view of RG23 Register
JAI_INV_RGCO_AEL_GL_V
JAI_INV_RGCO_AEL_SL_V
JAI_INV_RGCO_AEL_V Base view of RG consolidation
JAI_MASSTAXCHG_DOCNOS_V
JAI_MTL_CVAT_V This view lists the Excise related receipts for interorg transfer
JAI_OE_MATCH_LINES_V
JAI_OM_CUST_ADDRESS_V
JAI_OM_LC_MATCHING_V
JAI_OM_SHIP_AEL_GL_V
JAI_OM_SHIP_AEL_SL_V
JAI_OM_SHIP_AEL_V Base view of OFI ship confirm UI
JAI_OM_WSH_DELIVERIES_V
JAI_OM_WSH_DELIVERY_NAME_V
JAI_PLA_ENTRY_AEL_GL_V
JAI_PLA_ENTRY_AEL_SL_V
JAI_PLA_ENTRY_AEL_V Base view of PLA entry
JAI_PO_CURRENCY_CODE_V
JAI_PO_OSPM_AEL_GL_V
JAI_PO_OSPM_AEL_SL_V
JAI_PO_OSPM_AEL_V Base view of OSP manually entered
JAI_PO_OSP_DISP_AEL_GL_V
JAI_PO_OSP_DISP_AEL_SL_V
JAI_PO_OSP_DISP_AEL_V Base view of OSP
JAI_PO_RCV_TAXES_V View for PO RCV taxes
JAI_PO_REC_AEL_GL_V
JAI_PO_REC_AEL_SL_V
JAI_PO_REC_AEL_V Base view of PO receipt
JAI_PO_REC_CENVAT_AEL_GL_V
JAI_PO_REC_CENVAT_AEL_SL_V
JAI_PO_REC_CENVAT_AEL_V Fetches accounting entries for 'cenvat claim reversal' event
JAI_PO_REC_MTL_AEL_GL_V
JAI_PO_REC_MTL_AEL_SL_V
JAI_PO_REC_MTL_AEL_V Fetch accounting entries for Deliver event with Source 'Inventory India', Category 'MTL'
JAI_PO_REC_RMA_AEL_GL_V
JAI_PO_REC_RMA_AEL_SL_V
JAI_PO_REC_RMA_AEL_V Fetch accounting entries when third party is customer, to handle 'rma accounting event'
JAI_PO_REC_VAT_AEL_GL_V
JAI_PO_REC_VAT_AEL_SL_V
JAI_PO_REC_VAT_AEL_V Fetch accounting entries for 'vat claim' event
JAI_PO_REC_VENDOR_AEL_GL_V
JAI_PO_REC_VENDOR_AEL_SL_V
JAI_PO_REC_VENDOR_AEL_V Fetch accounting entries when third party is Vendor, to handle events: 'Receipt', 'Cenvat Claim', 'RTV', 'RTR', 'Deliver' 'Correction', 'BOE
JAI_PO_RFQQT_V
JAI_PO_SHIPMENT_DTLS_V
JAI_PO_SUMMARY_V This view will retrieve all the PO TYPES
JAI_PO_VENDOR_NAMES_V
JAI_PROJECT_INV_AEL_GL_V
JAI_PROJECT_INV_AEL_SL_V
JAI_PROJECT_INV_AEL_V Base view for projects
JAI_RCV_ACCNT_HDR_V
JAI_RCV_ACCOUNTING_V
JAI_RCV_ACCT_DIST_V
JAI_RCV_CLAIM_MODVAT_V
JAI_RCV_COSTING_V
JAI_RCV_RECEIVE_LINES_V
JAI_RCV_RGM_HEADERS_V
JAI_RCV_RGM_INSTALLMENT_V
JAI_RCV_RGM_TAX_V
JAI_RCV_RGM_TXNS_V
JAI_RCV_RG_AMOUNT_V
JAI_RCV_RG_QUANTITY_V
JAI_RCV_RTV_LINES_V
JAI_RCV_TAX_V
JAI_REGIME_TAX_TYPES_V
JAI_REPOEXT_V This view will retreive all the service tax transactions based on the transaction source
JAI_RGM_ITEM_ATTRIB_V
JAI_RGM_ORGANIZATIONS_V
JAI_RGM_ORG_REGNS_V
JAI_RGM_PARTY_REGNS_V
JAI_RGM_STL_BALANCES_V
JAI_RGM_THHOLD_REGIMES_V A dummy view
JAI_RGM_VAT_ORGANIZATIONS_V
JAI_RG_FUND_TRF_AEL_GL_V
JAI_RG_FUND_TRF_AEL_SL_V
JAI_RG_FUND_TRF_AEL_V
JAI_ST_FORMS_DTL_GRPISS_V
JAI_WCT_CERT_DTLS_V
JA_AU_ADDITIONS_ALLOCATIONS_V - Retrofitted
JA_AU_ADDITIONS_BOOKS_V - Retrofitted
JA_AU_BAL_CHG_DETAILS_V - Retrofitted
JA_AU_CAPITAL_VALUE_V - Retrofitted
JA_AU_FA_ADD_ADJ_V - Retrofitted
JA_AU_FA_BOOK_CONTROLS_V - Retrofitted
JA_AU_SOURCE_ADDITIONS_BOOKS_V - Retrofitted
JA_AU_SOURCE_ADDITIONS_V - Retrofitted
JA_AU_SUBINV_LOC_ASSOCS_V - Retrofitted
JA_CN_ACCOUNT_BALANCES_V
JA_CN_CFSBSV_V
JA_CN_LEDGER_LE_BANK_V
JA_CN_SYSTEM_BANK_PARAMS_ALL_V
JA_IN_RCV_JOURNALS A dummy view
JA_LOOKUPS Standard lookup codes for Quickcodes
JA_LOOKUP_TYPES Standard lookup types for Quickcodes
PA_COMMITMENTS_V This view overrides PA_COMMITMENTS_V provided by Projects to include Non Recoverable Taxes