DBA Data[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