DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 3588: FROM po_requisition_lines_all rql, po_requisition_headers_all rqh

3584: AND pria.item_id = l_eam_mat_req_rec.inventory_item_id
3585: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
3586: UNION ALL
3587: SELECT sum(rql.quantity) req_qty
3588: FROM po_requisition_lines_all rql, po_requisition_headers_all rqh
3589: WHERE rql.wip_entity_id = l_eam_mat_req_rec.wip_entity_id
3590: AND rql.destination_organization_id = l_eam_mat_req_rec.organization_id
3591: AND rql.wip_operation_seq_num = l_eam_mat_req_rec.operation_seq_num
3592: AND rql.requisition_header_id = rqh.requisition_header_id(+)