[Home] [Help]
View: APBV_EXPENSE_REPORT_PARAMS
View Text
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
Columns
| PARAMETER_ID |
| EXPENSE_REPORT_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| PROMPT |
| LINE_TYPE_LOOKUP_CODE |
| VAT_CODE |
| FLEX_CCID |
| FLEX_DESCRIPTION |
| FLEX_CONCACTENATED |
| SUMMARY_FLAG |
| CREATION_DATE |
| CREATED_BY |
| ORG_ID |
| WEB_ENABLED_FLAG |
| WEB_FRIENDLY_PROMPT |
| WEB_IMAGE_FILENAME |
| JUSTIFICATION_REQUIRED_FLAG |
| RECEIPT_REQUIRED_FLAG |
| AMOUNT_INCLUDES_TAX_FLAG |
| WEB_SEQUENCE |
| CALCULATE_AMOUNT_FLAG |
| REQUIRE_RECEIPT_AMOUNT |
| PA_EXPENDITURE_TYPE |
| CARD_EXP_TYPE_LOOKUP_CODE |
| ITEMIZATION_REQUIRED_FLAG |
| ITEMIZATION_ALL_FLAG |
| COMPANY_POLICY_ID |
| CATEGORY_CODE |
| END_DATE |
| EXPENSE_TYPE_CODE |
| DATA_CAPTURE_RULE_ID |
| Name |
APPS.APBV_EXPENSE_REPORT_PARAMS