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

VIEW: AR.AR_CMGT_CASE_FOLDERS#

Object Details
Object Name: AR_CMGT_CASE_FOLDERS#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CASE_FOLDER_ID NUMBER (15) Yes
CASE_FOLDER_NUMBER VARCHAR2 (30) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
CREDIT_REQUEST_ID NUMBER (15)
CHECK_LIST_ID NUMBER (15)
STATUS VARCHAR2 (15)
CUST_ACCOUNT_ID NUMBER (15)
PARTY_ID NUMBER (15)
SCORE_MODEL_ID NUMBER (15)
SITE_USE_ID NUMBER (15)
CREDIT_CLASSIFICATION VARCHAR2 (30)
REVIEW_TYPE VARCHAR2 (30)
CREDIT_ANALYST_ID NUMBER (15)
TYPE VARCHAR2 (15) Yes
DISPLAY_FLAG VARCHAR2 (1)
CREATION_DATE_TIME DATE

LAST_UPDATED DATE

LIMIT_CURRENCY VARCHAR2 (30)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
REVIEW_CYCLE VARCHAR2 (30)
REQUEST_ID NUMBER (15)
PREVIOUS_CREDIT_ANALYST_ID NUMBER (15)
ORIGINAL_CREDIT_ANALYST_ID NUMBER (15)
Query Text

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


SELECT CASE_FOLDER_ID
,      CASE_FOLDER_NUMBER
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CREDIT_REQUEST_ID
,      CHECK_LIST_ID
,      STATUS
,      CUST_ACCOUNT_ID
,      PARTY_ID
,      SCORE_MODEL_ID
,      SITE_USE_ID
,      CREDIT_CLASSIFICATION
,      REVIEW_TYPE
,      CREDIT_ANALYST_ID
,      TYPE
,      DISPLAY_FLAG
,      CREATION_DATE_TIME
,      LAST_UPDATED
,      LIMIT_CURRENCY
,      EXCHANGE_RATE_TYPE
,      REVIEW_CYCLE
,      REQUEST_ID
,      PREVIOUS_CREDIT_ANALYST_ID
,      ORIGINAL_CREDIT_ANALYST_ID
FROM AR.AR_CMGT_CASE_FOLDERS#;

Dependencies

[top of page]

AR.AR_CMGT_CASE_FOLDERS# references the following:

SchemaAR
TableAR_CMGT_CASE_FOLDERS
AR.AR_CMGT_CASE_FOLDERS# is referenced by following:

SchemaAPPS
SynonymAR_CMGT_CASE_FOLDERS