Saturday 4 February 2017

IMPORTANT APPS TABLES

PO Modules:
1. Po_requisition_headers_all -- Req. Header Info
2. Po_requisition_lines_all -- Req. Lines Info
3. Po_req_distributions_all -- Req.Distributions Info
4. PO_HEADERS_ALL -- PO Header Information
5. PO_LINES_AL -- PO Line Information
6. PO_LINE_LOCATIONS_ALL -- PO Line Shipment Info
7. PO_DISTRIBUTIONS_ALL -- PO Accounting Info
8. rcv_shipment_headers -- Receipt Header Info
9. rcv_shipment_lines -- Receipt Line Info
10. rcv_transactions -- Receipt Transactions
11. rcv_routing_headers -- Receipt Routing info
12. po_vendors -- Supplier Header
13. po_vendor_sites_all -- supplier site level info
14. po_vendor_contacts -- Supplier Contacts Info
15. hr_locations -- Supplier Physical address info

Order Management Tables 
1. oe_order_headers_all -- Order Header info
2. oe_order_lines_all -- order line info
3. oe_transaction_types_tl -- Order Type
4. hz_cust_accounts -- Customer Info
5. hz_parties -- Party Info
6. hz_cust_site_uses_all -- Customer site info
7. hz_cust_acct_sites_all -- Customer acct
8. hz_party_sites -- customer site level info
9. hz_locations -- Customer Phsyical Location
10.ra_sales_reps_all -- Sales Reps
11.Qp_list_headers_tl -- Pricing info
12.wsh_delivery_detials -- Shipping DElivery details
13.wsh_delivery_assignments --shipping deliver assignments
14.wsh_new_deliveries -- Delivery Header info
15.oe_order_holds -- order hold info
16.oe_hold_sources_all -- hold source
17.oe_hold_releases_ll -- hold releases
18.oe_hold_definitions 

General Ledger (GL) 
1.gl_je_batches -- Journal Batches
2.gl_je_headers -- Journal Header
3.gl_je_lines -- Jounral Lines
4.gl_je_sources -- Journal Sources
5.gl_je_categories -- Journal Categories
6.gl_code_combinations -- Accounting Info
7.gl_balances -- Journal Balances
8.gl_sets_of_books -- Set of books info
Accounts Payables (AP)

1. ap_invoices_all --- Invoice Header info
2. ap_invoice_distributions_all -- Invoice Line info
3. ap_invoice_payments_All -- Invoice Payment Info
4. ap_payment_schedules_all
5. ap_checks_all -- Check Info
6. ap_banks
7. ap_bank_branches -- bank branches
8. ap_ae_headers_all -- accounting header info
9. ap_ae_lines_all -- accounting lines info
10.ap_Accounting_events_all -- accounting event info
11. po_vendors -- Supplier Header
12. po_vendor_sites_all -- supplier site level info
13. po_vendor_contacts -- Supplier Contacts Info
14. hr_locations -- Supplier Physicaal info

Accounts Receivables (AR)

1. ra_customer_trx_all -- transaction header info
2. ra_customer_trx_lines_all -- transaction lines
3. ra_cust_trx_line_gl_dist_all -- transaction acct info
4. ar_cash_receipts_all -- receipt info 
5. ar_receivable_applications_all 
6. hz_cust_accounts -- Customer Info
7. hz_parties -- Party Info
8. hz_cust_site_uses_all -- Customer site info
9. hz_cust_acct_sites_all -- Customer acct
10.hz_party_sites -- customer site level info
11.hz_locations -- Customer Phsyical Location
12.ra_cust_trx_types_all -- Transaction Types

General Ledger (GL)

1.gl_je_batches -- Journal Batches
2.gl_je_headers -- Journal Header
3.gl_je_lines -- Jounral Lines
4.gl_je_sources -- Journal Sources
5.gl_je_categories -- Journal Categories
6.gl_code_combinations -- Accounting Info
7.gl_balances -- Journal Balances
8.gl_sets_of_books -- Set of books info
9.gl_charts_of_accounts -- Chart of accounts info



