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

VIEW: APPS.PQH_TEMPLATES_VL

Object Details
Object Name: PQH_TEMPLATES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPQH.PQH_TEMPLATES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


Templates View


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
SHORT_NAME VARCHAR2 (30) Yes
TEMPLATE_ID NUMBER (15) Yes
ATTRIBUTE_ONLY_FLAG VARCHAR2 (10)
ENABLE_FLAG VARCHAR2 (10) Yes
CREATE_FLAG VARCHAR2 (10)
TRANSACTION_CATEGORY_ID NUMBER (15) Yes
UNDER_REVIEW_FLAG VARCHAR2 (10)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
FREEZE_STATUS_CD VARCHAR2 (30)
TEMPLATE_TYPE_CD VARCHAR2 (30) Yes
LEGISLATION_CODE VARCHAR2 (30)
TEMPLATE_NAME VARCHAR2 (100) Yes
Query Text

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


SELECT ROW_ID
,      SHORT_NAME
,      TEMPLATE_ID
,      ATTRIBUTE_ONLY_FLAG
,      ENABLE_FLAG
,      CREATE_FLAG
,      TRANSACTION_CATEGORY_ID
,      UNDER_REVIEW_FLAG
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      FREEZE_STATUS_CD
,      TEMPLATE_TYPE_CD
,      LEGISLATION_CODE
,      TEMPLATE_NAME
FROM APPS.PQH_TEMPLATES_VL;

Dependencies

[top of page]

APPS.PQH_TEMPLATES_VL references the following:

SchemaAPPS
SynonymPQH_TEMPLATES
SynonymPQH_TEMPLATES_TL
APPS.PQH_TEMPLATES_VL is referenced by following:

SchemaAPPS
ViewPQH_REF_TEMPLATES_V
Package BodyPQH_RFT_BUS - show dependent code
Package BodyPQH_RFT_SHD - show dependent code
Package BodyPQH_TAT_BUS - show dependent code
Package BodyPQH_TAT_SHD - show dependent code
ViewPQH_TEMPLATES_V
Package BodyPQH_TEM_BUS - show dependent code