DBA Data[Home] [Help]

APPS.BOM_VALIDATE_OP_SEQ dependencies on BOM_INVENTORY_COMPONENTS

Line 98: FROM BOM_INVENTORY_COMPONENTS bic

94: IS
95: SELECT 'Rev Comp referencing Seq Num exists'
96: FROM SYS.DUAL
97: WHERE EXISTS (SELECT NULL
98: FROM BOM_INVENTORY_COMPONENTS bic
99: , ENG_REVISED_ITEMS eri
100: WHERE TRUNC(bic.effectivity_date) >= TRUNC(p_start_effective_date)
101: AND bic.implementation_date IS NULL
102: AND bic.operation_seq_num = p_operation_seq_num