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: AR.AR_CMGT_GUARANTOR_DATA#

Object Details

Object Name:	AR_CMGT_GUARANTOR_DATA#
Object Type:	VIEW
Owner:	AR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
DATAPOINT_ID	NUMBER	(15)	Yes
CREDIT_REQUEST_ID	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
COUNTRY	VARCHAR2	(60)
TAX_NUMBER	VARCHAR2	(50)
REFERENCE_NAME	VARCHAR2	(360)
CONTACT_NAME	VARCHAR2	(50)
ADDRESS	VARCHAR2	(100)
PHONE_NUMBER	VARCHAR2	(20)
CITY	VARCHAR2	(60)
FAX_NUMBER	VARCHAR2	(20)
STATE	VARCHAR2	(60)
EMAIL	VARCHAR2	(240)
POSTAL_CODE	VARCHAR2	(60)
PROVINCE	VARCHAR2	(60)
URL	VARCHAR2	(240)
CURRENCY	VARCHAR2	(30)
GUARANTEED_AMOUNT	NUMBER
FUNDING_AVAILABLE_FROM	DATE
FUNDING_AVAILABLE_TO	DATE
CASE_FOLDER_ID	NUMBER	(15)
NOTES	VARCHAR2	(2000)
GUARANTOR_CREDIT_REQUEST_ID	NUMBER	(15)
ASSET_CLASS_CODE	VARCHAR2	(30)
ASSET_TYPE_CODE	VARCHAR2	(30)
DESCRIPTION	VARCHAR2	(360)
QUANTITY	NUMBER
UOM_CODE	VARCHAR2	(30)
REFERENCE_TYPE	VARCHAR2	(30)
ASSET_IDENTIFIER	VARCHAR2	(250)
APPRAISER	VARCHAR2	(250)
APPRAISER_PHONE	VARCHAR2	(80)
VALUATION	NUMBER
VALUATION_METHOD_CODE	VARCHAR2	(30)
VALUATION_DATE	DATE
ACQUISITION_DATE	DATE
PARTY_ID	NUMBER	(15)
CONTACT_PARTY_ID	NUMBER	(15)
CREDIT_CLASSIFICATION	VARCHAR2	(30)
REVIEW_TYPE	VARCHAR2	(30)

Query Text

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


SELECT DATAPOINT_ID
,      CREDIT_REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COUNTRY
,      TAX_NUMBER
,      REFERENCE_NAME
,      CONTACT_NAME
,      ADDRESS
,      PHONE_NUMBER
,      CITY
,      FAX_NUMBER
,      STATE
,      EMAIL
,      POSTAL_CODE
,      PROVINCE
,      URL
,      CURRENCY
,      GUARANTEED_AMOUNT
,      FUNDING_AVAILABLE_FROM
,      FUNDING_AVAILABLE_TO
,      CASE_FOLDER_ID
,      NOTES
,      GUARANTOR_CREDIT_REQUEST_ID
,      ASSET_CLASS_CODE
,      ASSET_TYPE_CODE
,      DESCRIPTION
,      QUANTITY
,      UOM_CODE
,      REFERENCE_TYPE
,      ASSET_IDENTIFIER
,      APPRAISER
,      APPRAISER_PHONE
,      VALUATION
,      VALUATION_METHOD_CODE
,      VALUATION_DATE
,      ACQUISITION_DATE
,      PARTY_ID
,      CONTACT_PARTY_ID
,      CREDIT_CLASSIFICATION
,      REVIEW_TYPE
FROM AR.AR_CMGT_GUARANTOR_DATA#;

Dependencies

[top of page]

AR.AR_CMGT_GUARANTOR_DATA# references the following:

AR: AR_CMGT_GUARANTOR_DATA

AR.AR_CMGT_GUARANTOR_DATA# is referenced by following:

APPS: AR_CMGT_GUARANTOR_DATA