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

Object Details

Object Name:	XNB_CUST_PROFILE_AMTS_V
Object Type:	VIEW
Owner:	APPS
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
CUST_ACCT_PROFILE_AMT_ID	NUMBER	(15)	Yes	Customer Profile Amount Identifier
CUST_ACCOUNT_ID	NUMBER	(15)	Yes	Customer Account Identifier
SITE_USE_ID	NUMBER	(15)		Site Use Identifier
CUST_ACCOUNT_PROFILE_ID	NUMBER	(15)	Yes	Customer Account Profile Id
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
TRX_CREDIT_LIMIT	NUMBER			Transaction Credit Limit
OVERALL_CREDIT_LIMIT	NUMBER			Over All Credit Limit
MIN_DUNNING_AMOUNT	NUMBER			Minimum Dunning Amount
MIN_DUNNING_INVOICE_AMOUNT	NUMBER			Minimum Dunning Invoice Amount
MAX_INTEREST_CHARGE	NUMBER			Maximum Interest Charge
MIN_STATEMENT_AMOUNT	NUMBER			Minimum Statement Amount
AUTO_REC_MIN_RECEIPT_AMOUNT	NUMBER			Auto Rec Minimum Receipt Amount
INTEREST_RATE	NUMBER			Interest Rate
MIN_FC_BALANCE_AMOUNT	NUMBER			Minimum FC Balance Amount
MIN_FC_INVOICE_AMOUNT	NUMBER			Minimum FC Invoice Amount
EXPIRATION_DATE	DATE			Expiration Date
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category
ATTRIBUTE1	VARCHAR2	(150)		Attribute1
ATTRIBUTE2	VARCHAR2	(150)		Attribute2
ATTRIBUTE3	VARCHAR2	(150)		Attribute3
ATTRIBUTE4	VARCHAR2	(150)		Attribute4
ATTRIBUTE5	VARCHAR2	(150)		Attribute5
ATTRIBUTE6	VARCHAR2	(150)		Attribute6
ATTRIBUTE7	VARCHAR2	(150)		Attribute7
ATTRIBUTE8	VARCHAR2	(150)		Attribute8
ATTRIBUTE9	VARCHAR2	(150)		Attribute9
ATTRIBUTE10	VARCHAR2	(150)		Attribute10
ATTRIBUTE11	VARCHAR2	(150)		Attribute11
ATTRIBUTE12	VARCHAR2	(150)		Attribute12
ATTRIBUTE13	VARCHAR2	(150)		Attribute13
ATTRIBUTE14	VARCHAR2	(150)		Attribute14
ATTRIBUTE15	VARCHAR2	(150)		Attribute15

Query Text

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


SELECT CUST_ACCT_PROFILE_AMT_ID
,      CUST_ACCOUNT_ID
,      SITE_USE_ID
,      CUST_ACCOUNT_PROFILE_ID
,      CURRENCY_CODE
,      TRX_CREDIT_LIMIT
,      OVERALL_CREDIT_LIMIT
,      MIN_DUNNING_AMOUNT
,      MIN_DUNNING_INVOICE_AMOUNT
,      MAX_INTEREST_CHARGE
,      MIN_STATEMENT_AMOUNT
,      AUTO_REC_MIN_RECEIPT_AMOUNT
,      INTEREST_RATE
,      MIN_FC_BALANCE_AMOUNT
,      MIN_FC_INVOICE_AMOUNT
,      EXPIRATION_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.XNB_CUST_PROFILE_AMTS_V;

Dependencies

[top of page]

APPS.XNB_CUST_PROFILE_AMTS_V references the following:

APPS: HZ_CUSTOMER_PROFILES; HZ_CUST_PROFILE_AMTS

APPS.XNB_CUST_PROFILE_AMTS_V is not referenced by any database object