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

VIEW: APPS.CLN_PROCAT_CATALOG_V

Object Details
Object Name: CLN_PROCAT_CATALOG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCLN.CLN_PROCAT_CATALOG_V
Subobject Name:
Status: VALID

View Type

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


View containing price list header information for the Sync Catalog XML message


[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (240)
Name of the price list.
START_DATE_ACTIVE DATE

Starting date of the valid period of the price list.
END_DATE_ACTIVE DATE

Ending date of the valid period of the price list.
COMMENTS VARCHAR2 (2000)
Price list description.
ACTIVE_FLAG VARCHAR2 (1)
Flag to determine if the price list is active.
LIST_TYPE_CODE VARCHAR2 (30)
Qualifier to determine if the list is a price list.
LIST_HEADER_ID NUMBER

Primary key for the price list.
CURRENCY_DETAIL_ID NUMBER

Foreign key to the types of currencies supported or 0 for the base currency for a price list.
TO_CURRENCY_CODE VARCHAR2 (30)
Display name of the currencies available.
FIXED_VALUE NUMBER

Multiplicative factor for currency conversion of type FIXED.
Query Text

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


SELECT NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      COMMENTS
,      ACTIVE_FLAG
,      LIST_TYPE_CODE
,      LIST_HEADER_ID
,      CURRENCY_DETAIL_ID
,      TO_CURRENCY_CODE
,      FIXED_VALUE
FROM APPS.CLN_PROCAT_CATALOG_V;

Dependencies

[top of page]

APPS.CLN_PROCAT_CATALOG_V references the following:

SchemaAPPS
SynonymQP_CURRENCY_DETAILS
SynonymQP_LIST_HEADERS_B
SynonymQP_LIST_HEADERS_TL

APPS.CLN_PROCAT_CATALOG_V is not referenced by any database object