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

TABLE: ABM.ABM_API_TEMPLATES

Object Details
Object Name: ABM_API_TEMPLATES
Object Type: TABLE
Owner: ABM
Subobject Name:
Status: VALID


Importing data into ABM is done by using a set of templates. Each template has a template Id, template name and description. This table stores the list of such templates in ABM.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: ABM_API_TEMPLATES_PK
  1. ColumnTEMPLATE_ID
  2. ColumnTEMPLATE_NAME
Indexes
Index Type Uniqueness Tablespace Column
ABM_API_TEMPLATES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTEMPLATE_ID
ColumnTEMPLATE_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
ABM_API_TEMPLATES ABM_API_TEMPLATES_FK TableABM_TAG_ENT_TYPES ABM_API_TEMPLATES I16_SYS_ENTITY_NAME
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER
Yes API template Id.
TEMPLATE_NAME VARCHAR2 (240) Yes API template name.
DESCRIPTION VARCHAR2 (720) Yes API template description.
DATA_TEMPLATE VARCHAR2 (3) Yes API data template.
I16_SYS_ENTITY_NAME VARCHAR2 (96)
System Entity Name.
CREATION_DATE DATE
Yes 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
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT TEMPLATE_ID
,      TEMPLATE_NAME
,      DESCRIPTION
,      DATA_TEMPLATE
,      I16_SYS_ENTITY_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM ABM.ABM_API_TEMPLATES;

Dependencies

[top of page]

ABM.ABM_API_TEMPLATES does not reference any database object

ABM.ABM_API_TEMPLATES is not referenced by any database object