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