Skip to content

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

TABLE: APPS.ASO_BI_QOT_APRB_MV

Object Details
Object Name: ASO_BI_QOT_APRB_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
UMARKER CHAR (6)
Marker for fast refreshability purpose
RESOURCE_GRP_ID NUMBER

Resource group id
RESOURCE_ID NUMBER

Resource id
OPEN NUMBER

Open approval count
NEW NUMBER

New approvals count
COMPLETE NUMBER

Completed approvals count
APPROVED NUMBER

Approved approvals count
DAYS_FOR_APPROVAL NUMBER

Number of days for approval
APPROVERS NUMBER

Number of approvers
APPROVED_XCNT NUMBER

For fast refreshability purpose
DAYS_FOR_APPROVAL_XCNT NUMBER

For fast refreshability purpose
APPROVERS_XCNT NUMBER

For fast refreshability purpose
COMPLETE_XCNT NUMBER

For fast refreshability purpose
DAY_ID NUMBER

Day id
WEEK_ID NUMBER

Week id
ENT_PERIOD_ID NUMBER

Period id
ENT_QTR_ID NUMBER

Quarter id
ENT_YEAR_ID NUMBER

Year id
Query Text

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


SELECT UMARKER
,      RESOURCE_GRP_ID
,      RESOURCE_ID
,      OPEN
,      NEW
,      COMPLETE
,      APPROVED
,      DAYS_FOR_APPROVAL
,      APPROVERS
,      APPROVED_XCNT
,      DAYS_FOR_APPROVAL_XCNT
,      APPROVERS_XCNT
,      COMPLETE_XCNT
,      DAY_ID
,      WEEK_ID
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      ENT_YEAR_ID
FROM APPS.ASO_BI_QOT_APRB_MV;

Dependencies

[top of page]

APPS.ASO_BI_QOT_APRB_MV does not reference any database object

APPS.ASO_BI_QOT_APRB_MV is referenced by following:

SchemaAPPS
Materialized ViewASO_BI_QOT_APRB_MV
Materialized ViewASO_BI_QOT_APR_MV