BOM Routing Tables in Oracle Apps

BOM Routing Tables in Oracle Apps

In this post , I am sharing the BOM routing tables in oracle apps.Here tables stores BOM routing information's in the Oracle apps. I will share the complete sql query too using the BOM routing tables in oracle apps. These tables helps to store the BOM routing details in oracle apps. Using these Tables , we can develop the BOM routing report which helps to extract the BOM routing informations in oracle apps.

BOM Routing Tables in Oracle Apps

2 Important BOM routing Tables in Oracle Apps

1.BOM_OPERATIONAL_ROUTINGS_V

2.BOM_OPERATION_SEQUENCES_V 

 

SQL query using the BOM Routing tables to extract the Inventory BOM details in oracle apps

 

Select msb.segment1||'.'||msb.segment2||'.'||msb.segment3||'.'||msb.segment4||'.'||msb.segment5 assembly,

msb.description,

a1.completion_subinventory,

OPERATION_SEQ_NUM,

OPERATION_DESCRIPTION ,

RESOURCE_SEQ_NUM,

RESOURCE_CODE,

BR.UOM RESOURCE_UOM,

USAGE_RATE_OR_AMOUNT,
DEPARTMENT_CODE,

decode(SCHEDULE_FLAG,1,'Y',2,'N') SCHDULE 

from BOM_OPERATIONAL_ROUTINGS_V  a1,

BOM_OPERATION_SEQUENCES_V  a2,

mtl_system_items_b msb,

BOM_OPERATION_resourceS_V br

where a1.ROUTING_SEQUENCE_ID=a2.ROUTING_SEQUENCE_ID
and a1.ASSEMBLY_ITEM_ID=

msb.INVENTORY_ITEM_ID
and a1.organization_id=msb.organization_id
AND a1.organization_id=85
and nvl(a2.disable_date,'01-APR-2006')='01-APR-2006'
and br.OPERATION_SEQUENCE_ID=

a2.OPERATION_SEQUENCE_ID

BOM Routing Tables in Oracle Apps