549: 0,x_quantity_ordered,
550: wor.usage_rate_or_amount)
551: )
552: INTO x_assembly_quantity
553: FROM wip_operation_resources wor,
554: mtl_system_items msi
555: WHERE wor.wip_entity_id = x_wip_entity_id
556: AND nvl(wor.repetitive_schedule_id,-1) = nvl(x_wip_rep_schedule_id,-1)
557: AND wor.operation_seq_num = x_wip_operation_seq_num
612: SELECT decode(msi.outside_operation_uom_type,
613: 'ASSEMBLY',x_quantity_ordered * wor.usage_rate_or_amount,
614: 'RESOURCE',x_quantity_ordered)
615: INTO x_resource_quantity
616: FROM wip_operation_resources wor,
617: mtl_system_items msi
618: WHERE wor.wip_entity_id = x_wip_entity_id
619: AND nvl(wor.repetitive_schedule_id,-1) = nvl(x_wip_rep_schedule_id,-1)
620: AND wor.operation_seq_num = x_wip_operation_seq_num