eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [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

Name	Datatype	Length	Mandatory	Comments
REPORT_HEADER_ID	NUMBER		Yes	Expense report header identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ITEM_DESCRIPTION	VARCHAR2	(240)	Yes	Description of expense report item
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books identifier
AMOUNT	NUMBER			Amount
_DF	CHAR	(39)
CURRENCY_CODE	VARCHAR2	(15)	Yes
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
EXCHANGE_RATE	NUMBER
EXCHANGE_DATE	DATE
VAT_CODE	VARCHAR2	(30)
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
STAT_AMOUNT	NUMBER
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)
EXPENDITURE_TYPE	VARCHAR2	(30)
EXPENDITURE_ITEM_DATE	DATE
PA_QUANTITY	NUMBER
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)
REFERENCE_1	VARCHAR2	(30)
REFERENCE_2	VARCHAR2	(30)
AWT_GROUP_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
RECEIPT_VERIFIED_FLAG	VARCHAR2	(1)
JUSTIFICATION_REQUIRED_FLAG	VARCHAR2	(1)
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)
RECEIPT_MISSING_FLAG	VARCHAR2	(1)
JUSTIFICATION	VARCHAR2	(240)
EXPENSE_GROUP	VARCHAR2	(80)
START_EXPENSE_DATE	DATE
END_EXPENSE_DATE	DATE
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)
RECEIPT_CONVERSION_RATE	NUMBER
DAILY_AMOUNT	NUMBER
RECEIPT_CURRENCY_AMOUNT	NUMBER
WEB_PARAMETER_ID	NUMBER
AMOUNT_INCLUDES_TAX_FLAG	VARCHAR2	(1)
ADJUSTMENT_REASON	VARCHAR2	(240)
POLICY_SHORTPAY_FLAG	VARCHAR2	(1)
CREDIT_CARD_TRX_ID	NUMBER	(15)
MERCHANT_DOCUMENT_NUMBER	VARCHAR2	(80)
MERCHANT_NAME	VARCHAR2	(240)
MERCHANT_REFERENCE	VARCHAR2	(240)
MERCHANT_TAX_REG_NUMBER	VARCHAR2	(80)
MERCHANT_TAXPAYER_ID	VARCHAR2	(80)
COUNTRY_OF_SUPPLY	VARCHAR2	(5)
TAX_CODE_OVERRIDE_FLAG	VARCHAR2	(1)
TAX_CODE_ID	NUMBER	(15)
ITEMIZE_ID	NUMBER	(15)
COMPANY_PREPAID_INVOICE_ID	NUMBER	(15)
VEHICLE_CATEGORY_CODE	VARCHAR2	(30)
VEHICLE_TYPE	VARCHAR2	(30)
FUEL_TYPE	VARCHAR2	(30)
NUMBER_PEOPLE	NUMBER
DAILY_DISTANCE	NUMBER
DISTANCE_UNIT_CODE	VARCHAR2	(30)
AVG_MILEAGE_RATE	NUMBER
DESTINATION_FROM	VARCHAR2	(80)
DESTINATION_TO	VARCHAR2	(80)
TRIP_DISTANCE	NUMBER
LICENSE_PLATE_NUMBER	VARCHAR2	(30)
MILEAGE_RATE_ADJUSTED_FLAG	VARCHAR2	(1)
LOCATION_ID	NUMBER	(15)
NUM_PDM_DAYS1	NUMBER
NUM_PDM_DAYS2	NUMBER
NUM_PDM_DAYS3	NUMBER
PER_DIEM_RATE1	NUMBER
PER_DIEM_RATE2	NUMBER
PER_DIEM_RATE3	NUMBER
DEDUCTION_ADDITION_AMT1	NUMBER
DEDUCTION_ADDITION_AMT2	NUMBER
DEDUCTION_ADDITION_AMT3	NUMBER
NUM_FREE_BREAKFASTS1	NUMBER
NUM_FREE_LUNCHES1	NUMBER
NUM_FREE_DINNERS1	NUMBER
NUM_FREE_ACCOMMODATIONS1	NUMBER
NUM_FREE_BREAKFASTS2	NUMBER
NUM_FREE_LUNCHES2	NUMBER
NUM_FREE_DINNERS2	NUMBER
NUM_FREE_ACCOMMODATIONS2	NUMBER
NUM_FREE_BREAKFASTS3	NUMBER
NUM_FREE_LUNCHES3	NUMBER
NUM_FREE_DINNERS3	NUMBER
NUM_FREE_ACCOMMODATIONS3	NUMBER
ATTENDEES	VARCHAR2	(240)
NUMBER_ATTENDEES	NUMBER
TRAVEL_TYPE	VARCHAR2	(30)
TICKET_CLASS_CODE	VARCHAR2	(30)
TICKET_NUMBER	VARCHAR2	(80)
FLIGHT_NUMBER	VARCHAR2	(80)
LOCATION_TO_ID	NUMBER	(15)
ITEMIZATION_PARENT_ID	NUMBER
FUNC_CURRENCY_AMT	NUMBER
LOCATION	VARCHAR2	(80)
CATEGORY_CODE	VARCHAR2	(30)
ADJUSTMENT_REASON_CODE	VARCHAR2	(30)
AP_VALIDATION_ERROR	VARCHAR2	(240)
SUBMITTED_AMOUNT	NUMBER
REPORT_LINE_ID	NUMBER	(15)
ALLOCATION_REASON	VARCHAR2	(240)

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.APBV_EXPENSE_REPORT_LINES references the following:

APPS: AP_EXPENSE_REPORT_LINES_ALL

APPS.APBV_EXPENSE_REPORT_LINES is not referenced by any database object