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

TABLE: APPS.ISC_SAM_002_MV

Object Details
Object Name: ISC_SAM_002_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.ISC_SAM_002_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ISC_SAM_002_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnSALES_GRP_ID
ColumnRESOURCE_ID
ColumnAGG_LEVEL
ColumnCUSTOMER_ID
ColumnAGREEMENT_TYPE_ID
ISC_SAM_002_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnSALES_GRP_ID
ColumnRESOURCE_ID
ColumnAGG_LEVEL
ColumnCLASS_CODE
ColumnAGREEMENT_TYPE_ID
ISC_SAM_002_MV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPARENT_GRP_ID
ColumnGRP_MARKER
ColumnAGG_LEVEL
ColumnCUSTOMER_ID
ColumnAGREEMENT_TYPE_ID
ISC_SAM_002_MV_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPARENT_GRP_ID
ColumnGRP_MARKER
ColumnAGG_LEVEL
ColumnCLASS_CODE
ColumnAGREEMENT_TYPE_ID
ISC_SAM_002_MV_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnUMARKER
ColumnC_TOTAL
U_SNAP$_ISC_SAM_002_MV_N5 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("AGREEMENT_TYPE_ID")
ColumnSYS_OP_MAP_NONNULL("GRP_MARKER")
ColumnSYS_OP_MAP_NONNULL("SALES_GRP_ID")
ColumnSYS_OP_MAP_NONNULL("PARENT_GRP_ID")
ColumnSYS_OP_MAP_NONNULL("CLASS_CODE")
ColumnSYS_OP_MAP_NONNULL("CUSTOMER_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_QTR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_PERIOD_ID")
ColumnSYS_OP_MAP_NONNULL("WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("REPORT_DATE_JULIAN")
ColumnSYS_OP_MAP_NONNULL("GRP_ID")
U_SNAP$_ISC_SAM_002_MV_N6 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("AGREEMENT_TYPE_ID")
ColumnSYS_OP_MAP_NONNULL("RESOURCE_ID")
ColumnSYS_OP_MAP_NONNULL("SALES_GRP_ID")
ColumnSYS_OP_MAP_NONNULL("CLASS_CODE")
ColumnSYS_OP_MAP_NONNULL("CUSTOMER_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_QTR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_PERIOD_ID")
ColumnSYS_OP_MAP_NONNULL("WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("REPORT_DATE_JULIAN")
ColumnSYS_OP_MAP_NONNULL("GRP_ID")
Columns
Name Datatype Length Mandatory Comments
UMARKER NUMBER

MV Union Identifier
GRP_MARKER VARCHAR2 (9)
Flag to Identify resource, group or top_group
AGREEMENT_TYPE_ID NUMBER

Agreement Type Identifier
CUSTOMER_ID NUMBER

Customer Identifier
CLASS_CODE VARCHAR2 (30)
Customer Classification Identifier
RESOURCE_ID NUMBER

JTF Resource Identifier
SALES_GRP_ID NUMBER

JTF Sales Group Identifier
PARENT_GRP_ID NUMBER

JTF Parent Group Identifier
AGG_LEVEL NUMBER

MV Aggregation Level Flag
GRP_ID NUMBER

Grouping ID Column
ENT_YEAR_ID NUMBER

Enterprise Year Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER

Week Identifier
REPORT_DATE_JULIAN NUMBER

Julian Date Identifier
TIME_ID NUMBER

Nested Grouping ID Column for Time
COMMIT_AMT_G NUMBER

Amounts For Terminated Agreements in primary global currency
COMMIT_AMT_G1 NUMBER

Amounts For Terminated Agreements in secondary global currency
COMMIT_E_T_EWK_AMT_G NUMBER

Amounts For Expired Agreements in primary global currency
COMMIT_E_T_EWK_AMT_G1 NUMBER

Amounts For Expired Agreements in secondary global currency
COMMIT_E_T_EPD_AMT_G NUMBER

Amounts For Expired Agreements in primary global currency
COMMIT_E_T_EPD_AMT_G1 NUMBER

Amounts For Expired Agreements in secondary global currency
COMMIT_E_T_EQR_AMT_G NUMBER

Amounts For Expired Agreements in primary global currency
COMMIT_E_T_EQR_AMT_G1 NUMBER

Amounts For Expired Agreements in secondary global currency
COMMIT_E_T_EYR_AMT_G NUMBER

Amounts For Expired Agreements in primary global currency
COMMIT_E_T_EYR_AMT_G1 NUMBER

Amounts For Expired Agreements in secondary global currency
COMMIT_T_E_EWK_AMT_G NUMBER

Amounts For Expiring Agreements in primary global currency
COMMIT_T_E_EWK_AMT_G1 NUMBER

Amounts For Expiring Agreements in secondary global currency
COMMIT_T_E_EPD_AMT_G NUMBER

Amounts For Expiring Agreements in primary global currency
COMMIT_T_E_EPD_AMT_G1 NUMBER

Amounts For Expiring Agreements in secondary global currency
COMMIT_T_E_EQR_AMT_G NUMBER

Amounts For Expiring Agreements in primary global currency
COMMIT_T_E_EQR_AMT_G1 NUMBER

Amounts For Expiring Agreements in secondary global currency
COMMIT_T_E_EYR_AMT_G NUMBER

Amounts For Expiring Agreements in primary global currency
COMMIT_T_E_EYR_AMT_G1 NUMBER

Amounts For Expiring Agreements in secondary global currency
FULFILL_OUT_EF_T_EWK_AMT_G NUMBER

Amounts For Unrealized Commitments - Expired in primary global currency
FULFILL_OUT_EF_T_EWK_AMT_G1 NUMBER

Amounts For Unrealized Commitments - Expired in secondary global currency
FULFILL_OUT_EF_T_EPD_AMT_G NUMBER

Amounts For Unrealized Commitments - Expired in primary global currency
FULFILL_OUT_EF_T_EPD_AMT_G1 NUMBER

Amounts For Unrealized Commitments - Expired in secondary global currency
FULFILL_OUT_EF_T_EQR_AMT_G NUMBER

Amounts For Unrealized Commitments - Expired in primary global currency
FULFILL_OUT_EF_T_EQR_AMT_G1 NUMBER

Amounts For Unrealized Commitments - Expired in secondary global currency
FULFILL_OUT_EF_T_EYR_AMT_G NUMBER

Amounts For Unrealized Commitments - Expired in primary global currency
FULFILL_OUT_EF_T_EYR_AMT_G1 NUMBER

Amounts For Unrealized Commitments - Expired in secondary global currency
FULFILL_OUT_F_T_AMT_G NUMBER

Amounts For Unrealized Commitments - Terminated in primary global currency
FULFILL_OUT_F_T_AMT_G1 NUMBER

Amounts For Unrealized Commitments - Terminated in secondary global currency
FULFILL_OUT_F_T_E_EWK_AMT_G NUMBER

Amounts For Outstanding Commitments - Expiring in primary global currency
FULFILL_OUT_F_T_E_EWK_AMT_G1 NUMBER

Amounts For Outstanding Commitments - Expiring in secondary global currency
FULFILL_OUT_F_T_E_EPD_AMT_G NUMBER

Amounts For Outstanding Commitments - Expiring in primary global currency
FULFILL_OUT_F_T_E_EPD_AMT_G1 NUMBER

Amounts For Outstanding Commitments - Expiring in secondary global currency
FULFILL_OUT_F_T_E_EQR_AMT_G NUMBER

Amounts For Outstanding Commitments - Expiring in primary global currency
FULFILL_OUT_F_T_E_EQR_AMT_G1 NUMBER

Amounts For Outstanding Commitments - Expiring in secondary global currency
FULFILL_OUT_F_T_E_EYR_AMT_G NUMBER

Amounts For Outstanding Commitments - Expiring in primary global currency
FULFILL_OUT_F_T_E_EYR_AMT_G1 NUMBER

Amounts For Outstanding Commitments - Expiring in secondary global currency
C_COMMIT_AMT_G NUMBER

Count Column
C_COMMIT_AMT_G1 NUMBER

Count Column
C_COMMIT_E_T_EWK_AMT_G NUMBER

Count Column
C_COMMIT_E_T_EWK_AMT_G1 NUMBER

Count Column
C_COMMIT_E_T_EPD_AMT_G NUMBER

Count Column
C_COMMIT_E_T_EPD_AMT_G1 NUMBER

Count Column
C_COMMIT_E_T_EQR_AMT_G NUMBER

Count Column
C_COMMIT_E_T_EQR_AMT_G1 NUMBER

Count Column
C_COMMIT_E_T_EYR_AMT_G NUMBER

Count Column
C_COMMIT_E_T_EYR_AMT_G1 NUMBER

Count Column
C_COMMIT_T_E_EWK_AMT_G NUMBER

Count Column
C_COMMIT_T_E_EWK_AMT_G1 NUMBER

Count Column
C_COMMIT_T_E_EPD_AMT_G NUMBER

Count Column
C_COMMIT_T_E_EPD_AMT_G1 NUMBER

Count Column
C_COMMIT_T_E_EQR_AMT_G NUMBER

Count Column
C_COMMIT_T_E_EQR_AMT_G1 NUMBER

Count Column
C_COMMIT_T_E_EYR_AMT_G NUMBER

Count Column
C_COMMIT_T_E_EYR_AMT_G1 NUMBER

Count Column
C_FULFILL_OUT_EF_T_EWK_AMT_G NUMBER

Count Column
C_FULFILL_OUT_EF_T_EWK_AMT_G1 NUMBER

Count Column
C_FULFILL_OUT_EF_T_EPD_AMT_G NUMBER

Count Column
C_FULFILL_OUT_EF_T_EPD_AMT_G1 NUMBER

Count Column
C_FULFILL_OUT_EF_T_EQR_AMT_G NUMBER

Count Column
C_FULFILL_OUT_EF_T_EQR_AMT_G1 NUMBER

Count Column
C_FULFILL_OUT_EF_T_EYR_AMT_G NUMBER

Count Column
C_FULFILL_OUT_EF_T_EYR_AMT_G1 NUMBER

Count Column
C_FULFILL_OUT_F_T_AMT_G NUMBER

Count Column
C_FULFILL_OUT_F_T_AMT_G1 NUMBER

Count Column
C_FULFILL_OUT_F_T_E_EWK_AMT_G NUMBER

Count Column
C_FULFILL_OUT_F_T_E_EWK_AMT_G1 NUMBER

Count Column
C_FULFILL_OUT_F_T_E_EPD_AMT_G NUMBER

Count Column
C_FULFILL_OUT_F_T_E_EPD_AMT_G1 NUMBER

Count Column
C_FULFILL_OUT_F_T_E_EQR_AMT_G NUMBER

Count Column
C_FULFILL_OUT_F_T_E_EQR_AMT_G1 NUMBER

Count Column
C_FULFILL_OUT_F_T_E_EYR_AMT_G NUMBER

Count Column
C_FULFILL_OUT_F_T_E_EYR_AMT_G1 NUMBER

Count Column
C_TOTAL NUMBER

Count Column
Query Text

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


SELECT UMARKER
,      GRP_MARKER
,      AGREEMENT_TYPE_ID
,      CUSTOMER_ID
,      CLASS_CODE
,      RESOURCE_ID
,      SALES_GRP_ID
,      PARENT_GRP_ID
,      AGG_LEVEL
,      GRP_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      REPORT_DATE_JULIAN
,      TIME_ID
,      COMMIT_AMT_G
,      COMMIT_AMT_G1
,      COMMIT_E_T_EWK_AMT_G
,      COMMIT_E_T_EWK_AMT_G1
,      COMMIT_E_T_EPD_AMT_G
,      COMMIT_E_T_EPD_AMT_G1
,      COMMIT_E_T_EQR_AMT_G
,      COMMIT_E_T_EQR_AMT_G1
,      COMMIT_E_T_EYR_AMT_G
,      COMMIT_E_T_EYR_AMT_G1
,      COMMIT_T_E_EWK_AMT_G
,      COMMIT_T_E_EWK_AMT_G1
,      COMMIT_T_E_EPD_AMT_G
,      COMMIT_T_E_EPD_AMT_G1
,      COMMIT_T_E_EQR_AMT_G
,      COMMIT_T_E_EQR_AMT_G1
,      COMMIT_T_E_EYR_AMT_G
,      COMMIT_T_E_EYR_AMT_G1
,      FULFILL_OUT_EF_T_EWK_AMT_G
,      FULFILL_OUT_EF_T_EWK_AMT_G1
,      FULFILL_OUT_EF_T_EPD_AMT_G
,      FULFILL_OUT_EF_T_EPD_AMT_G1
,      FULFILL_OUT_EF_T_EQR_AMT_G
,      FULFILL_OUT_EF_T_EQR_AMT_G1
,      FULFILL_OUT_EF_T_EYR_AMT_G
,      FULFILL_OUT_EF_T_EYR_AMT_G1
,      FULFILL_OUT_F_T_AMT_G
,      FULFILL_OUT_F_T_AMT_G1
,      FULFILL_OUT_F_T_E_EWK_AMT_G
,      FULFILL_OUT_F_T_E_EWK_AMT_G1
,      FULFILL_OUT_F_T_E_EPD_AMT_G
,      FULFILL_OUT_F_T_E_EPD_AMT_G1
,      FULFILL_OUT_F_T_E_EQR_AMT_G
,      FULFILL_OUT_F_T_E_EQR_AMT_G1
,      FULFILL_OUT_F_T_E_EYR_AMT_G
,      FULFILL_OUT_F_T_E_EYR_AMT_G1
,      C_COMMIT_AMT_G
,      C_COMMIT_AMT_G1
,      C_COMMIT_E_T_EWK_AMT_G
,      C_COMMIT_E_T_EWK_AMT_G1
,      C_COMMIT_E_T_EPD_AMT_G
,      C_COMMIT_E_T_EPD_AMT_G1
,      C_COMMIT_E_T_EQR_AMT_G
,      C_COMMIT_E_T_EQR_AMT_G1
,      C_COMMIT_E_T_EYR_AMT_G
,      C_COMMIT_E_T_EYR_AMT_G1
,      C_COMMIT_T_E_EWK_AMT_G
,      C_COMMIT_T_E_EWK_AMT_G1
,      C_COMMIT_T_E_EPD_AMT_G
,      C_COMMIT_T_E_EPD_AMT_G1
,      C_COMMIT_T_E_EQR_AMT_G
,      C_COMMIT_T_E_EQR_AMT_G1
,      C_COMMIT_T_E_EYR_AMT_G
,      C_COMMIT_T_E_EYR_AMT_G1
,      C_FULFILL_OUT_EF_T_EWK_AMT_G
,      C_FULFILL_OUT_EF_T_EWK_AMT_G1
,      C_FULFILL_OUT_EF_T_EPD_AMT_G
,      C_FULFILL_OUT_EF_T_EPD_AMT_G1
,      C_FULFILL_OUT_EF_T_EQR_AMT_G
,      C_FULFILL_OUT_EF_T_EQR_AMT_G1
,      C_FULFILL_OUT_EF_T_EYR_AMT_G
,      C_FULFILL_OUT_EF_T_EYR_AMT_G1
,      C_FULFILL_OUT_F_T_AMT_G
,      C_FULFILL_OUT_F_T_AMT_G1
,      C_FULFILL_OUT_F_T_E_EWK_AMT_G
,      C_FULFILL_OUT_F_T_E_EWK_AMT_G1
,      C_FULFILL_OUT_F_T_E_EPD_AMT_G
,      C_FULFILL_OUT_F_T_E_EPD_AMT_G1
,      C_FULFILL_OUT_F_T_E_EQR_AMT_G
,      C_FULFILL_OUT_F_T_E_EQR_AMT_G1
,      C_FULFILL_OUT_F_T_E_EYR_AMT_G
,      C_FULFILL_OUT_F_T_E_EYR_AMT_G1
,      C_TOTAL
FROM APPS.ISC_SAM_002_MV;

Dependencies

[top of page]

APPS.ISC_SAM_002_MV does not reference any database object

APPS.ISC_SAM_002_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_SAM_002_MV