I am trying to create a report from Oracle R12 that lists requisitions that do not have a purchase order created against them yet. The following is my SQL for getting the requisition data:
select GL_CODE_COMBINATIONS.SEGMENT2,
GL_CODE_COMBINATIONS.SEGMENT3,
PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID,
PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID,
PO_REQUISITION_HEADERS_ALL.SEGMENT1,
PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS,
PO_REQUISITION_LINES_ALL.LINE_NUM,
PO_REQUISITION_LINES_ALL.REQUESTER_EMAIL,
PO_REQUISITION_LINES_ALL.ITEM_DESCRIPTION,
PO_REQUISITION_LINES_ALL.NEED_BY_DATE,
PO_REQ_DISTRIBUTIONS_ALL.REQ_LINE_QUANTITY,
PO_REQUISITION_LINES_ALL.QUANTITY,
PO_REQUISITION_LINES_ALL.UNIT_PRICE,
PO_REQ_DISTRIBUTIONS_ALL.REQ_LINE_QUANTITY*PO_REQUISITION_LINES_ALL.UNIT_PRICE as EXTENDED_COST,
PO_REQUISITION_LINES_ALL.MODIFIED_BY_AGENT_FLAG,
PO_REQUISITION_LINES_ALL.CANCEL_FLAG,
PO_REQUISITION_LINES_ALL.ENCUMBERED_FLAG,
PO_REQUISITION_LINES_ALL.LINE_LOCATION_ID
from PO.PO_REQUISITION_HEADERS_ALL, PO.PO_REQUISITION_LINES_ALL, PO.PO_REQ_DISTRIBUTIONS_ALL, GL.GL_CODE_COMBINATIONS
where PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID = PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID
and PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID = PO_REQ_DISTRIBUTIONS_ALL.REQUISITION_LINE_ID
and PO_REQ_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID = GL_CODE_COMBINATIONS.CODE_COMBINATION_ID
How would I link this to a table containing PO data such as PO_HEADERS_ALL and/or PO_LINES_ALL to compare and exclude those not listed?