DBA Data[Home] [Help]

APPS.ENG_ECO_UTIL dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 2014: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC

2010: AND STATUS_TYPE NOT IN (5,6);
2011:
2012: -- Delete substitute components of all pending revised items on ECO
2013:
2014: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
2015: WHERE SC.COMPONENT_SEQUENCE_ID IN
2016: (SELECT IC.COMPONENT_SEQUENCE_ID
2017: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2018: WHERE RI.ORGANIZATION_ID = org_id