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


VIEW: APPS.CSI_CP_FORM_GRID_V

Object Details
Object Name: CSI_CP_FORM_GRID_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSI.CSI_CP_FORM_GRID_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ACCOUNT_NUMBER VARCHAR2 (30) Yes
PRINCIPAL_PARTY_NAME VARCHAR2 (360) Yes
CUSTOMER_PRODUCT_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CUSTOMER_ID NUMBER

INVENTORY_ITEM_ID NUMBER
Yes
CREATED_MANUALLY_FLAG VARCHAR2 (1)
MOST_RECENT_FLAG CHAR (1)
CURRENT_CP_REVISION_ID VARCHAR2 (3)
CURRENT_SERIAL_NUMBER VARCHAR2 (30)
TYPE_CODE VARCHAR2 (30)
SYSTEM_ID NUMBER

INSTALLATION_DATE DATE

ORIGINAL_ORDER_LINE_ID NUMBER

ORIGINAL_ORDER_DATE DATE

ORIGINAL_ORDER_NUMBER NUMBER

ORIGINAL_ORDER_LINE_NUMBER NUMBER

ORIGINAL_LINK_TO_ORDER_LINE_ID NUMBER

ORIGINAL_LINE_SERV_DETAIL_ID VARCHAR2 (0)
ORIGINAL_NET_AMOUNT NUMBER

PRICE_LIST_ID NUMBER

SHIP_TO_SITE_USE_ID NUMBER

BILL_TO_SITE_USE_ID NUMBER

INSTALL_SITE_USE_ID NUMBER

QUANTITY NUMBER
Yes
SHIPPED_FLAG VARCHAR2 (0)
DELIVERED_FLAG VARCHAR2 (0)
UNIT_OF_MEASURE_CODE VARCHAR2 (3) Yes
PARENT_CP_ID VARCHAR2 (0)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
CONTEXT VARCHAR2 (30)
CUSTOMER_PRODUCT_STATUS_ID NUMBER
Yes
SHIPPED_DATE VARCHAR2 (0)
ORG_ID NUMBER

REFERENCE_NUMBER VARCHAR2 (30) Yes
PURCHASE_ORDER_NUM VARCHAR2 (50)
CP_LOT_NUMBER VARCHAR2 (80)
SPLIT_FLAG VARCHAR2 (0)
CP_STATUS VARCHAR2 (50) Yes
CANCELLED_FLAG VARCHAR2 (0)
TERMINATED_FLAG VARCHAR2 (1)
STATUS_CHANGE_ALLOWED_FLAG VARCHAR2 (1)
INCIDENT_ALLOWED_FLAG VARCHAR2 (1)
SERVICE_ORDER_ALLOWED_FLAG VARCHAR2 (1)
SYSTEM VARCHAR2 (50)
CP_TYPE VARCHAR2 (80)
PRODUCT_AGREEMENT VARCHAR2 (240)
PRODUCT_AGREEMENT_ID NUMBER

REVISION VARCHAR2 (3)
SERIAL_NUMBER_CONTROL_CODE NUMBER

PRODUCT_DESCRIPTION VARCHAR2 (240)
SERVICED_STATUS VARCHAR2 (0)
SERVICED_STATUS_FLAG VARCHAR2 (0)
BOL_ITEM_TYPE NUMBER
Yes
RETURN_BY_DATE DATE

ACTUAL_RETURNED_DATE DATE

CONFIG_ENABLED_FLAG CHAR (1)
CONFIG_START_DATE DATE

CONFIG_END_DATE DATE

CONFIG_ROOT_ID VARCHAR2 (0)
CONFIG_PARENT_ID NUMBER

CONFIG_TYPE VARCHAR2 (30)
CP_CONFIG_TYPE VARCHAR2 (80)
RMA_LINE_ID VARCHAR2 (0)
PROJECT_ID NUMBER

TASK_ID NUMBER

PLATFORM_VERSION_ID VARCHAR2 (0)
PLATFORM_VERSION VARCHAR2 (0)
CONCATENATED_SEGMENTS VARCHAR2 (40)
CONFIG_PARENT_INFO VARCHAR2 (4000)
CONFIG_ROOT_INFO VARCHAR2 (4000)
CONFIG_CHILDREN_FLAG VARCHAR2 (4000)
ORGANIZATION_NAME VARCHAR2 (240)
MERCHANT_VIEW_FLAG VARCHAR2 (1) Yes
CUSTOMER_VIEW_FLAG VARCHAR2 (1) Yes
EXTERNAL_REFERENCE VARCHAR2 (30)
Query Text

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


