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.CSD_CUSTOMER_SEARCH_V

Object Details

Object Name:	CSD_CUSTOMER_SEARCH_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSD.CSD_CUSTOMER_SEARCH_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)	Yes
PARTY_NAME	VARCHAR2	(360)	Yes
PARTY_NUMBER	VARCHAR2	(30)	Yes
PARTY_TYPE	VARCHAR2	(30)	Yes
ACCOUNT_ID	NUMBER	(15)
ACCOUNT_NUMBER	VARCHAR2	(30)
ACCOUNT_NAME	VARCHAR2	(240)
PHONE_NUMBER	VARCHAR2	(60)
PHONE_TYPE	VARCHAR2	(30)		Phone Line Type Lookup code
PHONE_TYPE_MEANING	VARCHAR2	(80)		Phone Type
SERIAL_NUMBER	VARCHAR2	(30)
INSTANCE_ID	NUMBER		Yes
INSTANCE_NUMBER	VARCHAR2	(30)	Yes
ITEM_REVISION	VARCHAR2	(3)
LOT_NUMBER	VARCHAR2	(80)
QTY	NUMBER		Yes
UOM	VARCHAR2	(3)	Yes
MFG_SERIAL_NUMBER_FLAG	VARCHAR2	(1)
INVENTORY_ORG_ID	NUMBER		Yes
INVENTORY_ITEM_ID	NUMBER		Yes
PRODUCT_NAME	VARCHAR2	(40)
ORGANIZATION_ID	NUMBER		Yes
PRODUCT_DESC	VARCHAR2	(240)
SERIAL_NUMBER_CONTROL_CODE	NUMBER
REVISION_QTY_CONTROL_CODE	NUMBER

Query Text

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


SELECT PARTY_ID
,      PARTY_NAME
,      PARTY_NUMBER
,      PARTY_TYPE
,      ACCOUNT_ID
,      ACCOUNT_NUMBER
,      ACCOUNT_NAME
,      PHONE_NUMBER
,      PHONE_TYPE
,      PHONE_TYPE_MEANING
,      SERIAL_NUMBER
,      INSTANCE_ID
,      INSTANCE_NUMBER
,      ITEM_REVISION
,      LOT_NUMBER
,      QTY
,      UOM
,      MFG_SERIAL_NUMBER_FLAG
,      INVENTORY_ORG_ID
,      INVENTORY_ITEM_ID
,      PRODUCT_NAME
,      ORGANIZATION_ID
,      PRODUCT_DESC
,      SERIAL_NUMBER_CONTROL_CODE
,      REVISION_QTY_CONTROL_CODE
FROM APPS.CSD_CUSTOMER_SEARCH_V;

Dependencies

[top of page]

APPS.CSD_CUSTOMER_SEARCH_V references the following:

APPS: AR_LOOKUPS; CSI_ITEM_INSTANCES; CS_STD - show dependent code; HZ_CONTACT_POINTS; HZ_CUST_ACCOUNTS; HZ_PARTIES; MTL_SYSTEM_ITEMS_VL

APPS.CSD_CUSTOMER_SEARCH_V is not referenced by any database object