View: APBV_EXPENSE_REPORT_LINES

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.APBV_EXPENSE_REPORT_LINES

View Text

SELECT REPORT_HEADER_ID
, AERLA.LAST_UPDATE_DATE
, AERLA.LAST_UPDATED_BY
, AERLA.ITEM_DESCRIPTION
, AERLA.SET_OF_BOOKS_ID
, AERLA.AMOUNT
, '_DF:SQLAP:AP_EXPENSE_REPORT_LINES:AERLA'
, AERLA.CURRENCY_CODE
, AERLA.EXCHANGE_RATE_TYPE
, AERLA.EXCHANGE_RATE
, AERLA.EXCHANGE_DATE
, AERLA.VAT_CODE
, AERLA.LINE_TYPE_LOOKUP_CODE
, AERLA.CREATION_DATE
, AERLA.CREATED_BY
, AERLA.STAT_AMOUNT
, AERLA.USSGL_TRANSACTION_CODE
, AERLA.USSGL_TRX_CODE_CONTEXT
, AERLA.EXPENDITURE_TYPE
, AERLA.EXPENDITURE_ITEM_DATE
, AERLA.PA_QUANTITY
, AERLA.DISTRIBUTION_LINE_NUMBER
, AERLA.REFERENCE_1
, AERLA.REFERENCE_2
, AERLA.AWT_GROUP_ID
, AERLA.ORG_ID
, AERLA.RECEIPT_VERIFIED_FLAG
, AERLA.JUSTIFICATION_REQUIRED_FLAG
, AERLA.RECEIPT_REQUIRED_FLAG
, AERLA.RECEIPT_MISSING_FLAG
, AERLA.JUSTIFICATION
, AERLA.EXPENSE_GROUP
, AERLA.START_EXPENSE_DATE
, AERLA.END_EXPENSE_DATE
, AERLA.RECEIPT_CURRENCY_CODE
, AERLA.RECEIPT_CONVERSION_RATE
, AERLA.DAILY_AMOUNT
, AERLA.RECEIPT_CURRENCY_AMOUNT
, AERLA.WEB_PARAMETER_ID
, AERLA.AMOUNT_INCLUDES_TAX_FLAG
, AERLA.ADJUSTMENT_REASON
, AERLA.POLICY_SHORTPAY_FLAG
, AERLA.CREDIT_CARD_TRX_ID
, AERLA.MERCHANT_DOCUMENT_NUMBER
, AERLA.MERCHANT_NAME
, AERLA.MERCHANT_REFERENCE
, AERLA.MERCHANT_TAX_REG_NUMBER
, AERLA.MERCHANT_TAXPAYER_ID
, AERLA.COUNTRY_OF_SUPPLY
, AERLA.TAX_CODE_OVERRIDE_FLAG
, AERLA.TAX_CODE_ID
, AERLA.ITEMIZE_ID
, AERLA.COMPANY_PREPAID_INVOICE_ID
, AERLA.VEHICLE_CATEGORY_CODE
, AERLA.VEHICLE_TYPE
, AERLA.FUEL_TYPE
, AERLA.NUMBER_PEOPLE
, AERLA.DAILY_DISTANCE
, AERLA.DISTANCE_UNIT_CODE
, AERLA.AVG_MILEAGE_RATE
, AERLA.DESTINATION_FROM
, AERLA.DESTINATION_TO
, AERLA.TRIP_DISTANCE
, AERLA.LICENSE_PLATE_NUMBER
, AERLA.MILEAGE_RATE_ADJUSTED_FLAG
, AERLA.LOCATION_ID
, AERLA.NUM_PDM_DAYS1
, AERLA.NUM_PDM_DAYS2
, AERLA.NUM_PDM_DAYS3
, AERLA.PER_DIEM_RATE1
, AERLA.PER_DIEM_RATE2
, AERLA.PER_DIEM_RATE3
, AERLA.DEDUCTION_ADDITION_AMT1
, AERLA.DEDUCTION_ADDITION_AMT2
, AERLA.DEDUCTION_ADDITION_AMT3
, AERLA.NUM_FREE_BREAKFASTS1
, AERLA.NUM_FREE_LUNCHES1
, AERLA.NUM_FREE_DINNERS1
, AERLA.NUM_FREE_ACCOMMODATIONS1
, AERLA.NUM_FREE_BREAKFASTS2
, AERLA.NUM_FREE_LUNCHES2
, AERLA.NUM_FREE_DINNERS2
, AERLA.NUM_FREE_ACCOMMODATIONS2
, AERLA.NUM_FREE_BREAKFASTS3
, AERLA.NUM_FREE_LUNCHES3
, AERLA.NUM_FREE_DINNERS3
, AERLA.NUM_FREE_ACCOMMODATIONS3
, AERLA.ATTENDEES
, AERLA.NUMBER_ATTENDEES
, AERLA.TRAVEL_TYPE
, AERLA.TICKET_CLASS_CODE
, AERLA.TICKET_NUMBER
, AERLA.FLIGHT_NUMBER
, AERLA.LOCATION_TO_ID
, AERLA.ITEMIZATION_PARENT_ID
, AERLA.FUNC_CURRENCY_AMT
, AERLA.LOCATION
, AERLA.CATEGORY_CODE
, AERLA.ADJUSTMENT_REASON_CODE
, AERLA.AP_VALIDATION_ERROR
, AERLA.SUBMITTED_AMOUNT
, AERLA.REPORT_LINE_ID
, AERLA.ALLOCATION_REASON
FROM AP_EXPENSE_REPORT_LINES_ALL AERLA
WHERE '_SEC:AERLA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns