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


TABLE: BIS.BIS_OBJ_PROG_LINKAGES

Object Details
Object Name: BIS_OBJ_PROG_LINKAGES
Object Type: TABLE
Owner: BIS
FND Design Data: TableBIS.BIS_OBJ_PROG_LINKAGES
Subobject Name:
Status: VALID


This table stores the refresh programs for each object


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIS_OBJ_PROG_LINKAGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_TYPE
ColumnOBJECT_NAME
ColumnCONC_APP_ID
ColumnCONC_PROGRAM_NAME
BIS_OBJ_PROG_LINKAGES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONC_APP_ID
ColumnCONC_PROGRAM_NAME
Columns
Name Datatype Length Mandatory Comments
OBJECT_TYPE VARCHAR2 (30) Yes Description
OBJECT_OWNER VARCHAR2 (50) Yes Description
OBJECT_NAME VARCHAR2 (480) Yes Description
CONC_PROGRAM_NAME VARCHAR2 (30) Yes Description
CONC_APP_ID NUMBER (15) Yes Description
CONC_APP_SHORT_NAME VARCHAR2 (50)
Description
ENABLED_FLAG VARCHAR2 (1)
Description
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
REFRESH_MODE VARCHAR2 (30)
Description
Query Text

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


SELECT OBJECT_TYPE
,      OBJECT_OWNER
,      OBJECT_NAME
,      CONC_PROGRAM_NAME
,      CONC_APP_ID
,      CONC_APP_SHORT_NAME
,      ENABLED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      REFRESH_MODE
FROM BIS.BIS_OBJ_PROG_LINKAGES;

Dependencies

[top of page]

BIS.BIS_OBJ_PROG_LINKAGES does not reference any database object

BIS.BIS_OBJ_PROG_LINKAGES is referenced by following:

SchemaAPPS
SynonymBIS_OBJ_PROG_LINKAGES