Indented BOM & WIP SQL 's
Query to get Tree structure of the indented BOM along with Vendor for the Purchased items and Item type SELECT DISTINCT LPAD (' ', LEVEL * 2) || LEVEL ORDER_LEVEL , LPAD (' ', LEVEL * 1) || msib.segment1 ASSEMBLY_ITEM , LPAD (' ', LEVEL * 4) || msib2.segment1 AS COMPONENT_ITEM , msib2.description COMPONENT_ITEM_DESCRIPTION , bic.bill_sequence_id c, bom.bill_sequence_id b , msib.description ASSEMBLY_DESCRIPTION , msib.inventory_item_status_code ASSEMBLY_ITEM_STATUS , decode (msib2.PLANNING_MAKE_BUY_CODE, 1, 'MAKE' ...