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]

TABLE: AR.AR_CMGT_CREDIT_REQUESTS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

AR.AR_CMGT_CREDIT_REQUESTS does not reference any database object

AR.AR_CMGT_CREDIT_REQUESTS is referenced by following:

AR: AR_CMGT_CREDIT_REQUESTS#