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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GMF.CM_APCM_MST

Object Details

Object Name:	CM_APCM_MST
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.CM_APCM_MST
Subobject Name:
Status:	VALID

This is an interface master table which contains the invoice price
information brought over from Oracle Financials table cm_apcm_int.
This information is used by the actual costing engine to determine
the price of the item.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CM_APCM_MST_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	PO_ID POLINE_ID LINE_TYPE ITEM_ID AQUI_COST_ID INVOICE_NO INVOICE_LINE_NO
CM_APCM_MSTI1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	APINT_TRANS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_LINE_NO	NUMBER	(15)	Yes	Invoice line Number
PO_ID	NUMBER	(10)	Yes	Surrogate for the PO No
POLINE_ID	NUMBER	(10)	Yes	Surrogate identifying the PO Line
LINE_TYPE	NUMBER	(5)	Yes	Indicator for the line type; 0 - Item, 1 - Acquisition Cost
ITEM_ID	NUMBER	(10)	Yes	Surrogate of the item_no on the PO
AQUI_COST_ID	NUMBER	(10)	Yes	Acquisition Cost Surrogate ID
INVOICE_NO	VARCHAR2	(50)	Yes	Invoice Number
INVOICE_TYPE	NUMBER	(5)	Yes	Invoice type; 0 - Invoice, 1 - Credit Memo, 2 - Debit Memo
PREV_INVOICE_NO	VARCHAR2	(50)	Yes	Previous Invoice number if any
INVOICE_QTY	NUMBER		Yes	Invoice Quantity
QUANTITY_UOM	VARCHAR2	(4)	Yes	Invoice Quantity UOM
INVOICE_AMOUNT	NUMBER		Yes	Total invoice line amount in billing currency
UNIT_PRICE	NUMBER		Yes	Unit Price for the invoice in billing currency
INVOICE_BASE_AMOUNT	NUMBER		Yes	Total invoice line amount in base currency
UNIT_BASE_PRICE	NUMBER		Yes	Unit price for the invoice in the base currency.
BILLING_CURRENCY	VARCHAR2	(4)	Yes	Billing Currency
BASE_CURRENCY	VARCHAR2	(4)	Yes	Base currency of the invoice
EXCHANGE_RATE	NUMBER		Yes	exchange rate used for converting the invoice amount form billing to base currency.
INVOICE_STATUS	NUMBER	(5)	Yes	Used by Oracle for integration.
PO_DATE	DATE		Yes	PO Date
INVOICE_DATE	DATE		Yes	Invoice Date
GL_DATE	DATE		Yes	GL Posted Date
INTERFACE_DATE	DATE		Yes	Used by master file synchronization for determining the invoices to be synchronized.
AC_STATUS	NUMBER	(5)	Yes	Used by Actual Cost Process: 0 - Not applied, 1 - Applied, 2 - Modified
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TRANS_CNT	NUMBER	(10)		Not currently used
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
APINT_TRANS_ID	NUMBER	(10)	Yes	Surrogtae identifying a row in this table
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVOICE_LINE_NO
,      PO_ID
,      POLINE_ID
,      LINE_TYPE
,      ITEM_ID
,      AQUI_COST_ID
,      INVOICE_NO
,      INVOICE_TYPE
,      PREV_INVOICE_NO
,      INVOICE_QTY
,      QUANTITY_UOM
,      INVOICE_AMOUNT
,      UNIT_PRICE
,      INVOICE_BASE_AMOUNT
,      UNIT_BASE_PRICE
,      BILLING_CURRENCY
,      BASE_CURRENCY
,      EXCHANGE_RATE
,      INVOICE_STATUS
,      PO_DATE
,      INVOICE_DATE
,      GL_DATE
,      INTERFACE_DATE
,      AC_STATUS
,      DELETE_MARK
,      TRANS_CNT
,      TEXT_CODE
,      APINT_TRANS_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM GMF.CM_APCM_MST;

Dependencies

[top of page]

GMF.CM_APCM_MST does not reference any database object

GMF.CM_APCM_MST is referenced by following:

GMF: CM_APCM_MST#