Inventory (Inv)

1.mtl_system_items_b -- item info
2.mtl_onhand_quantities -- Item onhand qty
3.mtl_reservations -- Item Reservations
4.mtl_material_transactions -- Inventory Transaction
5.mtl_txn_request_headers -- Move Order Header Info
6.mtl_txn_request_lines -- Move order line info
7.mtl_item_locations -- Item Physical Locations
8.org_organization_definitions -- Organization info
9.mtl_categories_b -- Item Categories info
10.mtl_transaction_accounts -- Item Tranaction acct
11.mtl_txn_source_types -- Transaction Sources
12.mtl_secondary+inventories -- Subinventory info



===============================================================

ORDER MANAGEMENT TABLES

Entered
oe_order_headers_all 1 record created in header table
oe_order_lines_all Lines for particular records
oe_price_adjustments When discount gets applied
oe_order_price_attribs If line has price attributes then populated
oe_order_holds_all If any hold applied for order like credit check etc.
Booked
oe_order_headers_all Booked_flag=Y Order booked.
wsh_delivery_details Released_status Ready to release
Pick Released
wsh_delivery_details Released_status=Y Released to Warehouse (Line has been released to Inventory for processing)
wsh_picking_batches After batch is created for pick release.
mtl_reservations This is only soft reservations. No physical movement of stock
Full Transaction
mtl_material_transactions No records in mtl_material_transactions
mtl_txn_request_headers
mtl_txn_request_lines
wsh_delivery_details Released to warehouse.
wsh_new_deliveries if Auto-Create is Yes then data populated.
wsh_delivery_assignments deliveries get assigned
Pick Confirmed
wsh_delivery_details Released_status=Y Hard Reservations. Picked the stock. Physical movement of stock
Ship Confirmed
wsh_delivery_details Released_status=C Y To C:Shipped ;Delivery Note get printed Delivery assigned to trip stopquantity will be decreased from staged
mtl_material_transactions On the ship confirm form, check Ship all box
wsh_new_deliveries If Defer Interface is checked I.e its deferred then OM & inventory not updated. If Defer Interface is not checked.: Shipped
oe_order_lines_all Shipped_quantity get populated.
wsh_delivery_legs 1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.
oe_order_headers_all If all the lines get shipped then only flag N
Autoinvoice
wsh_delivery_details Released_status=I Need to run workflow background process.
ra_interface_lines_all Data will be populated after wkfw process.
ra_customer_trx_all After running Autoinvoice Master Program for
ra_customer_trx_lines_all specific batch transaction tables get populated
Price Details
qp_list_headers_b To Get Item Price Details.
qp_list_lines
Items On Hand Qty
mtl_onhand_quantities TO check On Hand Qty Items.
Payment Terms
ra_terms Payment terms
AutoMatic Numbering System
ar_system_parametes_all you can chk Automactic Numbering is enabled/disabled.
Customer Information
hz_parties Get Customer information include name,contacts,Address and Phone
hz_party_sites
hz_locations
hz_cust_accounts
hz_cust_account_sites_all
hz_cust_site_uses_all
ra_customers
Document Sequence
fnd_document_sequences Document Sequence Numbers
fnd_doc_sequence_categories
fnd_doc_sequence_assignments
Default rules for Price List
oe_def_attr_def_rules Price List Default Rules
oe_def_attr_condns
ak_object_attributes
End User Details
csi_t_party_details To capture End user Details
Sales Credit Sales Credit Information(How much credit can get)
oe_sales_credits

Attaching Documents
fnd_attached_documents Attched Documents and Text information
fnd_documents_tl
fnd_documents_short_text
Blanket Sales Order
oe_blanket_headers_all Blanket Sales Order Information.
oe_blanket_lines_all

