[Home] [Help] [Dependency Information]

VIEW: AP.AP_AUD_RULE_SETS#

Object Details

[View Source]

Columns

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

APPS

AP_AUD_RULE_SETS