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

TABLE: GMF.CM_APCM_MST_EFC

Object Details
Object Name: CM_APCM_MST_EFC
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.CM_APCM_MST_EFC
Subobject Name:
Status: VALID


Shadow table of CM_APCM_MST for EFC migration. Stores the original values of columns of CM_APCM_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_APCM_DTL and only the columns that are actually converted to the Euro currency.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
INVOICE_LINE_NO NUMBER
Yes Invoice line number
POLINE_ID NUMBER
Yes Surrogate identifying the PO line
AQUI_COST_ID NUMBER
Yes Acquisition cost surrogate
LINE_TYPE NUMBER
Yes Indicator for the line type; 0 - Item, 1 - Acquisition cost
INVOICE_NO VARCHAR2 (50) Yes Invoice number
INVOICE_BASE_AMOUNT NUMBER
Yes Total invoice line amount in the base currency
PO_ID NUMBER
Yes Surrogate identifying the PO number
ITEM_ID NUMBER
Yes Surrogate of the item number on the PO
UNIT_BASE_PRICE NUMBER
Yes Unit price for the invoice line in the base currency
SET_OF_BOOKS_ID NUMBER
Yes Set of books identifier
BASE_CURRENCY VARCHAR2 (4) Yes Base currency for the invoice
EXCHANGE_RATE NUMBER
Yes Exchange rate used for converting the invoice amount from the billing to the base currency
Query Text

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


SELECT INVOICE_LINE_NO
,      POLINE_ID
,      AQUI_COST_ID
,      LINE_TYPE
,      INVOICE_NO
,      INVOICE_BASE_AMOUNT
,      PO_ID
,      ITEM_ID
,      UNIT_BASE_PRICE
,      SET_OF_BOOKS_ID
,      BASE_CURRENCY
,      EXCHANGE_RATE
FROM GMF.CM_APCM_MST_EFC;

Dependencies

[top of page]

GMF.CM_APCM_MST_EFC does not reference any database object

GMF.CM_APCM_MST_EFC is referenced by following:

SchemaAPPS
SynonymCM_APCM_MST_EFC