[Home] [Help] [Dependency Information]
Object Name: | CS_SR_CP_NEW_ACCT_EAM_NM_RG_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
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 | ||
PRODUCT_NAME | VARCHAR2 | (40) | ||
PRODUCT_DESCRIPTION | VARCHAR2 | (240) | ||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
SERIAL_NUMBER | VARCHAR2 | (30) | ||
SYSTEM_ID | NUMBER | |||
SYSTEM_NAME | VARCHAR2 | (50) | ||
INVENTORY_REVISION | VARCHAR2 | (3) | ||
PRODUCT_TYPE | VARCHAR2 | (30) | ||
INSTANCE_STATUS_ID | NUMBER | Yes | ||
CUSTOMER_PRODUCT_STATUS | VARCHAR2 | (50) | Yes | |
INSTANCE_NUMBER | VARCHAR2 | (30) | Yes | |
LOT_NUMBER | VARCHAR2 | (80) | ||
CUST_PO_NUMBER | VARCHAR2 | (50) | ||
ORDER_NUMBER | NUMBER | |||
PLATFORM_ID | NUMBER | |||
PLATFORM | VARCHAR2 | (0) | ||
PLATFORM_VERSION_ID | NUMBER | |||
VERSION | VARCHAR2 | (0) | ||
INCIDENT_ALLOWED_FLAG | VARCHAR2 | (1) | ||
PARTY_ACCOUNT_ID | NUMBER | |||
LOCATION_ID | NUMBER | |||
INV_MASTER_ORGANIZATION_ID | NUMBER | Yes | ||
EXTERNAL_REFERENCE | VARCHAR2 | (30) | ||
OWNER_PARTY_ID | NUMBER | |||
OWNER_PARTY_SOURCE_TABLE | VARCHAR2 | (30) | ||
LOCATION_TYPE_CODE | VARCHAR2 | (30) | ||
ORGANIZATION_ID | NUMBER | Yes | ||
INSTANCE_NAME | VARCHAR2 | (240) | ||
MAINT_ORGANIZATION_ID | NUMBER |
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_NM_RG_V;
APPS.CS_SR_CP_NEW_ACCT_EAM_NM_RG_V is not referenced by any database object
|
|
|