Rev 13 | Details | Compare with Previous | Last modification | View Log | RSS feed
SELECT BOM_ID, BOM_VERSION ||'.'||BOM_LIFECYCLE AS VERSION
FROM BOMS
WHERE BRANCH_ID =:BRANCH_ID
AND BOM_VERSION ||'.'||BOM_LIFECYCLE = :BOM_VERSION
ORDER BY VERSION