eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

Skip to content FND Design Data

[Home] [Help]

View: CM_APCM_MST_V

Product:	GMF - Process Manufacturing Financials
Description:	View to enable master-detail relationship on Invoice Price Maintenance form
Implementation/DBA Data:	APPS.CM_APCM_MST_V

View Text

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

Columns

Name
PO_ID
ORGN_CODE
PO_NO
INVOICE_NO