DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AP_EXPENSE_REPORT_HEADERS_V

Object Details
Object Name: AP_EXPENSE_REPORT_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.AP_EXPENSE_REPORT_HEADERS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ACCOUNTING_DATE DATE

ACCTS_PAY_CODE_COMBINATION_ID NUMBER (15)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 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)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
AWT_GROUP_ID NUMBER (15)
CREATED_BY NUMBER

CREATION_DATE DATE

DEFAULT_CURRENCY_CODE VARCHAR2 (15)
DEFAULT_EXCHANGE_DATE DATE

DEFAULT_EXCHANGE_RATE NUMBER

DEFAULT_EXCHANGE_RATE_TYPE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (240)
DOC_CATEGORY_CODE VARCHAR2 (30)
EMPLOYEE_CCID NUMBER

EMPLOYEE_ID NUMBER (10)
EXPENSE_CHECK_ADDRESS_FLAG VARCHAR2 (30)
EXPENSE_REPORT_ID NUMBER

HOLD_LOOKUP_CODE VARCHAR2 (25)
INVOICE_NUM VARCHAR2 (50)
LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
ORG_ID NUMBER (15)
PURGEABLE_FLAG VARCHAR2 (1)
REFERENCE_1 VARCHAR2 (30)
REFERENCE_2 VARCHAR2 (30)
REJECT_CODE VARCHAR2 (30)
REPORT_HEADER_ID NUMBER

SET_OF_BOOKS_ID NUMBER (15)
SOURCE VARCHAR2 (25)
TOTAL NUMBER

USSGL_TRANSACTION_CODE VARCHAR2 (30)
Default transaction code for creating US Standard General Ledger journal entries
USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
USSGL Transaction Code Descriptive Flexfield context column
VENDOR_ID NUMBER (15)
VENDOR_SITE_ID NUMBER (15)
VOUCHER_NUM VARCHAR2 (50)
VOUCHNO NUMBER

WEEK_END_DATE DATE

EMPLOYEE_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
AWT_GROUP_NAME VARCHAR2 (25)
REPORT_TYPE VARCHAR2 (25)
DISPLAYED_EXCHANGE_RATE_TYPE VARCHAR2 (30)
DISPLAYED_HOLD_CODE VARCHAR2 (80)
WORKFLOW_APPROVED_FLAG VARCHAR2 (1)
MGMT_REVIEWED_FLAG VARCHAR2 (1)
AP_REVIEWED_FLAG VARCHAR2 (1)
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)
CORE_WF_STATUS_FLAG VARCHAR2 (1)
PAYMENT_CROSS_RATE_TYPE VARCHAR2 (30)
PAYMENT_CROSS_RATE_DATE DATE

PAYMENT_CROSS_RATE NUMBER

PAYMENT_CURRENCY_CODE VARCHAR2 (15)
APPLY_ADVANCES_FLAG VARCHAR2 (4)
ADVANCE_INVOICE_TO_APPLY NUMBER (15)
MAXIMUM_AMOUNT_TO_APPLY NUMBER

PREPAY_NUM VARCHAR2 (50)
PREPAY_DIST_NUM NUMBER (15)
PREPAY_GL_DATE DATE

TOTAL_VIOLATIONS NUMBER

RECEIPTS_WITH_VIOLATIONS NUMBER

EMPLOYEE_ACTIVE_FLAG VARCHAR2 (4000)
Query Text

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


SELECT ROW_ID
,      ACCOUNTING_DATE
,      ACCTS_PAY_CODE_COMBINATION_ID
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      AWT_GROUP_ID
,      CREATED_BY
,      CREATION_DATE
,      DEFAULT_CURRENCY_CODE
,      DEFAULT_EXCHANGE_DATE
,      DEFAULT_EXCHANGE_RATE
,      DEFAULT_EXCHANGE_RATE_TYPE
,      DESCRIPTION
,      DOC_CATEGORY_CODE
,      EMPLOYEE_CCID
,      EMPLOYEE_ID
,      EXPENSE_CHECK_ADDRESS_FLAG
,      EXPENSE_REPORT_ID
,      HOLD_LOOKUP_CODE
,      INVOICE_NUM
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      PURGEABLE_FLAG
,      REFERENCE_1
,      REFERENCE_2
,      REJECT_CODE
,      REPORT_HEADER_ID
,      SET_OF_BOOKS_ID
,      SOURCE
,      TOTAL
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VOUCHER_NUM
,      VOUCHNO
,      WEEK_END_DATE
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      AWT_GROUP_NAME
,      REPORT_TYPE
,      DISPLAYED_EXCHANGE_RATE_TYPE
,      DISPLAYED_HOLD_CODE
,      WORKFLOW_APPROVED_FLAG
,      MGMT_REVIEWED_FLAG
,      AP_REVIEWED_FLAG
,      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
,      CORE_WF_STATUS_FLAG
,      PAYMENT_CROSS_RATE_TYPE
,      PAYMENT_CROSS_RATE_DATE
,      PAYMENT_CROSS_RATE
,      PAYMENT_CURRENCY_CODE
,      APPLY_ADVANCES_FLAG
,      ADVANCE_INVOICE_TO_APPLY
,      MAXIMUM_AMOUNT_TO_APPLY
,      PREPAY_NUM
,      PREPAY_DIST_NUM
,      PREPAY_GL_DATE
,      TOTAL_VIOLATIONS
,      RECEIPTS_WITH_VIOLATIONS
,      EMPLOYEE_ACTIVE_FLAG
FROM APPS.AP_EXPENSE_REPORT_HEADERS_V;

Dependencies

[top of page]

APPS.AP_EXPENSE_REPORT_HEADERS_V references the following:

SchemaAPPS
SynonymAP_AWT_GROUPS
SynonymAP_EXPENSE_REPORTS
SynonymAP_EXPENSE_REPORT_HEADERS
ViewAP_LOOKUP_CODES
PL/SQL PackageAP_WEB_DB_HR_INT_PKG - show dependent code
PL/SQL PackageAP_WEB_EXPENSE_FORM - show dependent code
SynonymFINANCIALS_SYSTEM_PARAMETERS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_CONT_WORKERS_CURRENT_X
ViewPER_EMPLOYEES_X

APPS.AP_EXPENSE_REPORT_HEADERS_V is not referenced by any database object