[Home] [Help] [Dependency Information]

TABLE: APPS.OKI_SRM_030_MV

Object Details

Object Name:	OKI_SRM_030_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.OKI_SRM_030_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_OKI_SRM_030_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("UMARKER") SYS_OP_MAP_NONNULL("RG_ID") SYS_OP_MAP_NONNULL("PRG_ID") SYS_OP_MAP_NONNULL("SERVICE_ITEM_ORG_ID") SYS_OP_MAP_NONNULL("SERVICE_ITEM_CATEGORY_ID") SYS_OP_MAP_NONNULL("AUTHORING_ORG_ID") SYS_OP_MAP_NONNULL("ENT_YEAR_ID")
OKI_SRM_030_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	C_TOTAL
OKI_SRM_030_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ENT_YEAR_ID PRG_ID UMARKER SERVICE_ITEM_ORG_ID
OKI_SRM_030_MV_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ENT_YEAR_ID PRG_ID UMARKER SERVICE_ITEM_CATEGORY_ID

Columns

Query Text

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

SELECT UMARKER
,      AUTHORING_ORG_ID
,      RG_ID
,      PRG_ID
,      RESOURCE_ID
,      SERVICE_ITEM_ORG_ID
,      SERVICE_ITEM_CATEGORY_ID
,      GRP_ID
,      ENT_YEAR_ID
,      O_R_AMT_F
,      O_R_AMT_G
,      O_R_AMT_SG
,      O_R_AMT_A
,      C_O_R_AMT_F
,      C_O_R_AMT_G
,      C_O_R_AMT_SG
,      C_O_R_AMT_A
,      C_TOTAL
FROM APPS.OKI_SRM_030_MV;

Dependencies

[top of page]

APPS.OKI_SRM_030_MV does not reference any database object

APPS.OKI_SRM_030_MV is referenced by following:

APPS

OKI_SRM_030_MV

OKI_SRM_030_V