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

VIEW: APPS.POR_TEMPLATE_ASSOC_V

Object Details
Object Name: POR_TEMPLATE_ASSOC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.POR_TEMPLATE_ASSOC_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


The POR_TEMPLATE_ASSOC_V view is used in Information Template. It returns the association between the information templates and the items or categories. It gives out whether the information template is assocated with an item or a category.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
TEMPLATE_ASSOC_ID NUMBER
Yes Information Template Association Identifier
REGION_CODE VARCHAR2 (30) Yes Region Code
ITEM_OR_CATEGORY_FLAG VARCHAR2 (1) Yes Flag to determine item or category
ITEM_OR_CATEGORY_ID NUMBER
Yes Identifier for Item/Category
CREATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
Query Text

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


SELECT ROW_ID
,      TEMPLATE_ASSOC_ID
,      REGION_CODE
,      ITEM_OR_CATEGORY_FLAG
,      ITEM_OR_CATEGORY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.POR_TEMPLATE_ASSOC_V;

Dependencies

[top of page]

APPS.POR_TEMPLATE_ASSOC_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_B
SynonymPOR_TEMPLATE_ASSOC
APPS.POR_TEMPLATE_ASSOC_V is referenced by following:

SchemaAPPS
Package BodyPOR_IFT_ADMIN_PKG - show dependent code