DBA Data[Home] [Help]

APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_REFERENCE_DESIGNATORS

Line 2824: FROM BOM_REFERENCE_DESIGNATORS BRDI2

2820: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
2821: OR ( p_batch_id = BRDI.batch_id )
2822: )
2823: AND exists (SELECT 'x'
2824: FROM BOM_REFERENCE_DESIGNATORS BRDI2
2825: WHERE BRDI2.COMPONENT_SEQUENCE_ID = BRDI.COMPONENT_SEQUENCE_ID
2826: AND BRDI2.COMPONENT_REFERENCE_DESIGNATOR = BRDI.COMPONENT_REFERENCE_DESIGNATOR
2827: AND NVL(BRDI2.ACD_TYPE, 1) = NVL(BRDI.ACD_TYPE, 1) );
2828: