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

MATERIALIZED VIEW: APPS.ISC_TRN_003_MV

Object Details
Object Name: ISC_TRN_003_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_TRN_003_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

FII_AP_INVOICE_B
FII_TIME_DAY
ISC_DBI_FTE_INVOICES_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
CARRIER_ID NUMBER

Freight carrier identifier
MODE_OF_TRANSPORT VARCHAR2 (80)
Mode of transport identifier
SERVICE_LEVEL VARCHAR2 (80)
Service level identifier
AGG_LEVEL NUMBER

MV aggregation level flag
GRP_ID NUMBER

Grouping ID column
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
DAY_ID NUMBER

FII day identifier
WEEK_ID NUMBER

FII week identifier
ENT_PERIOD_ID NUMBER

Enterprise period identifer
ENT_QTR_ID NUMBER

Enterprise quarter identifer
BILL_AMT_G NUMBER

Billed amount in primary global currency
BILL_AMT_G_CNT NUMBER

Count column
BILL_AMT_G1 NUMBER

Billed amount in secondary global currency
BILL_AMT_G1_CNT NUMBER

Count column
APPROVED_AMT_G NUMBER

Approved amount in primary global currency
APPROVED_AMT_G_CNT NUMBER

Count column
APPROVED_AMT_G1 NUMBER

Approved amount in secondary global currency
APPROVED_AMT_G1_CNT NUMBER

Count column
FULLY_PAID_AMT_G NUMBER

Fully paid amount in primary global currency
FULLY_PAID_AMT_G_CNT NUMBER

Count column
FULLY_PAID_AMT_G1 NUMBER

Fully paid amount in secondary global currency
FULLY_PAID_AMT_G1_CNT NUMBER

Count column
CNT NUMBER

Row count
Query Text

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


SELECT CARRIER_ID
,      MODE_OF_TRANSPORT
,      SERVICE_LEVEL
,      AGG_LEVEL
,      GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      DAY_ID
,      WEEK_ID
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      BILL_AMT_G
,      BILL_AMT_G_CNT
,      BILL_AMT_G1
,      BILL_AMT_G1_CNT
,      APPROVED_AMT_G
,      APPROVED_AMT_G_CNT
,      APPROVED_AMT_G1
,      APPROVED_AMT_G1_CNT
,      FULLY_PAID_AMT_G
,      FULLY_PAID_AMT_G_CNT
,      FULLY_PAID_AMT_G1
,      FULLY_PAID_AMT_G1_CNT
,      CNT
FROM APPS.ISC_TRN_003_MV;

Dependencies

[top of page]

APPS.ISC_TRN_003_MV references the following:

SchemaAPPS
TableISC_TRN_003_MV
SchemaFII
TableFII_AP_INVOICE_B
TableFII_TIME_DAY
SchemaISC
TableISC_DBI_FTE_INVOICES_F

APPS.ISC_TRN_003_MV is not referenced by any database object