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

TABLE: GMF.CM_ALPR_CTL

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


This table is process control table for Cost Allocation Process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CM_ALPR_CTL_PK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_ID
ColumnGL_FISCAL_YR
ColumnGL_PERIOD
Columns
Name Datatype Length Mandatory Comments
CALENDAR_CODE VARCHAR2 (4)
Costing Calendar
PERIOD_CODE VARCHAR2 (4)
Costing Period
GL_FISCAL_YR VARCHAR2 (4) Yes GL Fiscal Year
GL_PERIOD VARCHAR2 (4) Yes GL Period
STARTED_ON DATE
Yes Date and time when process started
STARTED_BY NUMBER (15) Yes User who started the process
ENDED_ON DATE
Yes Date and time when process ended
RUNNING_IND NUMBER (5) Yes Indicates the status of the Process: 0 - Not running; 1 - Running
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
PERIOD_ID NUMBER (15)
period identifier
Query Text

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


SELECT CALENDAR_CODE
,      PERIOD_CODE
,      GL_FISCAL_YR
,      GL_PERIOD
,      STARTED_ON
,      STARTED_BY
,      ENDED_ON
,      RUNNING_IND
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      PERIOD_ID
FROM GMF.CM_ALPR_CTL;

Dependencies

[top of page]

GMF.CM_ALPR_CTL does not reference any database object

GMF.CM_ALPR_CTL is referenced by following:

SchemaAPPS
SynonymCM_ALPR_CTL