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


VIEW: APPS.PQH_ATTRIBUTES_VL

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

View Type

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


Attributes View


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
MASTER_ATTRIBUTE_ID NUMBER (15)
ATTRIBUTE_ID NUMBER (15) Yes
WIDTH NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
ENABLE_FLAG VARCHAR2 (10)
MASTER_TABLE_ROUTE_ID NUMBER (15)
COLUMN_NAME VARCHAR2 (2000) Yes
COLUMN_TYPE VARCHAR2 (1) Yes
ATTRIBUTE_NAME VARCHAR2 (100) Yes
REFRESH_COL_NAME VARCHAR2 (80)
LEGISLATION_CODE VARCHAR2 (30)
ATTRIBUTE_ITEMNAME VARCHAR2 (80)
REGION_ITEMNAME VARCHAR2 (80)
DECODE_FUNCTION_NAME VARCHAR2 (80)
KEY_COLUMN_NAME VARCHAR2 (2000)
Query Text

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


SELECT ROW_ID
,      MASTER_ATTRIBUTE_ID
,      ATTRIBUTE_ID
,      WIDTH
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ENABLE_FLAG
,      MASTER_TABLE_ROUTE_ID
,      COLUMN_NAME
,      COLUMN_TYPE
,      ATTRIBUTE_NAME
,      REFRESH_COL_NAME
,      LEGISLATION_CODE
,      ATTRIBUTE_ITEMNAME
,      REGION_ITEMNAME
,      DECODE_FUNCTION_NAME
,      KEY_COLUMN_NAME
FROM APPS.PQH_ATTRIBUTES_VL;

Dependencies

[top of page]

APPS.PQH_ATTRIBUTES_VL references the following:

SchemaAPPS
SynonymPQH_ATTRIBUTES
SynonymPQH_ATTRIBUTES_TL
APPS.PQH_ATTRIBUTES_VL is referenced by following:

SchemaAPPS
Package BodyBEN_PLAN_DESIGN_TXNS_API - show dependent code
Package BodyPQH_ATTRIBUTE_RANGES_PKG - show dependent code
Package BodyPQH_GEN_FORM - show dependent code
Package BodyPQH_REFRESH_DATA - show dependent code
ViewPQH_ROUTING_HIST_ATTRIBS_V
ViewPQH_SPECIAL_ATTRIBUTES_V
Package BodyPQH_TAT_BUS - show dependent code
ViewPQH_TEMPLATE_ATTRIBUTES_V
Package BodyPQH_TEM_BUS - show dependent code
ViewPQH_TXN_CATEGORY_ATTRIBUTES_V
Package BodyPQH_UTILITY - show dependent code
Package BodyPQH_WORKFLOW - show dependent code