eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	CS.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
ORGANIZATION_ID	NUMBER		Yes	Organization Id
LOCATION_ID	NUMBER			Location Id
PRODUCT_NAME	VARCHAR2	(40)		Product Name
MAINT_ORGANIZATION_ID	NUMBER			Maint Organization Id

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
,      ORGANIZATION_ID
,      LOCATION_ID
,      PRODUCT_NAME
,      MAINT_ORGANIZATION_ID
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:

APPS: CSI_INSTANCE_STATUSES; CSI_ITEM_INSTANCES; CSI_SYSTEMS_B; CSI_SYSTEMS_TL; HZ_PARTIES; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_VL; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL

APPS.CS_SR_FIND_PROD_MAINT_P_EAM_V is not referenced by any database object