DBA Data[Home] [Help]

APPS.BOM_VALIDATE_OP_SEQ dependencies on ENG_REVISED_ITEMS

Line 99: , ENG_REVISED_ITEMS eri

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
103: AND bic.bill_sequence_id = eri.bill_sequence_id

Line 2395: , ENG_REVISED_ITEMS eri

2391: AND bso.standard_operation_id = p_std_op_id
2392: UNION
2393: SELECT NULL
2394: FROM BOM_STANDARD_OPERATIONS bso
2395: , ENG_REVISED_ITEMS eri
2396: WHERE NVL(bso.operation_type, 1)
2397: = DECODE( p_op_type, FND_API.G_MISS_NUM, 1
2398: , NVL(p_op_type, 1 ) )
2399: -- AND NVL(bso.line_id, FND_API.G_MISS_NUM)