I'm presently encountering this issue with my current script and having some problems trying to make it work.
The script below that i'm using is pulling both "obsolete" and "released" version of part numbers in Oracle
I only need the "released" latest part numbers or the latest revision of the part number queried
Can somebody kindly please help me on my script below? I'm stuck here!!
select distinct level,sys_connect_by_path(msib.segment1, ' / ') as "PATH",msib2.segment1 as "CHILD ITEM AT LEVEL/PATH",msib.DESCRIPTION,msib2.DESCRIPTION,
bic.bill_sequence_id = bom.bill_sequence_id and bic.disable_date is null and bom.assembly_item_id = msib.inventory_item_id and bom.organization_id = msib.organization_id and bic.component_item_id = msib2.inventory_item_id and bom.organization_id = msib2.organization_id and bom.organization_id = and bic.effectivity_date < sysdate and bom.alternate_bom_designator is null start with msib.segment1 = ' '
connect by nocycle prior bic.component_item_id = msib2.inventory_item_id order by level