DBA Data[Home] [Help]

APPS.WIP_BOMROUTINGUTIL_PVT dependencies on BOM_OPERATION_RESOURCES

Line 367: bom_operation_resources bor,

363: bor.attribute13,
364: bor.attribute14,
365: bor.attribute15
366: from bom_operation_sequences bos,
367: bom_operation_resources bor,
368: bom_resources br
369: where bos.routing_sequence_id = l_routingSeqID
370: and bos.effectivity_date <= p_routingRevDate
371: and nvl(bos.disable_date, p_routingRevDate+1) >= p_routingRevDate

Line 378: bom_operation_resources bor2

374: and nvl(bor.acd_type, 0) <> 3
375: and bos.effectivity_date =
376: (select max(effectivity_date)
377: from bom_operation_sequences bos2,
378: bom_operation_resources bor2
379: where bos2.routing_sequence_id = l_routingSeqID
380: and bos2.operation_sequence_id = bor2.operation_sequence_id
381: and bos2.operation_seq_num = bos.operation_seq_num
382: and bor2.resource_seq_num = bor.resource_seq_num