[Home] [Help] [Dependency Information]
Object Name: | AR_CMGT_CREDIT_REQUESTS# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREDIT_REQUEST_ID | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
APPLICATION_NUMBER | VARCHAR2 | (30) | Yes | |
APPLICATION_DATE | DATE | |||
REQUESTOR_TYPE | VARCHAR2 | (30) | ||
REQUESTOR_ID | NUMBER | (15) | ||
REVIEW_TYPE | VARCHAR2 | (30) | ||
CREDIT_CLASSIFICATION | VARCHAR2 | (30) | ||
CHECK_LIST_ID | NUMBER | (15) | ||
CREDIT_ANALYST_ID | NUMBER | (15) | ||
LIMIT_AMOUNT | NUMBER | |||
LIMIT_CURRENCY | VARCHAR2 | (30) | ||
TRX_AMOUNT | NUMBER | |||
TRX_CURRENCY | VARCHAR2 | (30) | ||
CREDIT_CHECK_RULE_ID | NUMBER | (15) | ||
TERM_LENGTH | NUMBER | |||
CREDIT_TYPE | VARCHAR2 | (30) | ||
PARTY_ID | NUMBER | (15) | ||
CUST_ACCOUNT_ID | NUMBER | (15) | ||
CUST_ACCT_SITE_ID | NUMBER | (15) | ||
SITE_USE_ID | NUMBER | (15) | ||
CONTACT_PARTY_ID | NUMBER | (15) | ||
STOCK_EXCHANGE | VARCHAR2 | (50) | ||
CURRENT_STOCK_PRICE | NUMBER | |||
STOCK_CURRENCY | VARCHAR2 | (30) | ||
MARKET_CAPITALIZATION | NUMBER | |||
MARKET_CAP_MONETARY_UNIT | VARCHAR2 | (15) | ||
PENDING_LITIGATIONS | NUMBER | |||
BOND_RATING | VARCHAR2 | (30) | ||
LEGAL_ENTITY_NAME | VARCHAR2 | (240) | ||
ENTITY_TYPE | VARCHAR2 | (30) | ||
CASE_FOLDER_NUMBER | VARCHAR2 | (30) | ||
SCORE_MODEL_ID | NUMBER | (15) | ||
ATTACHMENT_FLAG | VARCHAR2 | (1) | ||
STATUS | VARCHAR2 | (15) | Yes | |
REQUEST_ID | NUMBER | (15) | ||
SOURCE_NAME | VARCHAR2 | (30) | ||
SOURCE_USER_ID | NUMBER | (15) | ||
SOURCE_RESP_ID | NUMBER | (15) | ||
SOURCE_RESP_APPLN_ID | NUMBER | (15) | ||
SOURCE_SECURITY_GROUP_ID | NUMBER | (15) | ||
SOURCE_ORG_ID | NUMBER | (15) | ||
SOURCE_COLUMN1 | VARCHAR2 | (150) | ||
SOURCE_COLUMN2 | VARCHAR2 | (150) | ||
SOURCE_COLUMN3 | VARCHAR2 | (150) | ||
NOTES | VARCHAR2 | (2000) | ||
REVIEW_CYCLE | VARCHAR2 | (30) | ||
PARENT_CREDIT_REQUEST_ID | NUMBER | (15) | ||
CREDIT_REQUEST_TYPE | VARCHAR2 | (30) | ||
RECOMMENDATION_NAME | VARCHAR2 | (60) | ||
REASON_CODE | VARCHAR2 | (30) |
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#;
|
|
|