FND Design Data [Home] [Help]

View: APBV_EXPENSE_REPORT_PARAMS

Product: AP - Payables
Description:
Implementation/DBA Data: ViewAPPS.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

Name
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