DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_UTIL_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 508: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

504: AND pria.item_description(+) = l_di_record.description
505: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
506: UNION ALL
507: SELECT SUM(nvl(quantity,0)) req_qty
508: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
509: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
510: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
511: AND prla.wip_entity_id =l_di_record.wip_entity_id
512: AND prla.destination_organization_id = l_di_record.organization_id

Line 542: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

538: AND pria.item_id = l_di_record.inventory_item_id
539: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
540: UNION ALL
541: SELECT SUM(nvl(quantity,0)) req_qty
542: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
543: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
544: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
545: AND prla.wip_entity_id = l_di_record.wip_entity_id
546: AND prla.destination_organization_id = l_di_record.organization_id