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: AP.AP_EXPENSE_REPORT_LINES_ALL#

Object Details

Object Name:	AP_EXPENSE_REPORT_LINES_ALL#
Object Type:	VIEW
Owner:	AP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
REPORT_HEADER_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CODE_COMBINATION_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)	Yes
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
AMOUNT	NUMBER
ATTRIBUTE_CATEGORY	VARCHAR2	(150)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
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
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
STAT_AMOUNT	NUMBER
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)
PROJECT_ACCOUNTING_CONTEXT	VARCHAR2	(30)
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)
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
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)
AMOUNT_INCLUDES_TAX_FLAG	VARCHAR2	(1)
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)
ADJUSTMENT_REASON	VARCHAR2	(240)
POLICY_SHORTPAY_FLAG	VARCHAR2	(1)
AWARD_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)
CREDIT_CARD_TRX_ID	NUMBER	(15)
ITEMIZE_ID	NUMBER	(15)
PROJECT_NAME	VARCHAR2	(30)
TASK_NAME	VARCHAR2	(30)
COMPANY_PREPAID_INVOICE_ID	NUMBER	(15)
PA_INTERFACED_FLAG	VARCHAR2	(1)
PROJECT_NUMBER	VARCHAR2	(30)
TASK_NUMBER	VARCHAR2	(30)
AWARD_NUMBER	VARCHAR2	(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
FLEX_CONCATENATED	VARCHAR2	(240)
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)
ALLOCATION_SPLIT_CODE	VARCHAR2	(30)
RATE_PER_PASSENGER	NUMBER
PASSENGER_RATE_TYPE	VARCHAR2	(30)
PASSENGER_AMOUNT	NUMBER
RANGE_LOW	NUMBER
RANGE_HIGH	NUMBER
UOM_DAYS	NUMBER
IMAGE_RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)
RECEIPTS_ISSUE	VARCHAR2	(240)
ADJUSTMENT_REASON_COPY	VARCHAR2	(30)

Query Text

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


SELECT REPORT_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CODE_COMBINATION_ID
,      ITEM_DESCRIPTION
,      SET_OF_BOOKS_ID
,      AMOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      VAT_CODE
,      LINE_TYPE_LOOKUP_CODE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      STAT_AMOUNT
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      PROJECT_ACCOUNTING_CONTEXT
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ORGANIZATION_ID
,      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
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      AMOUNT_INCLUDES_TAX_FLAG
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      ADJUSTMENT_REASON
,      POLICY_SHORTPAY_FLAG
,      AWARD_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
,      CREDIT_CARD_TRX_ID
,      ITEMIZE_ID
,      PROJECT_NAME
,      TASK_NAME
,      COMPANY_PREPAID_INVOICE_ID
,      PA_INTERFACED_FLAG
,      PROJECT_NUMBER
,      TASK_NUMBER
,      AWARD_NUMBER
,      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
,      FLEX_CONCATENATED
,      FUNC_CURRENCY_AMT
,      LOCATION
,      CATEGORY_CODE
,      ADJUSTMENT_REASON_CODE
,      AP_VALIDATION_ERROR
,      SUBMITTED_AMOUNT
,      REPORT_LINE_ID
,      ALLOCATION_REASON
,      ALLOCATION_SPLIT_CODE
,      RATE_PER_PASSENGER
,      PASSENGER_RATE_TYPE
,      PASSENGER_AMOUNT
,      RANGE_LOW
,      RANGE_HIGH
,      UOM_DAYS
,      IMAGE_RECEIPT_REQUIRED_FLAG
,      RECEIPTS_ISSUE
,      ADJUSTMENT_REASON_COPY
FROM AP.AP_EXPENSE_REPORT_LINES_ALL#;

Dependencies

[top of page]

AP.AP_EXPENSE_REPORT_LINES_ALL# references the following:

AP: AP_EXPENSE_REPORT_LINES_ALL

AP.AP_EXPENSE_REPORT_LINES_ALL# is referenced by following:

APPS: AP_EXPENSE_REPORT_LINES; AP_EXPENSE_REPORT_LINES_ALL