1. The Forum has been upgraded to a modern and advanced system. Please read the announcement about this update.
  2. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

R12- AR Tables and Changes

Discussion in 'Oracle Apps Technical' started by Ramji, Feb 7, 2012.

  1. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    170
    Trophy Points:
    1,505
    Location:
    Nomad
    Here goes...
    AR R12 Tables
    New Tables
    Description of Change
    AR_REC_TRX_LE_DETAILS_ALL
    Added detail level table under AR_RECEIVABLES_TRX_ALL to record the relationship between a receivables activity and the sets of asset and liability tax codes by legal entity.
    AR_DEFERRAL_REASONS
    Revenue Deferral Reasons
    AR_DEFERRED_LINES_ALL
    Revenue Deferral Reasons
    AR_RDR_PARAMETERS_GT
    Revenue Deferral Reasons
    AR_REVIEWED_LINES_GT
    Revenue Deferral Reasons
    Changed Tables
    Table Name
    Description of Change
    RA_CUSTOMER_TRX_LINES_ALL
    Added numerous columns to support E-Business Tax and line-level Ship To, Added Payment extension identifier.
    AR_MEMO_LINES
    Added tax_product_category to support E-Business Tax uptake.
    AR_TRX_LINES_GT
    Added numerous columns to support E-Business Tax uptake, Added parent_line_id and deferral_exclusion_flag.
    AR_TRX_LINES_TMP_GT
    Added numerous columns to support E-Business Tax uptake, Added parent_line_id and deferral_exclusion_flag.
    AR_ARCHIVE_DETAIL
    Added numerous columns to support E-Business Tax and line-level Ship To,
    RA_BATCH_SOURCES_ALL
    Obsoleted invalid_tax_rate_rule column.
    HZ_CUST_SITE_USES
    Migrated tax_code, tax_header_level_flag, tax_reference, and tax_classification to ZX_PARTY_TAX_PROFILE and ZX_REGISTRATIONS tables.
    AR_CASH_RECEIPTS_ALL
    Added Payment extension identifier and obsoleted, approval_code,
    address_verification_code, payment_server_order_num, Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID, Added legal_entity_id column.
    AR_RECEIPT_METHODS
    Added Payment Channel Code and obsoleted, payment_type_code, merchant_ref, merchant_id, auto_print_program_id
    RA_CUSTOMER_TRX_ALL
    Added Payment extension identifier and Payment Attributes,
    obsoleted payment_server_order_num, approval_code, address_verification_code, Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID, Added legal_entity_id column.
    RA_INTERFACE_LINES_ALL
    Added Payment extension identifier and Payment Attributes, and obsoleted payment_server_order_num, approval_code, address_verification_code, Added legal_entity_id column, Added parent_line_id and deferral_exclusion_flag.
    AR_AUTOREC_EXCEPTIONS
    Renamed column REMIT_BANK_ACCT_ID to REMIT_BANK_ACCT_USE_ID
    AR_BATCHES_ALL
    Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_BATCH_SOURCES_ALL
    Renamed column DEFAULT_REMIT_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_INTERIM_CASH_RECEIPTS_ALL
    Renamed column REMITTANCE_BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_RECEIPT_METHOD_ACCOUNTS_ALL
    Renamed column BANK_ACCOUNT_ID to REMIT_BANK_ACCT_USE_ID
    AR_TRX_HEADER_GT
    Added legal_entity_id column
    AR_TRX_HEADER_TMP_GT
    Added legal_entity_id column
    AR_LINE_CONTS_ALL
    Added contingency_id as a foreign key to AR_DEFERRAL_REASONS
    AR_TRX_CONTINGENCIES_GT
    Added contingency_id, expiration_event_date and completed_flag.
    Obsolete Tables
    Table Name
    AR_TA_ASGN_TO_INT_ALL
    AR_TA_CASHAPP_OB_ALL
    AR_TA_CR_AGEN_INF_ALL
    AR_TA_CUST_HIER_CHILD
    AR_TA_CUST_HIER_PARNT
    AR_TA_CUST_INT_ALL
    AR_TA_CUST_TRXSTR_ALL
    AR_TA_DEDN_ASSGNS_ALL
    AR_TA_DEDN_INT_ALL
    AR_TA_DEDN_RELATE_ALL
    AR_TA_LEGACY_CUST_INT
    AR_TA_LEGACY_STAT_INT
    AR_TA_PAYMNT_HIST_ALL
    AR_TA_PROF_ASSGNT_ALL
    AR_TA_PROMOTIONS_ALL
    AR_TA_PROMOTIONS_INT
    AR_TA_PROM_CUST_ALL
    AR_TA_PROM_CUST_MAP
    AR_TA_PROM_LINES_INT
    AR_TA_PROM_PAYMNT_ALL
    AR_TA_PROM_PAYMNT_TYP
    AR_TA_PROM_PRODS_ALL
    AR_TA_PROM_STATUS_MAP
    AR_TA_RECON_INFO_ALL
    AR_TA_RECV_TRXSET_ALL
    AR_TA_REMIT_HIST_ALL
    AR_TA_REMIT_PROF_ALL
    AR_TA_RISK_COMENT_ALL
    AR_TA_RULES_ALL
    AR_TA_RULE_OUTPUT
    AR_TA_RULE_SETS_ALL
    AR_TA_RULE_SET_LN_ALL
    AR_TA_TRX_SETS_ALL
    AR_TA_TRX_SET_LN_ALL
    AR_TA_TRX_TO_CREATE
    AR_TA_TRX_TYP_INT_ALL
    AR_TA_VERSIONS
    New Views
    View Name
    Description of Change
    AR_MEMO_LINES_VL
    Added tax_product_category.
    AR_SHIP_ADDRESS_V
    Removed hz_loc_assignments.
    RA_CUSTOMER_TRX_LINES_V
    Added numerous columns
    AR_DOCS_RECEIVABLES_V
    AR_FUNDS_CAPTURE_ORDERS_V
    ARBR_DOCS_RECEIVABLES_V
    ARBR_DOCUMENT_LINES_V
    ARBR_FUNDS_CAPTURE_ORDERS_V
    AR_CBA_BANK_BRANCH_CONTACTS_V
    AR_CBA_BANK_ACCOUNT_CONTACTS_V
    AR_CBA_EFT_USER_NUMBER_V
    AR_LINE_DEFERRAL_REASONS
    Revenue Deferral Reasons
    AR_LINE_CONTINGENCIES_V
    Revenue Deferral Reasons
    AR_RDR_ITEMS_V
    Reasons, Validation Set for RDR setup
    Changed Views
    View Name
    Description of Change
    AR_AUTOMATIC_RECEIPTS_FORMAT_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.
    AR_BOE_AUTO_RECEIPTS_V
    Added Payment extension identifier to view
    AR_BOE_REMIT_RECEIPTS_CBUNR_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.
    AR_BOE_REMIT_RECEIPTS_NONCBR_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.
    AR_BOE_REMIT_RECEIPTS_V
    Modified the view to accommodate the data model changes related to payment uptake project
    AR_BR_ASSIGNMENTS_V
    Modified the view to accommodate the data model changes related to payment uptake project
    AR_BR_MAIN_REMIT_BATCH_V
    Modified the view to accommodate the data model changes related to payment uptake project
    AR_CASH_RECEIPTS_V
    Added Payment extension identifier and payment channel identifier to view
    AR_CUSTOMER_BILLS_TRX_V
    Added Payment extension identifier and payment channel identifier to view
    AR_REMITTED_RECEIPTS_FORMAT_V
    Added Payment extension identifier & payment channel code to view. Also modified the view to accommodate the data model changes related to payment uptake project.
    RA_CUSTOMER_TRX_CM_V
    Modified the view to accommodate the data model changes related to payment uptake project
    Added Payment extension identifier and the payment channel identifier to view
    RA_CUSTOMER_TRX_PART_CB_V
    Modified the view to accommodate the data model changes related to payment uptake project
    Added Payment extension identifier and the payment channel identifier to view
    RA_CUSTOMER_TRX_PARTIAL_V
    Modified the view to accommodate the data model changes related to payment uptake project
    Added Payment extension identifier and the payment channel identifier to view
    AR_AEL_GL_REC_V
    Made changes to support the new Internal Bank Account data model.
    AR_AEL_SL_REC_V
    Made changes to support the new Internal Bank Account data model.
    AR_CUSTOMER_BILLS_TRX_V
    Made changes to support the new Internal Bank Account data model.
    AR_BR_MAIN_REMIT_BATCH_V
    Made changes to support the new Internal Bank Account data model.
    AR_BATCHES_V
    Made changes to support the new Internal Bank Account data model.
    AR_BATCH_REMIT_V
    Made changes to support the new Internal Bank Account data model.
    AR_BOE_REMIT_RECEIPTS_V
    Made changes to support the new Internal Bank Account data model.
    AR_CASH_RECEIPTS_V
    Made changes to support the new Internal Bank Account data model.
    AR_INTERIM_CR_LINES_V
    Made changes to support the new Internal Bank Account data model.
    AR_CASH_RECEIPTS_V
    Added legal_entity_id column
    AR_CUSTOMER_BILLS_TRX_V
    Added legal_entity_id column
    AR_PAYMENT_SCHEDULES_PMT_V
    Added legal_entity_id column
    AR_PAYMENT_SCHEDULES_TRX2_V
    Added legal_entity_id column
    RA_CUSTOMER_TRX_CR_TRX_V
    Added legal_entity_id column
    RA_CUSTOMER_TRX_PARTIAL_V
    Added legal_entity_id column
    RA_CUSTOMER_TRX_PART_CB_V
    Added legal_entity_id column
    AR_PAYMENT_SCHEDULES_V
    Added legal_entity_id column
    RA_CUST_TRX_LINE_GL_DIST_V
    Added column user_generated_flag
     
    Bharat likes this.
  2. y1452001

    y1452001 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    SELECT ac.REMIT_BANK_ACCT_USE_ID,
    cb.BANK_ACCOUNT_NAME,
    ac.REMITTANCE_BANK_ACCOUNT_ID
    FROM ra_customer_trx_all ra ,
    ar_cash_receipts_all ac ,
    ar_receivable_applications_all aaa,
    CE_BANK_ACCOUNTS cb,
    CE_BANK_ACCT_USES_ALL ca
    WHERE aaa.application_type = 'CASH'
    AND aaa.cash_receipt_id = ac.cash_receipt_id
    AND aaa.applied_customer_trx_id = ra.customer_trx_id
    AND ra.CT_REFERENCE='10001' – SO ORDER NUMBER
    AND cb.BANK_ACCOUNT_ID = ca.BANK_ACCOUNT_ID
    Ra.org_id = ac.org_id
    AND cb.ORG_ID = ‘82’
    Question -> Returning multiple rows? How to get sales order beneficiary name, account?