[Home] [Help] [Dependency Information]
Object Name: | CS_SR_CP_NEW_ACCT_EAM_RG_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CS.CS_SR_CP_NEW_ACCT_EAM_RG_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.CS_SR_CP_NEW_ACCT_EAM_RG_V is not referenced by any database object
|
|
|