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
372: and bos.operation_sequence_id = bor.operation_sequence_id
497: bsor.attribute12,
498: bsor.attribute13,
499: bsor.attribute14,
500: bsor.attribute15
501: from bom_resources br,
502: bom_sub_operation_resources bsor,
503: wip_operations wo
504: where wo.organization_id = p_orgID
505: and wo.wip_entity_id = p_wipEntityID