[Home] [Help] [Dependency Information]

VIEW: APPS.APBV_EXPENSE_REPORT_LINES

Object Details

Object Name:	APBV_EXPENSE_REPORT_LINES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.APBV_EXPENSE_REPORT_LINES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Based on AP_EXPENSE_REPORT_LINES_ALL, this view contains expense line data.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

APPS

AP_EXPENSE_REPORT_LINES_ALL

APPS.APBV_EXPENSE_REPORT_LINES is not referenced by any database object