1. 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!

Order Management tables and details

Discussion in 'Oracle Apps Technical' started by bobbyiiit, Aug 14, 2010.

  1. bobbyiiit

    bobbyiiit Active Member

    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    85
    This is available in metalink and many internet sites. Since I felt it handy reference, I have reproduced the contents.

    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.
     
  2. kotewar

    kotewar Active Member

    Messages:
    3
    Likes Received:
    1
    Trophy Points:
    65
    Location:
    kolkata
    hi,
    this is very useful.
     
  3. anjalianand

    anjalianand Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    hi, i am studying the order management module in oracle applications and want to learn the oracle order management setup steps. Can someone give me how to start and also plz provide some documents

    anjalianand1411@gmail.com
     
  4. venkatanaidu.mandala

    venkatanaidu.mandala Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    i dont know how to give join between this two tables
    Hz_locations and hz_cust_site_uses_all
     
  5. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    Below is the query for the tables join which you mentioned.

    SELECT hzl.location_id
    FROM hz_cust_site_uses_all hcsu
    , hz_cust_acct_sites hcas
    , hz_party_sites hps
    , hz_locations hzl
    WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
    AND hcas.party_site_id = hps.party_site_id
    AND hps.location_id = hzl.location_id