DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.QPR_SR_CUSTOMER_HISTORY_V

Object Details
Object Name: QPR_SR_CUSTOMER_HISTORY_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Customer history measures


[View Source]

Columns
Name Datatype Length Mandatory Comments
CUST_ACCOUNT_ID NUMBER (15) Yes Customer account
PARTY_SITE_ID NUMBER (15) Yes Party id
CURRENCY VARCHAR2 (4000)
Currency
CUSTOMER_NAME VARCHAR2 (240)
Name
ADDRESS VARCHAR2 (545)
Address
INDUSTRY VARCHAR2 (30)
Industry
ANNUAL_REVENUE NUMBER

Annual revenue
OVERALL_CREDIT_LIMIT NUMBER

Overall credit limit
TRANSACTION_CREDIT_LIMIT NUMBER

Transaction credit limit
RISK_CODE VARCHAR2 (30)
Risk code
ACCOUNT_STATUS VARCHAR2 (30)
Account status
AVAILABLE_CREDIT NUMBER

Available credit
PAST_DUE_TRANSACTIONS NUMBER

Past due transactions
AVERAGE_DAYS_LATE NUMBER

Average days late
RECEIPTS_AT_RISK_VALUE NUMBER

Receipts at risk value
Query Text

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


SELECT CUST_ACCOUNT_ID
,      PARTY_SITE_ID
,      CURRENCY
,      CUSTOMER_NAME
,      ADDRESS
,      INDUSTRY
,      ANNUAL_REVENUE
,      OVERALL_CREDIT_LIMIT
,      TRANSACTION_CREDIT_LIMIT
,      RISK_CODE
,      ACCOUNT_STATUS
,      AVAILABLE_CREDIT
,      PAST_DUE_TRANSACTIONS
,      AVERAGE_DAYS_LATE
,      RECEIPTS_AT_RISK_VALUE
FROM APPS.QPR_SR_CUSTOMER_HISTORY_V;

Dependencies

[top of page]

APPS.QPR_SR_CUSTOMER_HISTORY_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES
SynonymAR_TRX_BAL_SUMMARY
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHZP_CUST_PKG - show dependent code
SynonymHZ_CUSTOMER_PROFILES
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES

APPS.QPR_SR_CUSTOMER_HISTORY_V is not referenced by any database object