SELECT ROW_ID
,      ACCOUNT_NUMBER
,      PRINCIPAL_PARTY_NAME
,      CUSTOMER_PRODUCT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CUSTOMER_ID
,      INVENTORY_ITEM_ID
,      CREATED_MANUALLY_FLAG
,      MOST_RECENT_FLAG
,      CURRENT_CP_REVISION_ID
,      CURRENT_SERIAL_NUMBER
,      TYPE_CODE
,      SYSTEM_ID
,      INSTALLATION_DATE
,      ORIGINAL_ORDER_LINE_ID
,      ORIGINAL_ORDER_DATE
,      ORIGINAL_ORDER_NUMBER
,      ORIGINAL_ORDER_LINE_NUMBER
,      ORIGINAL_LINK_TO_ORDER_LINE_ID
,      ORIGINAL_LINE_SERV_DETAIL_ID
,      ORIGINAL_NET_AMOUNT
,      PRICE_LIST_ID
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      INSTALL_SITE_USE_ID
,      QUANTITY
,      SHIPPED_FLAG
,      DELIVERED_FLAG
,      UNIT_OF_MEASURE_CODE
,      PARENT_CP_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      CUSTOMER_PRODUCT_STATUS_ID
,      SHIPPED_DATE
,      ORG_ID
,      REFERENCE_NUMBER
,      PURCHASE_ORDER_NUM
,      CP_LOT_NUMBER
,      SPLIT_FLAG
,      CP_STATUS
,      CANCELLED_FLAG
,      TERMINATED_FLAG
,      STATUS_CHANGE_ALLOWED_FLAG
,      INCIDENT_ALLOWED_FLAG
,      SERVICE_ORDER_ALLOWED_FLAG
,      SYSTEM
,      CP_TYPE
,      PRODUCT_AGREEMENT
,      PRODUCT_AGREEMENT_ID
,      REVISION
,      SERIAL_NUMBER_CONTROL_CODE
,      PRODUCT_DESCRIPTION
,      SERVICED_STATUS
,      SERVICED_STATUS_FLAG
,      BOL_ITEM_TYPE
,      RETURN_BY_DATE
,      ACTUAL_RETURNED_DATE
,      CONFIG_ENABLED_FLAG
,      CONFIG_START_DATE
,      CONFIG_END_DATE
,      CONFIG_ROOT_ID
,      CONFIG_PARENT_ID
,      CONFIG_TYPE
,      CP_CONFIG_TYPE
,      RMA_LINE_ID
,      PROJECT_ID
,      TASK_ID
,      PLATFORM_VERSION_ID
,      PLATFORM_VERSION
,      CONCATENATED_SEGMENTS
,      CONFIG_PARENT_INFO
,      CONFIG_ROOT_INFO
,      CONFIG_CHILDREN_FLAG
,      ORGANIZATION_NAME
,      MERCHANT_VIEW_FLAG
,      CUSTOMER_VIEW_FLAG
,      EXTERNAL_REFERENCE
FROM APPS.CSI_CP_FORM_GRID_V;

Dependencies

[top of page]

APPS.CSI_CP_FORM_GRID_V references the following:

SchemaAPPS
PL/SQL PackageCSICUMPI_PUB - show dependent code
SynonymCSI_II_RELATIONSHIPS
SynonymCSI_INSTALL_PARAMETERS
SynonymCSI_INSTANCE_STATUSES
SynonymCSI_IP_ACCOUNTS
SynonymCSI_ITEM_INSTANCES
SynonymCSI_I_ORG_ASSIGNMENTS
SynonymCSI_I_PARTIES
ViewCSI_LOOKUPS
ViewCSI_SYSTEMS_VL
ViewHR_OPERATING_UNITS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymOE_AGREEMENTS
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
APPS.CSI_CP_FORM_GRID_V is referenced by following:

SchemaAPPS
SynonymCS_CUST_PROD_FORM_V