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]

VIEW: AP.AP_AUD_RULE_SETS#

Object Details

Object Name:	AP_AUD_RULE_SETS#
Object Type:	VIEW
Owner:	AP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
RULE_SET_ID	NUMBER	(15)	Yes
RULE_SET_NAME	VARCHAR2	(60)	Yes
RULE_SET_TYPE	VARCHAR2	(30)	Yes
DESCRIPTION	VARCHAR2	(240)
START_DATE	DATE
END_DATE	DATE
PAPERLESS_AUDIT_CC_ONLY_FLAG	VARCHAR2	(1)
PAPERLESS_AUDIT_VIOLATION_FLAG	VARCHAR2	(1)
PAPERLESS_AUDIT_PDM_ONLY_FLAG	VARCHAR2	(1)
ASSIGN_AUDITOR_STAGE_CODE	VARCHAR2	(30)
AUDIT_ALL_VIOLATIONS_FLAG	VARCHAR2	(1)
AUDIT_ALL_FROM_AUDIT_LIST_FLAG	VARCHAR2	(1)
AUDIT_ALL_OLD_RECEIPTS_FLAG	VARCHAR2	(1)
AUDIT_ALL_RECEIPT_DAYS_LIMIT	NUMBER
RANDOM_AUDIT_FLAG	VARCHAR2	(1)
RANDOM_AUDIT_PERCENTAGE	NUMBER
IGNORE_CREDIT_ONLY_FLAG	VARCHAR2	(1)
IGNORE_RJ_NOT_REQ_ONLY_FLAG	VARCHAR2	(1)
AUTO_APPROVAL_TAG	VARCHAR2	(80)
REQUIRES_AUDIT_TAG	VARCHAR2	(80)
PAPERLESS_AUDIT_TAG	VARCHAR2	(80)
RECEIPT_DELAY_RULE_FLAG	VARCHAR2	(1)
RECEIPT_DELAY_DAYS	NUMBER
MONTHLY_TOTAL_RULE_FLAG	VARCHAR2	(1)
MONTHLY_TOTAL_ALLOWED	NUMBER
MONTHLY_VIOLATIONS_RULE_FLAG	VARCHAR2	(1)
MONTHLY_VIOLATIONS_ALLOWED	NUMBER
MONTHLY_REPORTS_RULE_FLAG	VARCHAR2	(1)
MONTHLY_REPORTS_ALLOWED	NUMBER
AUDIT_TERM_DURATION_DAYS	NUMBER
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
NOTIFY_RCT_OVERDUE_DAYS	NUMBER
NOTIFY_ACTION_REQUIRED_DAYS	NUMBER
NOTIFY_DOCUMENT_REQUIRED_CODE	VARCHAR2	(30)
NOTIFY_RESPONSE_OVERDUE_DAYS	NUMBER
NOTIFY_RCT_RECEIVED_CODE	VARCHAR2	(30)
HOLD_CODE	VARCHAR2	(30)
HOLD_RCT_OVERDUE_DAYS	NUMBER
HOLD_RCT_OVERDUE_BP_CC_CODE	VARCHAR2	(30)
AUDIT_ALL_AMOUNT_CODE	VARCHAR2	(30)
AUDIT_ALL_AMOUNT_LIMIT	NUMBER
AUDIT_ALL_AMOUNT_CURRENCY_CODE	VARCHAR2	(15)
AUDIT_ALL_RECEIPTS_CODE	VARCHAR2	(30)
AUDIT_ALL_JUSTIFICATION_CODE	VARCHAR2	(30)
AUDIT_ALL_INACTIVE_CODE	VARCHAR2	(30)
AUDIT_ALL_UNUSED_ADVANCES	VARCHAR2	(30)
CASH_LIMIT_ENABLED	VARCHAR2	(1)
CASH_LIMIT	NUMBER
CARD_LIMIT_ENABLED	VARCHAR2	(1)
CARD_LIMIT	NUMBER
MILEAGE_LIMIT_ENABLED	VARCHAR2	(1)
MILEAGE_LIMIT	NUMBER
ALLOW_NEGATIVE_LINES	VARCHAR2	(1)
IMAGE_RECEIPT_REQ	VARCHAR2	(1)
ORIG_RECEIPT_REQ	VARCHAR2	(1)
IMAGE_PREV_SUB_FLAG	VARCHAR2	(240)
IMAGE_REQ_JUST_FLAG	VARCHAR2	(240)
IMAGE_REQ_APPR_FLAG	VARCHAR2	(1)
NOTIFY_IMG_RCT_OVERDUE_DAYS	NUMBER
NOTIFY_IMG_ACTION_REQ_DAYS	NUMBER
NOTIFY_IMG_RESP_OVERDUE_DAYS	NUMBER
AUD_IMG_RECEIPT_REQUIRED	VARCHAR2	(1)
AUD_PAPER_RECEIPT_REQUIRED	VARCHAR2	(1)
RECPT_ASSIGN_STAGE_CODE	VARCHAR2	(240)
IMAGE_AUDIT_TAG	VARCHAR2	(80)
CURRENCY_CODE	VARCHAR2	(15)
ALLOW_RECPT_DECL	VARCHAR2	(1)
REQ_REAPPR_FLAG	VARCHAR2	(1)
ALLOW_RECPT_MISSING	VARCHAR2	(1)
PAYABLES_IMAGE_REQ	VARCHAR2	(1)
AUDIT_ALL	VARCHAR2	(1)
AUDIT_SPECIFIC	VARCHAR2	(1)

