Product: | AP - Payables |
---|---|
Description: | |
Implementation/DBA Data: |
![]() |
SELECT AERPA.PARAMETER_ID
, AERPA.EXPENSE_REPORT_ID
, AERPA.LAST_UPDATE_DATE
, AERPA.LAST_UPDATED_BY
, AERPA.PROMPT
, AERPA.LINE_TYPE_LOOKUP_CODE
, AERPA.VAT_CODE
, AERPA.FLEX_CCID
, AERPA.FLEX_DESCRIPTION
, AERPA.FLEX_CONCACTENATED
, AERPA.SUMMARY_FLAG
, AERPA.CREATION_DATE
, AERPA.CREATED_BY
, AERPA.ORG_ID
, AERPA.WEB_ENABLED_FLAG
, AERPA.WEB_FRIENDLY_PROMPT
, AERPA.WEB_IMAGE_FILENAME
, AERPA.JUSTIFICATION_REQUIRED_FLAG
, AERPA.RECEIPT_REQUIRED_FLAG
, AERPA.AMOUNT_INCLUDES_TAX_FLAG
, AERPA.WEB_SEQUENCE
, AERPA.CALCULATE_AMOUNT_FLAG
, AERPA.REQUIRE_RECEIPT_AMOUNT
, AERPA.PA_EXPENDITURE_TYPE
, AERPA.CARD_EXP_TYPE_LOOKUP_CODE
, AERPA.ITEMIZATION_REQUIRED_FLAG
, AERPA.ITEMIZATION_ALL_FLAG
, AERPA.COMPANY_POLICY_ID
, AERPA.CATEGORY_CODE
, AERPA.END_DATE
, AERPA.EXPENSE_TYPE_CODE
, AERPA.DATA_CAPTURE_RULE_ID
FROM AP_EXPENSE_REPORT_PARAMS_ALL AERPA
WHERE '_SEC:AERPA.ORG_ID' IS NOT NULL WITH READ ONLY