DBA Data[Home] [Help]

APPS.PO_INQ_SV dependencies on MTL_SYSTEM_ITEMS

Line 502: mtl_system_items msi

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
506: AND wor.resource_seq_num = x_wip_resource_seq_num

Line 565: mtl_system_items msi

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
569: AND wor.resource_seq_num = x_wip_resource_seq_num