DBA Data[Home] [Help]

APPS.PO_INQ_SV dependencies on WIP_OPERATION_RESOURCES

Line 553: FROM wip_operation_resources wor,

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

Line 616: FROM wip_operation_resources wor,

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