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_HEADERS_ALL#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
REPORT_HEADER_ID	NUMBER		Yes
EMPLOYEE_ID	NUMBER	(10)
WEEK_END_DATE	DATE		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
VOUCHNO	NUMBER		Yes
TOTAL	NUMBER		Yes
VENDOR_ID	NUMBER	(15)
VENDOR_SITE_ID	NUMBER	(15)
EXPENSE_CHECK_ADDRESS_FLAG	VARCHAR2	(30)
REFERENCE_1	VARCHAR2	(30)
REFERENCE_2	VARCHAR2	(30)
INVOICE_NUM	VARCHAR2	(50)
EXPENSE_REPORT_ID	NUMBER
ACCTS_PAY_CODE_COMBINATION_ID	NUMBER	(15)
SET_OF_BOOKS_ID	NUMBER	(15)
SOURCE	VARCHAR2	(25)
PURGEABLE_FLAG	VARCHAR2	(1)
ACCOUNTING_DATE	DATE
MAXIMUM_AMOUNT_TO_APPLY	NUMBER
ADVANCE_INVOICE_TO_APPLY	NUMBER	(15)
APPLY_ADVANCES_DEFAULT	VARCHAR2	(4)
EMPLOYEE_CCID	NUMBER
DESCRIPTION	VARCHAR2	(240)
REJECT_CODE	VARCHAR2	(30)
HOLD_LOOKUP_CODE	VARCHAR2	(25)
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)
DEFAULT_CURRENCY_CODE	VARCHAR2	(15)	Yes
DEFAULT_EXCHANGE_RATE_TYPE	VARCHAR2	(30)
DEFAULT_EXCHANGE_RATE	NUMBER
DEFAULT_EXCHANGE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
VOUCHER_NUM	VARCHAR2	(50)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)
DOC_CATEGORY_CODE	VARCHAR2	(30)
AWT_GROUP_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
WORKFLOW_APPROVED_FLAG	VARCHAR2	(1)
FLEX_CONCATENATED	VARCHAR2	(240)
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)
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)
OVERRIDE_APPROVER_ID	NUMBER	(9)
PAYMENT_CROSS_RATE_TYPE	VARCHAR2	(30)
PAYMENT_CROSS_RATE_DATE	DATE
PAYMENT_CROSS_RATE	NUMBER
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)
CORE_WF_STATUS_FLAG	VARCHAR2	(1)
PREPAY_APPLY_FLAG	VARCHAR2	(4)
PREPAY_NUM	VARCHAR2	(50)
PREPAY_DIST_NUM	NUMBER	(15)
PREPAY_APPLY_AMOUNT	NUMBER
PREPAY_GL_DATE	DATE
BOTHPAY_PARENT_ID	NUMBER	(15)
SHORTPAY_PARENT_ID	NUMBER	(15)
PAID_ON_BEHALF_EMPLOYEE_ID	NUMBER	(15)
OVERRIDE_APPROVER_NAME	VARCHAR2	(240)
AMT_DUE_CCARD_COMPANY	NUMBER
AMT_DUE_EMPLOYEE	NUMBER
DEFAULT_RECEIPT_CURRENCY_CODE	VARCHAR2	(15)
MULTIPLE_CURRENCIES_FLAG	VARCHAR2	(1)
EXPENSE_STATUS_CODE	VARCHAR2	(30)
EXPENSE_LAST_STATUS_DATE	DATE
EXPENSE_CURRENT_APPROVER_ID	NUMBER	(15)
REPORT_FILING_NUMBER	VARCHAR2	(240)
RECEIPTS_RECEIVED_DATE	DATE
AUDIT_CODE	VARCHAR2	(30)
REPORT_SUBMITTED_DATE	DATE
LAST_AUDITED_BY	NUMBER	(15)
RETURN_REASON_CODE	VARCHAR2	(30)
RETURN_INSTRUCTION	VARCHAR2	(4000)
RECEIPTS_STATUS	VARCHAR2	(30)
HOLDING_REPORT_HEADER_ID	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
ADVANCES_JUSTIFICATION	VARCHAR2	(240)
IMAGE_RECEIPTS_STATUS	VARCHAR2	(30)
IMAGE_RECEIPTS_RECEIVED_DATE	DATE
MISSING_IMG_JUST	VARCHAR2	(240)
APPROVAL_TYPE	VARCHAR2	(10)
OVERDUE_REQUEST_ID	NUMBER

