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!

Can anyone tell me the backend tables for the Customer Price lists and BOM

Discussion in 'Oracle Apps Technical' started by bsrkr, Oct 21, 2011.

  1. bsrkr

    bsrkr Guest

    Working on some DWH project.. Can anyone tell me the backend tables for the Customer Price lists and BOM in oralce apps
    want to know the basic steps of the Pricing module in Oracle Apps and BOM.
    If there is any specific document links .. pl forword
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    customer price lists tables: -
    QP_LIST_HEADERS, QP_LIST_LINES, QP_PRICING_ATTRIBUTES

    bom tables :- BOM_RESOURCES,CST_RESOURCE_COSTS,BOM_DEPARTMENTS,BOM_DEPARTMENT_RESOURCE, BOM_BILL_OF _MATERIALS,BOM_OPERATION_SEQUENCES

    Thanks,
    Bharat G.
     
    Sadik likes this.
  3. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bsrkr,

    Post the version of Apps you are working on and I might have the advanced pricing docs for you.
    thanks
    Ramji
     
  4. nep84

    nep84 Active Member

    Messages:
    4
    Likes Received:
    3
    Trophy Points:
    85
    Location:
    NJ
    add bom_inventory_components to the list of bom tables.

    my first post.
     
  5. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    BOM in R12 here is the list. Check the Oracle TRM/Metalink to ensure complete list. If you do not have access , i will upload for you shortly

    bom_bill_of_materials
    bom_inventory_components
    bom_reference_designators
    bom_substitute_components
    mtl_item_revisions
    bom_operational_routings
    bom_operation_sequences
    bom_operation_resources
    BOM_BILL_OF_MTLS_INTERFACE
    BOM_INVENTORY_COMPS_INTERFACE
    BOM_REF_DESGS_INTERFACE
    BOM_SUB_COMPS_INTERFACE
    MTL_ITEM_REVISIONS_INTERFACE
    BOM_OP_ROUTINGS_INTERFACE
    BOM_OP_SEQUENCES_INTERFACE
    BOM_OP_RESOURCES_INTERFACE
    MTL_RTG_ITEM_REVS_INTERFACE
     
    Bharat likes this.
  6. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Qp_interface_list_header
    qp_interface_list_lines
    qp_interface_qualifiers
    qp_interface_pricing_attribs
    qp_interface_errors
    qp_list_headers_b
    qp_list_headers_tl
    qp_list_lines
    qp_qualifiers
    qp_pricing_attributes
    qp_rltd_modifiers
     
    Bharat likes this.