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

Object Details

Object Name:	IGI_AR_CUSTOMERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGI.IGI_AR_CUSTOMERS_V
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Public Sector Financials (International) view that lists receivables customer details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_ID	NUMBER	(15)	Yes	Customer account identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
CUSTOMER_NAME	VARCHAR2	(50)		Customer name
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes	Customer number
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)	Yes	Original system reference
STATUS	VARCHAR2	(1)	Yes	Status
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
CUSTOMER_PROSPECT_CODE	VARCHAR2	(30)		Customer prospect code
JGZZ_FISCAL_CODE	VARCHAR2	(20)		Taxpayer ID
CUSTOMER_NAME_PHONETIC	VARCHAR2	(320)		Customer name phonetic
TAX_REFERENCE	VARCHAR2	(50)		Tax reference
STP_TYPE	VARCHAR2	(80)		Single third party Type
STP_TYPE_MEANING	VARCHAR2	(80)		Single third party meaning
WAREHOUSE_ID	NUMBER	(15)		Warehouse ID
CUSTOMER_KEY	VARCHAR2	(500)		Customer key
ROW_ID	ROWID	(10)		Row ID
STP_ENFORCE_THRESHOLD	VARCHAR2	(1)		Single third party threshold

Query Text

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


SELECT CUSTOMER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      ORIG_SYSTEM_REFERENCE
,      STATUS
,      LAST_UPDATE_LOGIN
,      CUSTOMER_PROSPECT_CODE
,      JGZZ_FISCAL_CODE
,      CUSTOMER_NAME_PHONETIC
,      TAX_REFERENCE
,      STP_TYPE
,      STP_TYPE_MEANING
,      WAREHOUSE_ID
,      CUSTOMER_KEY
,      ROW_ID
,      STP_ENFORCE_THRESHOLD
FROM APPS.IGI_AR_CUSTOMERS_V;

Dependencies

[top of page]

APPS.IGI_AR_CUSTOMERS_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_PARTIES; IGI_LOOKUPS; IGI_RA_CUSTOMERS

APPS.IGI_AR_CUSTOMERS_V is referenced by following:

APPS: IGI_STP_TABLE_HANDLER_PKG - show dependent code