DBA Data[Home] [Help]

APPS.PO_INQ_SV dependencies on MTL_SYSTEM_ITEMS

Line 554: mtl_system_items msi

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

Line 617: mtl_system_items msi

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