Query Text

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


SELECT RULE_SET_ID
,      RULE_SET_NAME
,      RULE_SET_TYPE
,      DESCRIPTION
,      START_DATE
,      END_DATE
,      PAPERLESS_AUDIT_CC_ONLY_FLAG
,      PAPERLESS_AUDIT_VIOLATION_FLAG
,      PAPERLESS_AUDIT_PDM_ONLY_FLAG
,      ASSIGN_AUDITOR_STAGE_CODE
,      AUDIT_ALL_VIOLATIONS_FLAG
,      AUDIT_ALL_FROM_AUDIT_LIST_FLAG
,      AUDIT_ALL_OLD_RECEIPTS_FLAG
,      AUDIT_ALL_RECEIPT_DAYS_LIMIT
,      RANDOM_AUDIT_FLAG
,      RANDOM_AUDIT_PERCENTAGE
,      IGNORE_CREDIT_ONLY_FLAG
,      IGNORE_RJ_NOT_REQ_ONLY_FLAG
,      AUTO_APPROVAL_TAG
,      REQUIRES_AUDIT_TAG
,      PAPERLESS_AUDIT_TAG
,      RECEIPT_DELAY_RULE_FLAG
,      RECEIPT_DELAY_DAYS
,      MONTHLY_TOTAL_RULE_FLAG
,      MONTHLY_TOTAL_ALLOWED
,      MONTHLY_VIOLATIONS_RULE_FLAG
,      MONTHLY_VIOLATIONS_ALLOWED
,      MONTHLY_REPORTS_RULE_FLAG
,      MONTHLY_REPORTS_ALLOWED
,      AUDIT_TERM_DURATION_DAYS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      NOTIFY_RCT_OVERDUE_DAYS
,      NOTIFY_ACTION_REQUIRED_DAYS
,      NOTIFY_DOCUMENT_REQUIRED_CODE
,      NOTIFY_RESPONSE_OVERDUE_DAYS
,      NOTIFY_RCT_RECEIVED_CODE
,      HOLD_CODE
,      HOLD_RCT_OVERDUE_DAYS
,      HOLD_RCT_OVERDUE_BP_CC_CODE
,      AUDIT_ALL_AMOUNT_CODE
,      AUDIT_ALL_AMOUNT_LIMIT
,      AUDIT_ALL_AMOUNT_CURRENCY_CODE
,      AUDIT_ALL_RECEIPTS_CODE
,      AUDIT_ALL_JUSTIFICATION_CODE
,      AUDIT_ALL_INACTIVE_CODE
,      AUDIT_ALL_UNUSED_ADVANCES
,      CASH_LIMIT_ENABLED
,      CASH_LIMIT
,      CARD_LIMIT_ENABLED
,      CARD_LIMIT
,      MILEAGE_LIMIT_ENABLED
,      MILEAGE_LIMIT
,      ALLOW_NEGATIVE_LINES
,      IMAGE_RECEIPT_REQ
,      ORIG_RECEIPT_REQ
,      IMAGE_PREV_SUB_FLAG
,      IMAGE_REQ_JUST_FLAG
,      IMAGE_REQ_APPR_FLAG
,      NOTIFY_IMG_RCT_OVERDUE_DAYS
,      NOTIFY_IMG_ACTION_REQ_DAYS
,      NOTIFY_IMG_RESP_OVERDUE_DAYS
,      AUD_IMG_RECEIPT_REQUIRED
,      AUD_PAPER_RECEIPT_REQUIRED
,      RECPT_ASSIGN_STAGE_CODE
,      IMAGE_AUDIT_TAG
,      CURRENCY_CODE
,      ALLOW_RECPT_DECL
,      REQ_REAPPR_FLAG
,      ALLOW_RECPT_MISSING
,      PAYABLES_IMAGE_REQ
,      AUDIT_ALL
,      AUDIT_SPECIFIC
FROM AP.AP_AUD_RULE_SETS#;

Dependencies

[top of page]

AP.AP_AUD_RULE_SETS# references the following:

AP: AP_AUD_RULE_SETS

AP.AP_AUD_RULE_SETS# is referenced by following:

APPS: AP_AUD_RULE_SETS