[Home] [Help] [Dependency Information]
Object Name: | AR_CMGT_CREDIT_REQUESTS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_CMGT_CREDIT_REQUESTS |
Subobject Name: | |
Status: | VALID |
The AR_CMGT_CREDIT_REQUESTS table stores information for each credit request. A credit request is created from the Credit Application window in Oracle Credit Management or from the Credit Request API. All credit requests initiate a workflow process to guide the credit analysis.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_CMGT_CREDIT_REQUESTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CREDIT_REQUEST_ID |
AR_CMGT_CREDIT_REQUESTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | APPLICATION_NUMBER |
AR_CMGT_CREDIT_REQUESTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
REQUESTOR_ID
REVIEW_TYPE |
AR_CMGT_CREDIT_REQUESTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARTY_ID
CUST_ACCOUNT_ID SITE_USE_ID |
AR_CMGT_CREDIT_REQUESTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
REQUESTOR_ID
STATUS |
AR_CMGT_CREDIT_REQUESTS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARTY_ID
STATUS |
AR_CMGT_CREDIT_REQUESTS_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CREDIT_ANALYST_ID
REVIEW_TYPE STATUS |
AR_CMGT_CREDIT_REQUESTS_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREDIT_REQUEST_ID | NUMBER | (15) | Yes | Identifier of the credit request |
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). |
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). | |
APPLICATION_NUMBER | VARCHAR2 | (30) | Yes | Credit request application number |
APPLICATION_DATE | DATE | Credit request application date | ||
REQUESTOR_TYPE | VARCHAR2 | (30) | Credit request application number | |
REQUESTOR_ID | NUMBER | (15) | Identifier of the person who placed the credit request. For the requestor_type EMPLOYEE, this is the person_id of the employee stored in the HR tables. | |
REVIEW_TYPE | VARCHAR2 | (30) | Type of credit review to be conducted on the credit request Values are in the AR_LOOKUPS table with the lookup_type AR_CMGT_REVIEW_TYPE | |
CREDIT_CLASSIFICATION | VARCHAR2 | (30) | Credit classification of the customer for whom the credit request was created The credit classification reflects the customer's existing or initially assessed creditworthiness Values are in the AR_LOOKUPS table with a lookup_type of AR_CMGT_CREDIT_CLASS | |
CHECK_LIST_ID | NUMBER | (15) | Identifier of the checklist | |
CREDIT_ANALYST_ID | NUMBER | (15) | Resource identifier (resource_id) of the credit analyst | |
LIMIT_AMOUNT | NUMBER | Requested credit limit amount | ||
LIMIT_CURRENCY | VARCHAR2 | (30) | Requested credit limit currency | |
TRX_AMOUNT | NUMBER | The amount of the customer's transaction that created the credit request, such as the order amount of an order placed on credit hold | ||
TRX_CURRENCY | VARCHAR2 | (30) | Currency of the customer's transaction that created the credit request | |
CREDIT_CHECK_RULE_ID | NUMBER | (15) | Identifier of the credit checking rule, defined in Oracle Order Management, which is used to calculate credit exposure for the credit analysis The rule also provides the exchange_rate_type for currency conversions required to calculate the AR balances | |
TERM_LENGTH | NUMBER | Desired period, in months, of term credit from the credit applicant | ||
CREDIT_TYPE | VARCHAR2 | (30) | Type of credit requested by the applicant, either TERM or TRADE | |
PARTY_ID | NUMBER | (15) | Identifier of the party under credit review Foreign key to the HZ_PARTIES table | |
CUST_ACCOUNT_ID | NUMBER | (15) | Identifier of the account under credit review Foreign key to the HZ_CUST_ACCOUNTS table | |
CUST_ACCT_SITE_ID | NUMBER | (15) | Identifier of the account site under credit review | |
SITE_USE_ID | NUMBER | (15) | Identifier of the bill-to site use location for the account under credit review | |
CONTACT_PARTY_ID | NUMBER | (15) | Contact identifier of the person identified on the credit application as the credit contact | |
STOCK_EXCHANGE | VARCHAR2 | (50) | Identifies the stock exchange where the company under credit review trades its securities | |
CURRENT_STOCK_PRICE | NUMBER | Current price of the stock for the company under creditreview | ||
STOCK_CURRENCY | VARCHAR2 | (30) | Currency of the current stock price for the company under credit review | |
MARKET_CAPITALIZATION | NUMBER | Total amount of the company's outstanding shares of stock at the current stock price | ||
MARKET_CAP_MONETARY_UNIT | VARCHAR2 | (15) | Currency multiplier for the market capitalization amount For example, 000 indicates that the amount is multiplied by 1000 | |
PENDING_LITIGATIONS | NUMBER | Number of pending litigations currently open for the company under credit review | ||
BOND_RATING | VARCHAR2 | (30) | Bond Rating of the company under credit review | |
LEGAL_ENTITY_NAME | VARCHAR2 | (240) | Legal name of the company under credit review, if different from the organization name used in HZ_PARTIES.PARTY_NAME | |
ENTITY_TYPE | VARCHAR2 | (30) | Business entity type of the company under credit review Values are in the AR_LOOKUPS table with a lookup_type of AR_CMGT_ENTITY_TYPE | |
CASE_FOLDER_NUMBER | VARCHAR2 | (30) | Unique identification number for the case folder used to store all information used during the credit review | |
SCORE_MODEL_ID | NUMBER | (15) | Identifier of the scoring model associated with this case folder | |
ATTACHMENT_FLAG | VARCHAR2 | (1) | Attachment flag | |
STATUS | VARCHAR2 | (15) | Yes | Status of the case folder |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
SOURCE_NAME | VARCHAR2 | (30) | Name of the source calling the Credit Request API, such as Order Management | |
SOURCE_USER_ID | NUMBER | (15) | User identifier calling the Credit Request API | |
SOURCE_RESP_ID | NUMBER | (15) | Responsibility identifier calling the Credit Request API | |
SOURCE_RESP_APPLN_ID | NUMBER | (15) | Application identifier calling the Credit Request API | |
SOURCE_SECURITY_GROUP_ID | NUMBER | (15) | Security group identifier calling the Credit Request API | |
SOURCE_ORG_ID | NUMBER | (15) | Operating unit identifier calling the Credit Request API | |
SOURCE_COLUMN1 | VARCHAR2 | (150) | Unique identifier of the information supplied to the Credit Request API, such as order_id from Oracle Order Management | |
SOURCE_COLUMN2 | VARCHAR2 | (150) | Source data identifier of the information supplied to the Credit Request API | |
SOURCE_COLUMN3 | VARCHAR2 | (150) | Additional data identifier of the information supplied to the Credit Request API | |
NOTES | VARCHAR2 | (2000) | Free-form notes to clarify the credit request | |
REVIEW_CYCLE | VARCHAR2 | (30) | Stores the periodic credit review cycles | |
PARENT_CREDIT_REQUEST_ID | NUMBER | (15) | Identifier of credit request that initiated the collection of this guarantor. | |
CREDIT_REQUEST_TYPE | VARCHAR2 | (30) | Credit request type identifier | |
RECOMMENDATION_NAME | VARCHAR2 | (60) | Custom recommendation lookup type | |
REASON_CODE | VARCHAR2 | (30) | Credit request reason code |
Cut, paste (and edit) the following text to query this object:
SELECT CREDIT_REQUEST_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, APPLICATION_NUMBER
, APPLICATION_DATE
, REQUESTOR_TYPE
, REQUESTOR_ID
, REVIEW_TYPE
, CREDIT_CLASSIFICATION
, CHECK_LIST_ID
, CREDIT_ANALYST_ID
, LIMIT_AMOUNT
, LIMIT_CURRENCY
, TRX_AMOUNT
, TRX_CURRENCY
, CREDIT_CHECK_RULE_ID
, TERM_LENGTH
, CREDIT_TYPE
, PARTY_ID
, CUST_ACCOUNT_ID
, CUST_ACCT_SITE_ID
, SITE_USE_ID
, CONTACT_PARTY_ID
, STOCK_EXCHANGE
, CURRENT_STOCK_PRICE
, STOCK_CURRENCY
, MARKET_CAPITALIZATION
, MARKET_CAP_MONETARY_UNIT
, PENDING_LITIGATIONS
, BOND_RATING
, LEGAL_ENTITY_NAME
, ENTITY_TYPE
, CASE_FOLDER_NUMBER
, SCORE_MODEL_ID
, ATTACHMENT_FLAG
, STATUS
, REQUEST_ID
, SOURCE_NAME
, SOURCE_USER_ID
, SOURCE_RESP_ID
, SOURCE_RESP_APPLN_ID
, SOURCE_SECURITY_GROUP_ID
, SOURCE_ORG_ID
, SOURCE_COLUMN1
, SOURCE_COLUMN2
, SOURCE_COLUMN3
, NOTES
, REVIEW_CYCLE
, PARENT_CREDIT_REQUEST_ID
, CREDIT_REQUEST_TYPE
, RECOMMENDATION_NAME
, REASON_CODE
FROM AR.AR_CMGT_CREDIT_REQUESTS;
AR.AR_CMGT_CREDIT_REQUESTS does not reference any database object
AR.AR_CMGT_CREDIT_REQUESTS is referenced by following:
|
|
|