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

VIEW: APPS.OIE_MGR_RPT_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
EMPLOYEE_ID NUMBER


FULL_NAME VARCHAR2 (240)
EXPENSE_REPORT_DATE DATE


REPORT_HEADER_ID NUMBER


DISTRIBUTION_LINE_NUMBER NUMBER

Line number for invoice distribution line created from expense report line
CATEGORY_CODE VARCHAR2 (30)
VIOLATION_TYPE VARCHAR2 (30)
LINE_AMOUNT NUMBER

ALLOWABLE_AMOUNT NUMBER

VIOLATION_AMOUNT NUMBER

NUMBER_OF_VIOLATIONS NUMBER

SUPERVISOR_ID NUMBER (10)
Query Text

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


SELECT EMPLOYEE_ID
,      FULL_NAME
,      EXPENSE_REPORT_DATE
,      REPORT_HEADER_ID
,      DISTRIBUTION_LINE_NUMBER
,      CATEGORY_CODE
,      VIOLATION_TYPE
,      LINE_AMOUNT
,      ALLOWABLE_AMOUNT
,      VIOLATION_AMOUNT
,      NUMBER_OF_VIOLATIONS
,      SUPERVISOR_ID
FROM APPS.OIE_MGR_RPT_V;

Dependencies

[top of page]

APPS.OIE_MGR_RPT_V references the following:

SchemaAPPS
SynonymAP_EXPENSE_REPORTS
SynonymAP_EXPENSE_REPORT_HEADERS
SynonymAP_EXPENSE_REPORT_LINES
SynonymAP_EXPENSE_REPORT_PARAMS
SynonymAP_POL_VIOLATIONS
SynonymAP_SYSTEM_PARAMETERS
PL/SQL PackageAP_WEB_OA_ACTIVE_PKG - show dependent code
PL/SQL PackageGL_CURRENCY_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_ASSIGNMENTS_F
ViewPER_PEOPLE_X

APPS.OIE_MGR_RPT_V is not referenced by any database object