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: AP.OIE_DUP_DETECT_RULES

Object Details

Object Name:	OIE_DUP_DETECT_RULES
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.OIE_DUP_DETECT_RULES
Subobject Name:
Status:	VALID

OIE Duplicate Detection Rules

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OIE_DUP_DETECT_RULES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RULE_ID RULE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_ID	NUMBER		Yes	Duplicate Detection Rule Identifier
RULE_NAME	VARCHAR2	(90)	Yes	Holds the name of the duplicate detection rule
RULE_TYPE	VARCHAR2	(90)	Yes	Holds the rule type, which can be either Accommodations or Airfare or Car Rental or Generic or Meals or Mileage or Miscellaneous or PerDiem
DESCRIPTION	VARCHAR2	(720)	Yes	Holds the description of the duplicate detection rule
DETECT_EMPLOYEE_FLAG	VARCHAR2	(3)	Yes	This flag indicates whether Employee is considered for performing the duplicate detection. This is an required attribute and this flag always be Y
DETECT_RECEIPT_DATE_FLAG	VARCHAR2	(3)	Yes	This flag indicates whether Receipt Date is considered for performing the duplicate detection. This is an required attribute and this flag always be Y
DETECT_EXP_CATEGORY_FLAG	VARCHAR2	(3)	Yes	This flag indicates whether Expense Category is considered for performing the duplicate detection. This is an required attribute and this flag always be Y
DETECT_EXPENSE_TYPE_FLAG	VARCHAR2	(3)		This flag indicates whether Expense Type is considered for performing the duplicate detection. This is an optional attribute
DETECT_RECEIPT_AMT_FLAG	VARCHAR2	(3)		This flag indicates whether Receipt Amount along with Receipt Currency is considered for performing the duplicate detection. This is an optional attribute
DETECT_END_DATE_FLAG	VARCHAR2	(3)		This flag indicates whether End Date is considered for performing the duplicate detection. This is an expense category specific field for Accommodations
DETECT_MERCHANT_FLAG	VARCHAR2	(3)		This flag indicates whether Merchant is considered for performing the duplicate detection. This is an expense category specific field for Accommodations, Airfare and Car Rental
DETECT_CLASS_OF_TICKET_FLAG	VARCHAR2	(3)		This flag indicates whether Ticket Class is considered for performing the duplicate detection. This is an expense category specific field for Airfare
DETECT_TICKET_NUM_FLAG	VARCHAR2	(3)		This flag indicates whether Ticket Number is considered for performing the duplicate detection. This is an expense category specific field for Airfare
DETECT_FROM_LOCATION_FLAG	VARCHAR2	(3)		This flag indicates whether From Location is considered for performing the duplicate detection. This is an expense category specific field for Airfare
DETECT_TO_LOCATION_FLAG	VARCHAR2	(3)		This flag indicates whether To Location is considered for performing the duplicate detection. This is an expense category specific field for Airfare
DETECT_DISTANCE_UOM_FLAG	VARCHAR2	(3)		This flag indicates whether Distance UOM is considered for performing the duplicate detection. This is an expense category specific field for Mileage
DETECT_DAILY_TRIP_DIST_FLAG	VARCHAR2	(3)		This flag indicates whether Trip Distance is considered for performing the duplicate detection. This is an expense category specific field for Mileage
DETECT_LOCATION_FIELDS_FLAG	VARCHAR2	(3)		This flag indicates whether Location Fields is considered for performing the duplicate detection. This is an expense category specific field for Mileage
DETECT_VLP_NUM_FLAG	VARCHAR2	(3)		This flag indicates whether Vehicle License Plate Number is considered for performing the duplicate detection. This is an expense category specific field for Mileage
DETECT_ATTENDEE_FLAG	VARCHAR2	(3)		This flag indicates whether Attendee is considered for performing the duplicate detection. This is an additional rule
DUPLICATES_ALLOWED	NUMBER		Yes	Holds the number of duplicates allowed
DUPLICATE_DETECTION_ACTION	VARCHAR2	(90)	Yes	Holds the duplicate detection action that to be perfomed when duplicates were detected
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)

Query Text

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;

Dependencies

[top of page]

AP.OIE_DUP_DETECT_RULES does not reference any database object

AP.OIE_DUP_DETECT_RULES is referenced by following:

AP: OIE_DUP_DETECT_RULES#