DBA Data[Home] [Help]

APPS.WIP_BOMROUTINGUTIL_PVT dependencies on BOM_OPERATION_RESOURCES

Line 343: bom_operation_resources bor,

339: bor.attribute13,
340: bor.attribute14,
341: bor.attribute15
342: from bom_operation_sequences bos,
343: bom_operation_resources bor,
344: bom_resources br
345: where bos.routing_sequence_id = l_routingSeqID
346: and bos.effectivity_date <= p_routingRevDate
347: and nvl(bos.disable_date, p_routingRevDate+1) >= p_routingRevDate

Line 354: bom_operation_resources bor2

350: and nvl(bor.acd_type, 0) <> 3
351: and bos.effectivity_date =
352: (select max(effectivity_date)
353: from bom_operation_sequences bos2,
354: bom_operation_resources bor2
355: where bos2.routing_sequence_id = l_routingSeqID
356: and bos2.operation_sequence_id = bor2.operation_sequence_id
357: and bos2.operation_seq_num = bos.operation_seq_num
358: and bor2.resource_seq_num = bor.resource_seq_num