[Home] [Help]
VIEW: APPS.CM_APCM_MST_V
Source
View Text - Preformatted
SELECT distinct apcm.po_id, poord.orgn_code,poord.po_no,apcm.invoice_no from cm_apcm_mst apcm,po_ordr_hdr poord WHERE apcm.po_id = poord.po_id
View Text - HTML Formatted
SELECT DISTINCT APCM.PO_ID
, POORD.ORGN_CODE
, POORD.PO_NO
, APCM.INVOICE_NO
FROM CM_APCM_MST APCM
, PO_ORDR_HDR POORD
WHERE APCM.PO_ID = POORD.PO_ID