Bill of Materials

SELECT SUBSTR (a.OWNER, 1, 20),
         SUBSTR (a.NAME, 1, 30),
         SUBSTR (a.TYPE, 1, 20),
         SUBSTR (u.status, 1, 10) Stat,
         u.last_ddl_time,
         SUBSTR (text, 1, 80)   Desc...

-- For serial controlled and non-lot controlled items
SELECT mmt.transaction_id,
       msn.serial_number,
       mmt.inventory_item_id,
       (SELECT segment1
          FROM mtl_system_items_b
     ...

SELECT wdj.wip_entity_id  cum_entity_id,
         wdj.organization_id cum_org_id,
         ml_elem_type.meaning elem_var_type,
         SUM (
            ROUND (
               DECODE (
              ...

SELECT segment1,
       bos.OPERATION_SEQ_NUM,
       RESOURCE_SEQ_NUM,
       effectivity_date
  FROM apps.bom_operation_sequences bos,
       bom_operational_routings     bor,
       mtl_system_item...