VIEW: APPS.APBV_EXPENSE_REPORT_LINES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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