DBA Data[Home] [Help]

APPS.PO_INQ_SV dependencies on WIP_OPERATION_RESOURCES

Line 501: FROM wip_operation_resources wor,

497: 0,x_quantity_ordered,
498: wor.usage_rate_or_amount)
499: )
500: INTO x_assembly_quantity
501: FROM wip_operation_resources wor,
502: mtl_system_items msi
503: WHERE wor.wip_entity_id = x_wip_entity_id
504: AND nvl(wor.repetitive_schedule_id,-1) = nvl(x_wip_rep_schedule_id,-1)
505: AND wor.operation_seq_num = x_wip_operation_seq_num

Line 564: FROM wip_operation_resources wor,

560: SELECT decode(msi.outside_operation_uom_type,
561: 'ASSEMBLY',x_quantity_ordered * wor.usage_rate_or_amount,
562: 'RESOURCE',x_quantity_ordered)
563: INTO x_resource_quantity
564: FROM wip_operation_resources wor,
565: mtl_system_items msi
566: WHERE wor.wip_entity_id = x_wip_entity_id
567: AND nvl(wor.repetitive_schedule_id,-1) = nvl(x_wip_rep_schedule_id,-1)
568: AND wor.operation_seq_num = x_wip_operation_seq_num