Thursday 24 May 2012

bill of materials(bom)important tables in oracle apps


BILL OF MATERIALS TABLES

--ITEM COST

Select * from   CST_ITEM_COST_DETAILS

--RESOURCES

Select * from   BOM_RESOURCES

--RESOURCE COST

Select * from   CST_RESOURCE_COSTS

--DEPARTMENTS

Select * from   BOM_DEPARTMENTS

--DEPARTMENT RESOURCES

Select * from   BOM_DEPARTMENT_RESOURCES

--ROUTINGS

Select * from   BOM_OPERATIONAL_ROUTINGS

Select * from   BOM_OPERATION_SEQUENCES

Select * from   BOM_OPERATION_RESOURCES

--BILLS

Select * from   BOM_BILL_OF_MATERIALS

Select * from   BOM_INVENTORY_COMPONENTS

No comments:

Post a Comment