11i vs R12 Tables

By -

Some of the 11i table names that have changed in R12

11i R12
AP_ACCOUNTING_EVENTS_ALL  XLA_EVENTS 
AP_AE_HEADERS_ALL  XLA_AE_HEADERS 
AP_AE_LINES_ALL XLA_AE_LINES 
AP_BANK_ACCOUNT_USES  CE_BANK_ACCT_USES_ALL
AP_BANK_ACCOUNTS  CE_BANK_ACCOUNTS  && IBY_EXT_BANK_ACCOUNTS 
AP_BANK_BRANCHES CEBV_BANK_BRANCHES  &&  CE_BANK_BRANCHES_V
ap_inv_selection_criteria_all IBY_PAY_INSTRUCTIONS_ALL
AP_CHECK_STOCKS_ALL  CE_PAYMENT_DOCUMENTS 
AP_INVOICE_DISTS_MRC_V XLA_AE_LINES with APPLICATION_ID of AP Module
AP_TAX_CODES_ALL  ZX_RATES_B
AR_VAT_TAX_ALL_B ZX_RATES_B
AX_AP_AE_HEADERS_ALL_V XLA_AE_HEADERS 
AX_AP_AE_LINES_ALL_V XLA_AE_LINES
AX_SLE_HEADERS XLA_AE_HEADERS 
AX_SLE_LINES XLA_AE_LINES 
CS_COUNTER_VALUES CSI_COUNTER_READINGS_BC_V
CS_COUNTERS CSI_COUNTERS_BC_V
GL_SET_OF_BOOKS GL_LEDGERS
HR_OPERATING_UNITS  XLE_ENTITY_PROFILES
HZ_LOC_ASSIGNMENTS ZX_LOC_ASSIGNMENTS_V
MTL_ITEM_TEMPLATES MTL_ITEM_TEMPLATES_VL
PO_ACCRUAL_RECONCILE_TEMP  PO_ACCRUAL_RECONCILE_TEMP Secured synonym
PO_DISTRIBUTIONS_MRC_V  XLA_AE_LINES with APPLICATION_ID of PO Module
PO_VENDOR_SITES_ALL AP_SUPPLIER_SITES_ALL
PO_VENDORS AP_SUPPLIERS
RA_ADDRESSES_ALL  HZ_CUST_ACCT_SITES_ALL 
RA_CUSTOMERS  HZ_PARTIES 
RA_HCUSTOMERS HZ_CUST_ACCOUNTS

Comments

Post a Comment

Popular posts from this blog

PO & Receipt Query

By -
Query to get PO & Receipt Data: select aps.segment1  "Supplier Number", poh.segment1  "Purchase Order Number", poh.AUTHORIZATION_STATUS  "Purchase Order Status", Null  "Purchase Order Release Number", poh.START_DATE  "Purchase Order Date", papf.full_name  "Buyer", msi.segment1   "Purchase Order Item Number", pll.closed_code  "Purchase Order Item Status", pol.PURCHASE_BASIS  "Purchase Order Item Type", msi.segment1  "Location Part Number", msi.description  "Location Part Description", pol.VENDOR_PRODUCT_NUM  "Supplier Part Number", POL.QUANTITY  "Item Order Quantity", pol.unit_price  "Location Item Price", poh.CURRENCY_CODE  "Location Currency Code", pol.unit_price  "Supplier Item Price", aps.PAYMENT_CURRENCY_CODE  "Supplier Currency Code", msi.PRIMARY_UNIT_OF_MEASURE  "Inventory Unit of Me
Read more

Supplier SQL query

By -
Query to get Supplier data from Oracle R12 SELECT   aps.segment1 "SupplierNum",          assa.vendor_site_code "Address Book Identifier ",          aps.vendor_name "Supplier Company Name ",          --Hou.name "Operating Unit Name",          Assa.address_line1 "Supplier Address Line1",          Assa.address_line2 "Supplier Address Line2",          assa.address_line3 "Supplier Address Line3",          assa.address_line4 "Supplier Address Line4",          assa.city "Supplier city",          assa.state || assa.PROVINCE "Supplier State/Province",          assa.country "Supp_country_Code",          assa.zip "Supp_postal_Code",          apsite_rmt.ADDRESS_LINE1 "Supp_Remit_to_Address_Line_1",          apsite_rmt.ADDRESS_LINE2 "Supp_Remit_to_Address_Line_2",          apsite_rmt.ADDRESS_LINE3 "Supp_Remit_to_Address_Line_3",    
Read more

Inventory Item Attributes, Categories, Vendor & Costs

By -
Query to get safety stock Quantity of inventory items: select msib.segment1,c.INVENTORY_ITEM_ID,SAFETY_STOCK_QUANTITY from mtl_safety_stocks c,  mtl_system_items_b msib   where c.INVENTORY_ITEM_ID = msib.INVENTORY_ITEM_ID     and c.ORGANIZATION_ID = msib.ORGANIZATION_ID     and c.SAFETY_STOCK_QUANTITY <> 0     and msib.ORGANIZATION_ID = 12     and msib.segment1 in ('98765'); Query to get the inventory item vendor and costs : select msi.inventory_item_id "Item ID", msi.segment1 "Part Number", msi.description  "Part Description - Internal", decode (msi.item_type,'XX_SUPPORT_ITEM','SUPPORT ITEM'                                        ,'XX_BULK_ITEM','BULK ITEM'                                        ,'P','PURCHASED ITEM'                                        ,'SA','SUBASSEMBLY'                                        ,'PH','PHANTOM ITEM'      
Read more