[Home] [Help] [Dependency Information]
Object Name: | OIE_DUP_DETECT_RULES# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | Yes | ||
RULE_NAME | VARCHAR2 | (90) | Yes | |
RULE_TYPE | VARCHAR2 | (90) | Yes | |
DESCRIPTION | VARCHAR2 | (720) | Yes | |
DETECT_EMPLOYEE_FLAG | VARCHAR2 | (3) | Yes | |
DETECT_RECEIPT_DATE_FLAG | VARCHAR2 | (3) | Yes | |
DETECT_EXP_CATEGORY_FLAG | VARCHAR2 | (3) | Yes | |
DETECT_EXPENSE_TYPE_FLAG | VARCHAR2 | (3) | ||
DETECT_RECEIPT_AMT_FLAG | VARCHAR2 | (3) | ||
DETECT_END_DATE_FLAG | VARCHAR2 | (3) | ||
DETECT_MERCHANT_FLAG | VARCHAR2 | (3) | ||
DETECT_CLASS_OF_TICKET_FLAG | VARCHAR2 | (3) | ||
DETECT_TICKET_NUM_FLAG | VARCHAR2 | (3) | ||
DETECT_FROM_LOCATION_FLAG | VARCHAR2 | (3) | ||
DETECT_TO_LOCATION_FLAG | VARCHAR2 | (3) | ||
DETECT_DISTANCE_UOM_FLAG | VARCHAR2 | (3) | ||
DETECT_DAILY_TRIP_DIST_FLAG | VARCHAR2 | (3) | ||
DETECT_LOCATION_FIELDS_FLAG | VARCHAR2 | (3) | ||
DETECT_VLP_NUM_FLAG | VARCHAR2 | (3) | ||
DETECT_ATTENDEE_FLAG | VARCHAR2 | (3) | ||
DUPLICATES_ALLOWED | NUMBER | Yes | ||
DUPLICATE_DETECTION_ACTION | VARCHAR2 | (90) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LAST_UPDATED_BY | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ID
, RULE_NAME
, RULE_TYPE
, DESCRIPTION
, DETECT_EMPLOYEE_FLAG
, DETECT_RECEIPT_DATE_FLAG
, DETECT_EXP_CATEGORY_FLAG
, DETECT_EXPENSE_TYPE_FLAG
, DETECT_RECEIPT_AMT_FLAG
, DETECT_END_DATE_FLAG
, DETECT_MERCHANT_FLAG
, DETECT_CLASS_OF_TICKET_FLAG
, DETECT_TICKET_NUM_FLAG
, DETECT_FROM_LOCATION_FLAG
, DETECT_TO_LOCATION_FLAG
, DETECT_DISTANCE_UOM_FLAG
, DETECT_DAILY_TRIP_DIST_FLAG
, DETECT_LOCATION_FIELDS_FLAG
, DETECT_VLP_NUM_FLAG
, DETECT_ATTENDEE_FLAG
, DUPLICATES_ALLOWED
, DUPLICATE_DETECTION_ACTION
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
FROM AP.OIE_DUP_DETECT_RULES#;
|
|
|