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


VIEW: APPS.CS_SR_FIND_PROD_MAINT_P_EAM_V

Object Details
Object Name: CS_SR_FIND_PROD_MAINT_P_EAM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_FIND_PROD_MAINT_P_EAM_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
PRINCIPAL_PARTY_NAME VARCHAR2 (360) Yes Party Name
CUSTOMER_PRODUCT_ID NUMBER
Yes Customer Product Id
CUSTOMER_ID NUMBER (15) Yes Customer Id
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Id
MOST_RECENT_FLAG CHAR (1)
Most Recent Flag
CURRENT_SERIAL_NUMBER VARCHAR2 (30)
Current Serial Number
TYPE_CODE VARCHAR2 (30)
Type Code
SYSTEM_ID NUMBER

System Id
SYSTEM VARCHAR2 (50)
System Name
ORIGINAL_ORDER_DATE DATE

Original Order Date
ORIGINAL_ORDER_NUMBER NUMBER
Yes Original Order Number
INSTALL_SITE_USE_ID VARCHAR2 (0)
Install Site Use Id
PARENT_CP_ID NUMBER

Parent Cp Id
CUSTOMER_PRODUCT_STATUS_ID NUMBER
Yes Customer Product Status Id
REFERENCE_NUMBER VARCHAR2 (30) Yes Reference Number
PURCHASE_ORDER_NUM VARCHAR2 (50)
Purchase Order Number
CP_LOT_NUMBER VARCHAR2 (80)
Cp Lot Number
REVISION VARCHAR2 (3)
Revision
INSTANCE_NAME VARCHAR2 (240)
Instance Name
PRODUCT_DESCRIPTION VARCHAR2 (240)
Product Description
SERVICED_STATUS_FLAG CHAR (1)
Service Status Flag
ORIGINAL_LINE_NUMBER NUMBER
Yes Original Line Number
SHIPPED_DATE DATE

Shipped Date
QUANTITY NUMBER
Yes Quantity
EXTERNAL_REFERENCE VARCHAR2 (30)
External Reference
LOCATION_TYPE_CODE VARCHAR2 (30)
Location Type Code
ACCOUNT_ID NUMBER

Account Id
ACCOUNT_NUMBER VARCHAR2 (30)
Account number
ORGANIZATION_ID NUMBER
Yes Organization Id
LOCATION_ID NUMBER

Location Id
PRODUCT_NAME VARCHAR2 (40)
Product Name
MAINT_ORGANIZATION_ID NUMBER

Maint Organization Id
CUSTOMER_NUMBER VARCHAR2 (30) Yes
Query Text

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


SELECT PRINCIPAL_PARTY_NAME
,      CUSTOMER_PRODUCT_ID
,      CUSTOMER_ID
,      INVENTORY_ITEM_ID
,      MOST_RECENT_FLAG
,      CURRENT_SERIAL_NUMBER
,      TYPE_CODE
,      SYSTEM_ID
,      SYSTEM
,      ORIGINAL_ORDER_DATE
,      ORIGINAL_ORDER_NUMBER
,      INSTALL_SITE_USE_ID
,      PARENT_CP_ID
,      CUSTOMER_PRODUCT_STATUS_ID
,      REFERENCE_NUMBER
,      PURCHASE_ORDER_NUM
,      CP_LOT_NUMBER
,      REVISION
,      INSTANCE_NAME
,      PRODUCT_DESCRIPTION
,      SERVICED_STATUS_FLAG
,      ORIGINAL_LINE_NUMBER
,      SHIPPED_DATE
,      QUANTITY
,      EXTERNAL_REFERENCE
,      LOCATION_TYPE_CODE
,      ACCOUNT_ID
,      ACCOUNT_NUMBER
,      ORGANIZATION_ID
,      LOCATION_ID
,      PRODUCT_NAME
,      MAINT_ORGANIZATION_ID
,      CUSTOMER_NUMBER
FROM APPS.CS_SR_FIND_PROD_MAINT_P_EAM_V;

Dependencies

[top of page]

APPS.CS_SR_FIND_PROD_MAINT_P_EAM_V references the following:

SchemaAPPS
SynonymCSI_INSTANCE_STATUSES
SynonymCSI_ITEM_INSTANCES
SynonymCSI_SYSTEMS_B
SynonymCSI_SYSTEMS_TL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymMTL_PARAMETERS
ViewMTL_SYSTEM_ITEMS_VL
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL

APPS.CS_SR_FIND_PROD_MAINT_P_EAM_V is not referenced by any database object