Query Text

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


SELECT REPORT_HEADER_ID
,      EMPLOYEE_ID
,      WEEK_END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      VOUCHNO
,      TOTAL
,      VENDOR_ID
,      VENDOR_SITE_ID
,      EXPENSE_CHECK_ADDRESS_FLAG
,      REFERENCE_1
,      REFERENCE_2
,      INVOICE_NUM
,      EXPENSE_REPORT_ID
,      ACCTS_PAY_CODE_COMBINATION_ID
,      SET_OF_BOOKS_ID
,      SOURCE
,      PURGEABLE_FLAG
,      ACCOUNTING_DATE
,      MAXIMUM_AMOUNT_TO_APPLY
,      ADVANCE_INVOICE_TO_APPLY
,      APPLY_ADVANCES_DEFAULT
,      EMPLOYEE_CCID
,      DESCRIPTION
,      REJECT_CODE
,      HOLD_LOOKUP_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DEFAULT_CURRENCY_CODE
,      DEFAULT_EXCHANGE_RATE_TYPE
,      DEFAULT_EXCHANGE_RATE
,      DEFAULT_EXCHANGE_DATE
,      LAST_UPDATE_LOGIN
,      VOUCHER_NUM
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      DOC_CATEGORY_CODE
,      AWT_GROUP_ID
,      ORG_ID
,      WORKFLOW_APPROVED_FLAG
,      FLEX_CONCATENATED
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      OVERRIDE_APPROVER_ID
,      PAYMENT_CROSS_RATE_TYPE
,      PAYMENT_CROSS_RATE_DATE
,      PAYMENT_CROSS_RATE
,      PAYMENT_CURRENCY_CODE
,      CORE_WF_STATUS_FLAG
,      PREPAY_APPLY_FLAG
,      PREPAY_NUM
,      PREPAY_DIST_NUM
,      PREPAY_APPLY_AMOUNT
,      PREPAY_GL_DATE
,      BOTHPAY_PARENT_ID
,      SHORTPAY_PARENT_ID
,      PAID_ON_BEHALF_EMPLOYEE_ID
,      OVERRIDE_APPROVER_NAME
,      AMT_DUE_CCARD_COMPANY
,      AMT_DUE_EMPLOYEE
,      DEFAULT_RECEIPT_CURRENCY_CODE
,      MULTIPLE_CURRENCIES_FLAG
,      EXPENSE_STATUS_CODE
,      EXPENSE_LAST_STATUS_DATE
,      EXPENSE_CURRENT_APPROVER_ID
,      REPORT_FILING_NUMBER
,      RECEIPTS_RECEIVED_DATE
,      AUDIT_CODE
,      REPORT_SUBMITTED_DATE
,      LAST_AUDITED_BY
,      RETURN_REASON_CODE
,      RETURN_INSTRUCTION
,      RECEIPTS_STATUS
,      HOLDING_REPORT_HEADER_ID
,      REQUEST_ID
,      ADVANCES_JUSTIFICATION
,      IMAGE_RECEIPTS_STATUS
,      IMAGE_RECEIPTS_RECEIVED_DATE
,      MISSING_IMG_JUST
,      APPROVAL_TYPE
,      OVERDUE_REQUEST_ID
FROM AP.AP_EXPENSE_REPORT_HEADERS_ALL#;

Dependencies

[top of page]

AP.AP_EXPENSE_REPORT_HEADERS_ALL# references the following:

AP: AP_EXPENSE_REPORT_HEADERS_ALL

AP.AP_EXPENSE_REPORT_HEADERS_ALL# is referenced by following:

APPS: AP_EXPENSE_REPORT_HEADERS; AP_EXPENSE_REPORT_HEADERS_ALL