VIEW: AP.AP_AUD_RULE_SETS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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