Interface and respective Tables Used in Oracle BOM and WIP

Following are Interface and there respective tables Used in Oracle BOM and WIP

Oracle Bill of Material

Open Bills of Material Interface

1. BOM_BILL_OF_MTLS_INTERFACE

2. BOM_INVENTORY_COMPS_INTERFACE

3. BOM_REF_DESGS_INTERFACE

4. BOM_SUB_COMPS_INTERFACE

5. MTL_ITEM_REVISIONS_INTERFACE

Open Bills of Material Tables

1. bom_bill_of_materials

2. bom_inventory_components

3. bom_reference_designators

4. bom_substitute_components

5. mtl_item_revisions

Oracle Routing

Open Routing Interface

1. BOM_OP_ROUTINGS_INTERFACE

2. BOM_OP_SEQUENCES_INTERFACE

3. BOM_OP_RESOURCES_INTERFACE

4. MTL_RTG_ITEM_REVS_INTERFACE

Open Routing Tables

1. bom_operational_routings

2. bom_operation_sequences

3. bom_operation_resources

Advertisements

4 thoughts on “Interface and respective Tables Used in Oracle BOM and WIP

  1. More4apps have built an excel based solution for uploading Boms and Routings. You might want to consider using this for data conversion, bom and routing updates, when uploading data from a 3rd party application or Datawarehouse.

  2. any interface or api for create bom standard operations and bom reources?
    if any please mail me.
    i have bom_op_sequences_interface and bom_op_resources_interface
    but these are for create routing not std. operations and resources.

    please help.

    thanks
    vishal
    mail:jhsvishal16@gmail.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s