VIEW: APPS.APBV_EXPENSE_REPORT_PARAMS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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