[Home] [Help] [Dependency Information]
Object Name: | OE_CREDIT_BALANCES_ALL |
---|---|
Object Type: | TABLE |
Owner: | ONT |
FND Design Data: | ONT.OE_CREDIT_BALANCES_ALL |
Subobject Name: | |
Status: | VALID |
Stores the current credit exposure data for each individual customer and site with credit
limits. Each customer(or site)'s credit limit (including default limits) will have one row for
each valid credit rule in the system. This table will be populated by the automatic credit
check concurrent program.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OE_CREDIT_BALANCES_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | CREDIT_BALANCE_ID |
OE_CREDIT_BALANCES_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CUST_ACCOUNT_ID |
OE_CREDIT_BALANCES_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CREDIT_CHECK_RULE_ID |
OE_CREDIT_BALANCES_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CUST_ACCT_PROFILE_AMT_ID |
OE_CREDIT_BALANCES_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CREDIT_PROFILE_AMT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREDIT_BALANCE_ID | NUMBER | Yes | Primary key | |
CUST_ACCOUNT_ID | NUMBER | Yes | References hz_cust_accounts_all | |
CUST_ACCT_PROFILE_AMT_ID | NUMBER | References hz_cust_profile_amts if the credit limit is from a customer/site profile. | ||
CREDIT_PROFILE_AMT_ID | NUMBER | References hz_credit_profile_amts if the credit limit is from an operating unit default profile. | ||
CREDIT_CHECK_RULE_ID | NUMBER | Yes | References oe_credit_check_rules | |
OVERALL_EXPOSURE | NUMBER | Sum of orders, orders_on_hold, payments_overdue, payments_at_risk columns | ||
ORDERS | NUMBER | Uninvoiced orders of the customer/site | ||
ORDERS_ON_HOLD | NUMBER | Orders on hold of the customer/site | ||
PAYMENTS_OVERDUE | NUMBER | Payments overdue of thecustomer/site | ||
PAYMENTS_AT_RISK | NUMBER | Payments at risk of the customer/site | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who column | |
PROGRAM_APPLICATION_ID | NUMBER | Application of concurrent program that last updated row. | ||
PROGRAM_ID | NUMBER | Concurrent program that last updated row. | ||
PROGRAM_UPDATE_DATE | DATE | Last date changed by concurrent program | ||
REQUEST_ID | NUMBER | Concurrent request that last changed row | ||
ORG_ID | NUMBER | Organization id of the operating unit | ||
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT CREDIT_BALANCE_ID
, CUST_ACCOUNT_ID
, CUST_ACCT_PROFILE_AMT_ID
, CREDIT_PROFILE_AMT_ID
, CREDIT_CHECK_RULE_ID
, OVERALL_EXPOSURE
, ORDERS
, ORDERS_ON_HOLD
, PAYMENTS_OVERDUE
, PAYMENTS_AT_RISK
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, ORG_ID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM ONT.OE_CREDIT_BALANCES_ALL;
ONT.OE_CREDIT_BALANCES_ALL does not reference any database object
ONT.OE_CREDIT_BALANCES_ALL is referenced by following:
|
|
|