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


VIEW: APPS.CS_SR_CP_NEW_ACCT_EAM_RG_V

Object Details
Object Name: CS_SR_CP_NEW_ACCT_EAM_RG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_CP_NEW_ACCT_EAM_RG_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
INSTANCE_ID NUMBER
Yes Instance Id
PRODUCT_NAME VARCHAR2 (40)
Concatenated Segments
PRODUCT_DESCRIPTION VARCHAR2 (240)
Product Description
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Id
SERIAL_NUMBER VARCHAR2 (30)
Serial Number
SYSTEM_ID NUMBER

System Id
SYSTEM_NAME VARCHAR2 (50)
System Name
INVENTORY_REVISION VARCHAR2 (3)
Inventory Revision
PRODUCT_TYPE VARCHAR2 (30)
Product Type
INSTANCE_STATUS_ID NUMBER
Yes Instance Status Id
CUSTOMER_PRODUCT_STATUS VARCHAR2 (50) Yes Customer Product Status
INSTANCE_NUMBER VARCHAR2 (30) Yes Instance Number
LOT_NUMBER VARCHAR2 (80)
Lot Number
CUST_PO_NUMBER VARCHAR2 (50)
Customer PO Number
ORDER_NUMBER NUMBER

Order Number
PLATFORM_ID NUMBER

Platform Id
PLATFORM VARCHAR2 (0)
Platform
PLATFORM_VERSION_ID NUMBER

Platform Version Id
VERSION VARCHAR2 (0)
Platform Version
INCIDENT_ALLOWED_FLAG VARCHAR2 (1)
Incident Allowed Flag
PARTY_ACCOUNT_ID NUMBER

Party Account Id
LOCATION_ID NUMBER

Location Id
INV_MASTER_ORGANIZATION_ID NUMBER
Yes Inventory Master Organization Id
EXTERNAL_REFERENCE VARCHAR2 (30)
External Reference
OWNER_PARTY_ID NUMBER

Owner Party Id
OWNER_PARTY_SOURCE_TABLE VARCHAR2 (30)
Owner Party Source Table
LOCATION_TYPE_CODE VARCHAR2 (30)
Location Type Code
ORGANIZATION_ID NUMBER
Yes Organization Id
INSTANCE_NAME VARCHAR2 (240)
Instance Name
MAINT_ORGANIZATION_ID NUMBER

Maintenance Organization Id
Query Text

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


SELECT INSTANCE_ID
,      PRODUCT_NAME
,      PRODUCT_DESCRIPTION
,      INVENTORY_ITEM_ID
,      SERIAL_NUMBER
,      SYSTEM_ID
,      SYSTEM_NAME
,      INVENTORY_REVISION
,      PRODUCT_TYPE
,      INSTANCE_STATUS_ID
,      CUSTOMER_PRODUCT_STATUS
,      INSTANCE_NUMBER
,      LOT_NUMBER
,      CUST_PO_NUMBER
,      ORDER_NUMBER
,      PLATFORM_ID
,      PLATFORM
,      PLATFORM_VERSION_ID
,      VERSION
,      INCIDENT_ALLOWED_FLAG
,      PARTY_ACCOUNT_ID
,      LOCATION_ID
,      INV_MASTER_ORGANIZATION_ID
,      EXTERNAL_REFERENCE
,      OWNER_PARTY_ID
,      OWNER_PARTY_SOURCE_TABLE
,      LOCATION_TYPE_CODE
,      ORGANIZATION_ID
,      INSTANCE_NAME
,      MAINT_ORGANIZATION_ID
FROM APPS.CS_SR_CP_NEW_ACCT_EAM_RG_V;

Dependencies

[top of page]

APPS.CS_SR_CP_NEW_ACCT_EAM_RG_V references the following:

SchemaAPPS
SynonymCSI_INSTANCE_STATUSES
SynonymCSI_ITEM_INSTANCES
SynonymCSI_SYSTEMS_B
SynonymCSI_SYSTEMS_TL
SynonymMTL_PARAMETERS
ViewMTL_SYSTEM_ITEMS_VL
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL

APPS.CS_SR_CP_NEW_ACCT_EAM_RG_V is not referenced by any database object