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

TABLE: AMS.AMS_PROD_TEMPLATES_B

Object Details
Object Name: AMS_PROD_TEMPLATES_B
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_PROD_TEMPLATES_B
Subobject Name:
Status: VALID


The table stores the template which are used when products are created from OMO. These templates sets the inventory attributes based on whether the product getting created in is 'Service' or 'Item'


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_PROD_TEMPLATES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTEMPLATE_ID
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER (15) Yes Unique template identifier
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER (15) Yes Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
SECURITY_GROUP_ID NUMBER

Used in hosted environments
PRODUCT_SERVICE_FLAG VARCHAR2 (40)
The flag indicates whether the template is for a product or for a service.
Query Text

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


SELECT TEMPLATE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      PRODUCT_SERVICE_FLAG
FROM AMS.AMS_PROD_TEMPLATES_B;

Dependencies

[top of page]

AMS.AMS_PROD_TEMPLATES_B does not reference any database object

AMS.AMS_PROD_TEMPLATES_B is referenced by following:

SchemaAPPS
SynonymAMS_PROD_TEMPLATES_B