BOM tab – is there a way to add pending change numbers there?
Hi,
Is there a way to add pending change numbers to the BOM tab of the part so that you could see the pending change(s) for each component? Right now there is an icon that shows there is a change for the component but you have to click on the component and go to pending changes tab to see what change it is on.
I also tried creating a report or search for this but can only get system to report the pending change # for the top level assy, not for each component.
Thanks
Laura
Hi Laura,
I don’t think its possible to add pending changes for components on BOM tab.
But report could be a good idea for this kind of requirement.
I created a query which will help you to get the pending changes related to all the components in the BOM. Pass the BOM (Assembly Item Number) and get the pending changes (if any) related to all the components at all levels (i.e. even subassemblies). Create a PX which use this query and populate result either in html, excel. and you can add this px on action menu for user to use.
WITH x AS(SELECT DISTINCT a.item parent_item_id
, a.item_number child_item
, level bom_level
, a.find_number
FROM agile.bom a START WITH(a.item =(SELECT DISTINCT i.id
FROM agile.item i
, agile.bom b
WHERE i.id = b.item
AND i.item_number = :assembly_item
)
AND nvl(a.change_out, 0)= 0
AND(substr(a.flags, 5, 1)= 1)
AND a.id NOT IN(SELECT c.prior_bom
FROM agile.bom c
WHERE c.item = a.item
))CONNECT BY PRIOR a.component = a.item
AND nvl(a.change_out, 0)= 0
AND(substr(a.flags, 5, 1)= 1)
AND a.id NOT IN(SELECT b.prior_bom
FROM agile.bom b
WHERE b.item = a.item
)
)
SELECT DISTINCT i.item_number
, c.change_number
, n.description
, r.released
FROM agile.rev r
, agile.item i
, agile.change c
, agile.nodetable n
, x
WHERE 1 = 1
AND r.released = 0
AND n.id = c.status
AND c.id = r.change
AND r.item = i.id
AND i.item_number = x.child_item;
Thanks,
Vaibhav
