DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on EAM_WORK_ORDER_DIRECT_ITEMS_V

Line 4408: from eam_work_order_direct_items_v ewodi

4404: AND pria.wip_resource_seq_num = l_eam_direct_items_rec.direct_item_sequence_id
4405: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
4406: UNION ALL
4407: select greatest(nvl(po_quantity_ordered-po_quantity_cancelled,0), nvl(rql_quantity_ordered,0), nvl(quantity_received,0)) req_qty
4408: from eam_work_order_direct_items_v ewodi
4409: where ewodi.wip_entity_id = l_eam_direct_items_rec.wip_entity_id
4410: and ewodi.organization_id = l_eam_direct_items_rec.organization_id
4411: and ewodi.operation_seq_num = l_eam_direct_items_rec.operation_seq_num
4412: and ewodi.direct_item_sequence_id = l_eam_direct_items_rec.direct_item_sequence_id