Oracle apps table details

Oracle apps table details

Oracle apps table details : 

oracle apps 11i:
Order & Line details: Oe_order_headers_all, oe_order_lines_all

Credit card: ap_bank_accounts, ap_bank_accounts_all

Customer & party tables: hz_parties,HZ_CUST_ACCOUNT_ROLES,hz_cust_accounts, HZ_ORG_CONTACTS,hz_party_relationships
service module base table: CS_INCIDENTS_ALL_B

oracle apps R12:

Order & Line details: Oe_order_headers_all, oe_order_lines_all

Credit card:    iby_fndcpt_payer_assgn_instr_v

Customer & party tables: hz_parties,
HZ_CUST_ACCOUNT_ROLES,
hz_cust_accounts,
HZ_ORG_CONTACTS, HZ_PARTY_SITES,HZ_ORG_CONTACT_ROLES,HZ_RELATIONSHIP,HZ_RELATIONSHIP_TYPES ASO_PARTY_RELATIONSHIPS

service module base table: CS_INCIDENTS_ALL_B

Receipt table: AR_CASH_RECEIPTS_ALL

Invoice and Crredit memo , Debit memo: RA_CUSTOMER_TRX_ALL , RA_CUSTOMER_TRX_LINES_ALL

Quote Details: ASO_QUOTE_HEADERS_ALL , ASO_QUOTE_LINES_ALL, aso_quote_line_details, aso_quote_statuses_b, ASO_LINE_RELATIONSHIPS,ASO_HEADER_RELATIONSHIPS

Active Shop cart table: IBE_ACTIVE_QUOTES_ALL
Payment & Shipment: aso_payments, aso_shipments
Ship_to & Bill_to party_site_id: hz_party_sites, hz_cust_accounts ,hz_parties ,hz_cust_acct_sites_all ,  hz_cust_site_uses_all

Template Mapping Details: iby_dsp_attachments_v

inventory item details: mtl_system_items ,mtl_section_items
Section items: ibe_dsp_section_items s,ibe_dsp_msite_sct_items

FND MESSAGES details: FND_NEW_MESSAGES

Menu details: FND_MENUS_VL
FND_MENU_ENTRIES_VL -all menu and sub menu details

Function Details: FND_FORM_FUNCTIONS_VL

Pricing and modifier tables: 

ASO_PRICE_ADJUSTMENTS: Table to Store the Price Adjustment.

ASO_PRICE_ADJ_ATTRIBS :Stores qualifiers and pricing

attributes, which the corresponding price adjustment line

ASO_PRICE_ADJ_RELATIONSHIPS :This table stores the relationships between Quote lines and

price adjustments and also between price adjustments

ASO_PRICE_ATTRIBUTES :This table stores information on qualifiers and pricing

attributes, which the corresponding price adjustment line qualified.

Operating Unit , Profiles , Responsibilty details:  

fnd_profile_option_values ,

fnd_responsibility_tl ,

hr_operating_units

Concurrent Manager

FND_CONCURRENT_QUEUES
FND_CONCURRENT_PROGRAMS
FND_CONCURRENT_REQUESTS
FND_CONCURRENT_PROCESSES
FND_CONCURRENT_QUEUE_SIZE

FND

FND_APPL_TOPS
FND_LOGINS
FND_USER
FND_DM_NODES
FND_TNS_ALIASES
FND_NODES
FND_RESPONSIBILITY
FND_DATABASES
FND_UNSUCCESSFUL_LOGINS
FND_LANGUAGES
FND_APPLICATION
FND_PROFILE_OPTION_VALUES

AD / Patches

AD_APPLIED_PATCHES
AD_PATCH_DRIVERS
AD_BUGS
AD_INSTALL_PROCESSES
AD_SESSIONS
AD_APPL_TOPS

SCM (Purchasing and requestions tables)

Purchase order

PO_HEADERS_ALL
PO_LINES_ALL
PO_DISTRIBUTIONS_ALL (REQ_HEADER_REFERENCE_NUM in Distributions table is the Requisition number for this PO)
PO_LINE_LOCATIONS_ALL
Purchase Requestions
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQ_DISTRIBUTIONS_ALL

Purchase Receipt tables

RCV_SHIPMENT_HEADERS

RCV_SHIPMENT_LINES (Lines Table has PO_HEADER_ID)

Purchase Invoices

AP_INVOICES_ALL

AP_INVOICE_DISTRIBUTIONS_ALL

Accounting Entries Tables:

AP_ACCOUNTING_EVENTS_ALL

AP_AE_HEADERS_ALL

AP_AE_LINES_ALL

Purchase Payments: 

AP_INVOICE_PAYMENTS_ALL

AP_PAYMENT_SCHEDULES_ALL

AP_CHECKS_ALL

AP_CHECK_FORMATS

AP_BANK_ACCOUNTS_ALL

AP_BANK_BRANCHES

AP_TERMS

 Section Search Query:
SELECT mss.child_section_id INVENTORY_ITEM_ID, s.display_name DESCRIPTION,
0 CATEGORY_ID ,1 NEARNESS FROM ibe_dsp_sections_vl S,
ibe_dsp_msite_sct_sects MSS , ibe_dsp_sections_vl P WHERE S.section_id = MSS.child_section_id and
P.section_id =mss.parent_section_id AND MSS.mini_site_id = '1111'
AND NLS_UPPER(s.display_name) LIKE NLS_UPPER( '%LSP%' ) order by s.display_name asc