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


VIEW: APPS.CS_CONFIG_RG_V

Object Details
Object Name: CS_CONFIG_RG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_CONFIG_RG_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARENT_CP_ID NUMBER
Yes Parent Customer Product identifier
PARENT_REFERENCE_NUMBER VARCHAR2 (30) Yes Parent assembly reference number
PARENT_PRODUCT VARCHAR2 (40)
Parent assembly product
PARENT_PRODUCT_DESCRIPTION VARCHAR2 (240)
Parent assembly product description
PARENT_LOT_NUMBER VARCHAR2 (80)
Parent assembly lot number
PARENT_SERIAL_NUMBER VARCHAR2 (30)
Parent assembly serial number
TOP_REFERENCE_NUMBER VARCHAR2 (30) Yes Top assembly reference number
TOP_PRODUCT VARCHAR2 (40)
Top assembly product
TOP_PRODUCT_DESCRIPTION VARCHAR2 (240)
Top assembly product description
TOP_LOT_NUMBER VARCHAR2 (80)
Top assembly lot number
TOP_SERIAL_NUMBER VARCHAR2 (30)
Top assembly serial number
Query Text

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


SELECT PARENT_CP_ID
,      PARENT_REFERENCE_NUMBER
,      PARENT_PRODUCT
,      PARENT_PRODUCT_DESCRIPTION
,      PARENT_LOT_NUMBER
,      PARENT_SERIAL_NUMBER
,      TOP_REFERENCE_NUMBER
,      TOP_PRODUCT
,      TOP_PRODUCT_DESCRIPTION
,      TOP_LOT_NUMBER
,      TOP_SERIAL_NUMBER
FROM APPS.CS_CONFIG_RG_V;

Dependencies

[top of page]

APPS.CS_CONFIG_RG_V references the following:

SchemaAPPS
PL/SQL PackageCSICUMPI_PUB - show dependent code
SynonymCS_CUSTOMER_PRODUCTS_ALL
PL/SQL PackageCS_STD - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.CS_CONFIG_RG_V is not referenced by any database object