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_INT

Object Details

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

This is an interface table which contains the invoice price
information brought over from Oracle Financials. The information
captured within this table is then downloaded to cm_apcm_mst table
which 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_INTI0	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	PO_ID POLINE_ID LINE_TYPE ITEM_ID AQUI_COST_CODE INVOICE_NO INVOICE_LINE_NO
CM_APCM_INTI1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	APINT_TRANS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APINT_TRANS_ID	NUMBER	(10)	Yes	Surrogate identifying a row in this table
PO_ID	NUMBER	(10)	Yes	Surrogate for the PO Number
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
ITEM_NO	VARCHAR2	(32)	Yes	item_no on the PO
AQUI_COST_ID	NUMBER	(10)	Yes	Acquisition Cost Surrogate ID
AQUI_COST_CODE	VARCHAR2	(16)	Yes	Acquisition Cost Code
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 from billing to base currency.
INVOICE_STATUS	NUMBER	(5)	Yes	Used by Oracle
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
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
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
INVALID_IND	NUMBER	(5)	Yes	Indicates if the invoice information is valid (0) or not(1) - used by synchronization process
DIRECTION_IND	NUMBER	(5)	Yes	Indicates the source of invoice information.
INVOICE_LINE_NO	NUMBER	(15)	Yes	Invoice Line number

Query Text

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


SELECT APINT_TRANS_ID
,      PO_ID
,      POLINE_ID
,      LINE_TYPE
,      ITEM_ID
,      ITEM_NO
,      AQUI_COST_ID
,      AQUI_COST_CODE
,      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
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      DELETE_MARK
,      TRANS_CNT
,      TEXT_CODE
,      INVALID_IND
,      DIRECTION_IND
,      INVOICE_LINE_NO
FROM GMF.CM_APCM_INT;

Dependencies

[top of page]

GMF.CM_APCM_INT does not reference any database object

GMF.CM_APCM_INT is referenced by following:

APPS: CM_APCM_INT