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

TABLE: AP.AP_WEB_MANAGEMENT_REPORTS_GT

Object Details
Object Name: AP_WEB_MANAGEMENT_REPORTS_GT
Object Type: TABLE
Owner: AP
Subobject Name:
Status: VALID

Temporary Table Details

AP.AP_WEB_MANAGEMENT_REPORTS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
EMPLOYEE_ID NUMBER (10)
SUPERVISOR_ID NUMBER (10)
TOTAL_EXPENSES NUMBER

VIOLATION_LINE_AMOUNT NUMBER

VIOLATION_AMOUNT NUMBER

ALLOWABLE_AMOUNT NUMBER

PERCENT_VIOLATION NUMBER

PERCENT_ALLOWABLE NUMBER

NUMBER_OF_VIOLATIONS NUMBER

MOST_VIOLATED_POLICY VARCHAR2 (80)
FULL_NAME VARCHAR2 (240)
EXPENSE_CATEGORY VARCHAR2 (30)
EXPENSE_CATEGORY_DESC VARCHAR2 (80)
VIOLATION_TYPE VARCHAR2 (30)
VIOLATION_TYPE_DESC VARCHAR2 (80)
PERIOD_TYPE VARCHAR2 (30)
PERIOD_DATE DATE

START_DATE_RANGE DATE

END_DATE_RANGE DATE

ROLLUP_TYPE VARCHAR2 (30)
REPORTING_CURRENCY_CODE VARCHAR2 (15)
Query Text

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


SELECT EMPLOYEE_ID
,      SUPERVISOR_ID
,      TOTAL_EXPENSES
,      VIOLATION_LINE_AMOUNT
,      VIOLATION_AMOUNT
,      ALLOWABLE_AMOUNT
,      PERCENT_VIOLATION
,      PERCENT_ALLOWABLE
,      NUMBER_OF_VIOLATIONS
,      MOST_VIOLATED_POLICY
,      FULL_NAME
,      EXPENSE_CATEGORY
,      EXPENSE_CATEGORY_DESC
,      VIOLATION_TYPE
,      VIOLATION_TYPE_DESC
,      PERIOD_TYPE
,      PERIOD_DATE
,      START_DATE_RANGE
,      END_DATE_RANGE
,      ROLLUP_TYPE
,      REPORTING_CURRENCY_CODE
FROM AP.AP_WEB_MANAGEMENT_REPORTS_GT;

Dependencies

[top of page]

AP.AP_WEB_MANAGEMENT_REPORTS_GT does not reference any database object

AP.AP_WEB_MANAGEMENT_REPORTS_GT is referenced by following:

SchemaAPPS
SynonymAP_WEB_MANAGEMENT_REPORTS_GT