Processing Constraints
oe_pc_assignments Sales order Shipment schedule Processing Constratins
oe_pc_exclusions
Sales Order Holds
oe_hold_definitions Order Hold and Managing Details.
oe_hold_authorizations
oe_hold_sources_all
oe_order_holds_all
Hold Relaese
oe_hold_releases_all Hold released Sales Order.
Credit Chk Details
oe_credit_check_rules To get the Credit Check Againt Customer.
Cancel Orders
oe_order_lines_all Cancel Order Details.
================================================================================

JOIN CONDITIONS USED IN ORACLE APPS(GL,AP,AR,INV ETC)


=================================================================================

KEY JOINS

GL AND AP
GL_CODE_COMBINATIONS AP_INVOICES_ALL
code_combination_id = acct_pay_code_combination_id
GL_CODE_COMBINATIONS AP_INVOICES_DISTRIBUTIONS_ALL
code_combination_id = dist_code_combination_id
GL_SETS_OF_BOOKS AP_INVOICES_ALL
set_of_books_id = set_of_books_id

GL AND AR
GL_CODE_COMBINATIONS RA_CUST_TRX_LINE__GL_DIST_ALL
code_combination_id = code_combination_id

GL AND INV
GL_CODE_COMBINATIONS MTL_SYSTEM_ITEMS_B
code_combination_id = cost_of_sales_account


GL AND PO
GL_CODE_COMBINATIONS PO_DISTRIBUTIONS_ALL
code_combination_id = code_combination_id


PO AND AP
PO_DISTRIBUTIONS_ALL AP_INVOICE_DISTRIBUTIONS_ALL
Po_distribution_id = po_distribution_id

PO_VENDORS AP_INVOICES_ALL
vendor_id = vendor_id

PO AND SHIPMENTS
PO_HEADERS_ALL RCV_TRANSACTIONS
Po_header_id = po_header_id

PO_DISTRIBUTIONS_ALL RCV_TRANSACTIONS
Po_distribution_id = po_distribution_id

SHIPMENTS AND INVOICE
RCV_TRANSACTIONS AP_INVOICE_DISTRIBUTIONS_ALL
RCV_TRANSACTION_ID = RCV_TRANSACTION_ID


PO AND INV
PO_REQUISITION_LINES_ALL MTL_SYSTEM_ITEMS_B
item_id = inventory_item_id
org_id = organization_id

PO AND HRMS
PO_HEADERS_ALL HR_EMPLOYEES
Agent_id = employee_id

PO AND REQUISITION
PO_DISTRIBUTIONS_ALL PO_REQ_DISTRIBUTIONS_ALL
req_distribution_id = distribution_id


SHIPMENTS AND INV
RCV_TRANSACTIONS MTL_SYSTEM_ITEMS_B
Organization_id = organization_id

INV AND HRMS
MTL_SYSTEM_ITEMS_B HR_EMPLOYEES
buyer_id = employee_id

OM AND AR
OE_ORDER_HEADERS_ALL RA_CUSTOMER_TRX_LINES_ALL
TO_CHAR( Order_number) = interface_line_attribute1
OE_ORDER_LINES_ALL RA_CUSTOMER_TRX_LINES_ALL
TO_CHAR(Line_id) = interface_line_attribute6

OE_ORDER_LINES_ALL RA_CUSTOMER_TRX_LINES_ALL
reference_customer_trx_line_id = customer_trx_line_id

OM AND SHIPPING
OE_ORDER_HEADERS_ALL WSH_DELIVARY_DETAILS

HEADER_ID = SOURCE_HEADER_ID

OE_ORDER_HEADERS_ALL WSH_DELIVARY_DETAILS
LINE_ID = SOURCE_LINE_ID
AP AND AR (BANKS)
AR_CASH_RECEIPTS_ALL AP_BANK_ACCOUNTS
REMITTANCE_BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AP AND AR
HZ_PARTIES AP_INVOICES_ALL

PARTY_ID = PARTY_ID

OM AND CRM
OE_ORDER_LINES_ALL CSI_ITEM_INSTANCES(Install Base)

No comments :