11i to R12 Replaced Tables in Oracle apps
Following are the join conditions. Use these to
complete your query.
SO_HEADERS_ALL -- OE_ORDER_HEADERS_ALL
SO_LINES_ALL -- OE_ORDER_LINES_ALL
so_picking_lines_all -- WSH_DELIVERY_DETAILS
so_picking_line_details -- wsh_delivery_assignments
WSH_NEW_DELIVERIES.DELIVERY_IDWSH_DELIVERY_ASS IGNMENTS.DELIVERY_ID
WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID WSH_DELIVERY_ASSIGNMENTS.DELIVERY_DETAIL_ID
WSH_DELIVERY_DETAILS.SOURCE_LINE_ID OE_ORDER_LINES_ALL.LINE_ID
complete your query.
SO_HEADERS_ALL -- OE_ORDER_HEADERS_ALL
SO_LINES_ALL -- OE_ORDER_LINES_ALL
so_picking_lines_all -- WSH_DELIVERY_DETAILS
so_picking_line_details -- wsh_delivery_assignments
WSH_NEW_DELIVERIES.DELIVERY_IDWSH_DELIVERY_ASS IGNMENTS.DELIVERY_ID
WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID WSH_DELIVERY_ASSIGNMENTS.DELIVERY_DETAIL_ID
WSH_DELIVERY_DETAILS.SOURCE_LINE_ID OE_ORDER_LINES_ALL.LINE_ID
=================================================================================
RA_CUSTOMERS
The table below lists the corresponding HZ table and column for various columns in the current RA_CUSTOMERS view
Column in RA_CUSTOMERS
|
Corresponding Table
|
Column
|
customer_name
|
hz_parties
|
party_name,
|
customer_id
|
hz_cust_accounts
|
cust_account_id
|
customer_number
|
hz_cust_accounts
|
account_number
|
status
|
hz_cust_accounts
|
status
|
Join Conditions:
HZ_CUST_ACCOUNTS..Party_Id = HZ_PARTIES.Party_Id
RA_ADDRESSES
Column in RA_ADDRESSES
|
Corresponding Table
|
Column
|
address_id
|
hz_cust_acct_sites_all
|
cust_acct_site_id
|
status
|
hz_cust_acct_sites_all
|
status
|
address1
|
hz_locations
|
address1
|
address2
|
hz_locations
|
address2
|
address3
|
hz_locations
|
address3
|
address4
|
hz_locations
|
address4
|
city
|
hz_locations
|
city
|
state
|
hz_locations
|
state
|
postal_code
|
hz_locations
|
postal_code
|
county
|
hz_locations
|
county
|
country
|
hz_locations
|
country
|
language
|
hz_locations
|
language
|
Source Tables: HZ_PARTY_SITES, HZ_LOCATIONS, HZ_CUST_ACCT_SITES_ALL
Join Conditions:
HZ_CUST_ACCT_SITES_ALL.party_site_id = HZ_PARTY_SITES.party_site_id
HZ_LOCATIONS.location_id = HZ_PARTY_SITES.location_id
RA_SITE_USES
The table below lists the corresponding HZ table and column for various columns in the current RA_SITE_USES view
Column in RA_SITE_USES
|
Corresponding Table
|
Column
|
site_use_id
|
hz_cust_site_uses
|
site_use_id
|
site_use_code
|
hz_cust_site_uses
|
site_use_code
|
status
|
hz_cust_site_uses
|
status
|
address_id
|
hz_cust_site_uses
|
cust_acct_site_id
|
RA_CONTACTS
Column in RA_CONTACTS
|
Corresponding Table
|
Column
|
contact_id
|
hz_cust_account_roles
|
cust_account_role_id
|
status
|
hz_cust_account_roles
|
status
|
customer_id
|
hz_cust_account_roles
|
cust_account_id
|
address_id
|
hz_cust_account_roles
|
cust_acct_site_id
|
first_name
|
hz_parties
|
person_first_name
|
last_name
|
hz_parties
|
person_last_name
|
Source Tables: HZ_CUST_ACCOUNT_ROLES, HZ_PARTY_RELATIONSHIPS, HZ_PARTIES
Join Conditions:
HZ_CUST_ACCOUNT_ROLES.party_id = HZ_PARTY_RELATIONSHIPS.party_id
HZ_CUST_ACCOUNT_ROLES.role_type = 'CONTACT'
HZ_PARTIES.party_id = HZ_PARTY_RELATIONSHIPS.subject_id
RA_CONTACT_ROLES
Column in RA_CONTACT_ROLES
|
Corresponding Table
|
Column
|
contact_id
|
hz_role_responsibility
|
cust_account_role_id
|
usage_code
|
hz_role_responsibility
|
responsibility_type
|
primary_flag
|
hz_role_responsibility
|
primary_flag
|
11i Table
|
R12 Change
|
ra_addresses_all
|
SELECT acct_site.cust_account_id customer_id, acct_site.cust_acct_site_id address_id
FROM hz_party_sites party_site,
hz_loc_assignments loc_assign,
hz_locations loc,
hz_cust_acct_sites_all acct_site
WHERE acct_site.party_site_id = party_site.party_site_id
AND loc.location_id = party_site.location_id
AND loc.location_id = loc_assign.location_id
AND NVL (acct_site.org_id, -99) = NVL (loc_assign.org_id, -99)
|
ra_site_uses_all
|
SELECT site_use_id, LOCATION, attribute1
FROM hz_cust_site_uses_all
|
ra_customers
|
SELECT cust_acct.cust_account_id customer_id,
SUBSTRB (party.party_name, 1, 50) customer_name,
cust_acct.account_number customer_number
FROM hz_parties party, hz_cust_accounts cust_acct
WHERE cust_acct.party_id = party.party_id
|
Suppliers:
New R12 tables -> Old 11i Tables
New R12 tables -> Old 11i Tables
AP_SUPPLIERS - replaces PO_VENDORS
AP_SUPPLIER_SITES_ALL- replaces PO_VENDOR_SITES_ALL
Additional supplier related tables in IBY (Payments) and HZ (TCA):
IBY_EXTERNAL_PAYEES_ALL - stores Payee(supplier) information.
HZ_PARTIES - Party data for the suppliers.
HZ_PARTY_SITES - Party site data for the supplier sites.
Invoices:
Additional table in R12: AP_INVOICE_LINES_ALL
Allocations - AP_CHRG_ALLOCATIONS_ALL is obsolete in R12
Taxes:
Taxes:
Functionality provided by E-Business Tax
New tables in R12
ZX_LINES - Detailed Tax lines for the invoice (trx_id = invoice_id)
ZX_LINES_SUMMARY - Summary tax lines for the invoice (trx_id = invoice_id)
ZX_REC_NREC_DIST - Tax distributions for the invoice (trx_id = invoice_id)
ZX_LINES_DET_FACTORS - Tax determination factors for the invoice (trx_id = invoice_id)
Payments:
Functionality moved to central Payments (IBY)
New IBY tables in R12:
IBY_PAY_SERVICE_REQUESTS - Payment Process Request information
Accounting:
Functionality moved to SubLedger Accounting (SLA)
New R12 tables:
XLA_EVENTS -> replaces AP_ACOCUNTING_EVENTS_ALL
XLA_AE_HEADERS -> replaces AP_AE_HEADERS_ALL
XLA_AE_LINES-> replaces AP_AE_LINES_ALL
XLA_DISTRIBUTION_LINKS
Trial Balance:
Trial Balance:
New R12 Table
XLA_TRIAL_BALANCES
AP_LIABILITY_BALANCE-> not used in new R12 transactions
AP_TRIAL_BALANCE -> not used in new R12 transactions
Bank Accounts:
Bank Accounts:
Functionality moved to Cash Management.
CE_BANK_ACCOUNTS -> replaces AP_BANK_ACCOUNTS_ALL
CE_BANK_ACCT_USES_ALL -> replaces AP_BANK_ACCOUNT_USES_ALL
CE_PAYMENT_DOCUMENTS -> AP_CHECK_STOCKS_ALL