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

VIEW: APPS.CZ_SRC_DEVL_PROJECTS_V

Object Details
Object Name: CZ_SRC_DEVL_PROJECTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCZ.CZ_SRC_DEVL_PROJECTS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DEVL_PROJECT_ID NUMBER (15) Yes Project unique identifier
NAME VARCHAR2 (255) Yes Project name
DESC_TEXT VARCHAR2 (2000)
Contains a version of an CZ_INTL_TEXTS string localized for the locale specified in LOCALE_ID
ORIG_SYS_REF VARCHAR2 (255)
BOM explosion original system reference: ORGANIZATION_ID:TOP_ITEM_ID. Used for imported models only
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
MODEL_TYPE VARCHAR2 (1) Yes Defines the type of the Configuration Model: S - solution model; P - PTO model; A - ATO model; C - non-BOM model (the default value)
ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

PRODUCT_KEY VARCHAR2 (255)
Query Text

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


SELECT DEVL_PROJECT_ID
,      NAME
,      DESC_TEXT
,      ORIG_SYS_REF
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      MODEL_TYPE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      PRODUCT_KEY
FROM APPS.CZ_SRC_DEVL_PROJECTS_V;

Dependencies

[top of page]

APPS.CZ_SRC_DEVL_PROJECTS_V references the following:

SchemaAPPS
SynonymCZ_DEVL_PROJECTS
ViewCZ_LOCALIZED_TEXTS_VL
SynonymCZ_RP_ENTRIES
APPS.CZ_SRC_DEVL_PROJECTS_V is referenced by following:

SchemaAPPS
Package BodyOKC_TERMS_TEMPLATES_PVT - show dependent code