[Home] [Help] [Dependency Information]

TABLE: APPS.OKI_SRM_004_MV

Object Details

Object Name:	OKI_SRM_004_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.OKI_SRM_004_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_004_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("CHR_ID") SYS_OP_MAP_NONNULL("RESOURCE_GROUP_ID") SYS_OP_MAP_NONNULL("RESOURCE_ID") SYS_OP_MAP_NONNULL("EXPECTED_CLOSE_DATE") SYS_OP_MAP_NONNULL("DATE_CANCELLED") SYS_OP_MAP_NONNULL("DATE_SIGNED") SYS_OP_MAP_NONNULL("START_DATE") SYS_OP_MAP_NONNULL("END_DATE") SYS_OP_MAP_NONNULL("EFFECTIVE_START_DATE") SYS_OP_MAP_NONNULL("EFFECTIVE_END_DATE") SYS_OP_MAP_NONNULL("DATE_TERMINATED") SYS_OP_MAP_NONNULL("EFFECTIVE_TERM_DATE") SYS_OP_MAP_NONNULL("EFFECTIVE_EXPIRE_DATE") SYS_OP_MAP_NONNULL("EFFECTIVE_ACTIVE_DATE") SYS_OP_MAP_NONNULL("TERMINATION_ENTRY_DATE") SYS_OP_MAP_NONNULL("TRN_CODE") SYS_OP_MAP_NONNULL("STS_CODE") SYS_OP_MAP_NONNULL("CUSTOMER_PARTY_ID") SYS_OP_MAP_NONNULL("AUTHORING_ORG_ID") SYS_OP_MAP_NONNULL("WIN_PERCENT") SYS_OP_MAP_NONNULL("PAST_DUE_DATE") SYS_OP_MAP_NONNULL("SERVICE_ITEM_ORG_ID") SYS_OP_MAP_NONNULL("RENEWAL_FLAG") SYS_OP_MAP_NONNULL("EXP_RENEWAL_FLAG") SYS_OP_MAP_NONNULL("CLASS_CODE") SYS_OP_MAP_NONNULL("SERVICE_ITEM_CATEGORY_ID") SYS_OP_MAP_NONNULL("HSTART_DATE") SYS_OP_MAP_NONNULL("HEND_DATE") SYS_OP_MAP_NONNULL("COMPLETE_K_NUMBER")
OKI_SRM_004_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RESOURCE_GROUP_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE DATE_SIGNED
OKI_SRM_004_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RESOURCE_GROUP_ID RENEWAL_FLAG EFFECTIVE_ACTIVE_DATE DATE_SIGNED
OKI_SRM_004_MV_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RESOURCE_GROUP_ID EFFECTIVE_EXPIRE_DATE EXP_RENEWAL_FLAG DATE_SIGNED
OKI_SRM_004_MV_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RESOURCE_GROUP_ID EFFECTIVE_TERM_DATE
OKI_SRM_004_MV_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RESOURCE_GROUP_ID START_DATE RENEWAL_FLAG PAST_DUE_DATE
OKI_SRM_004_MV_N6	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RESOURCE_GROUP_ID EXPECTED_CLOSE_DATE RENEWAL_FLAG PAST_DUE_DATE
OKI_SRM_004_MV_N7	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RESOURCE_GROUP_ID DATE_CANCELLED RENEWAL_FLAG

Columns

Query Text

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

SELECT CHR_ID
,      RESOURCE_GROUP_ID
,      RESOURCE_ID
,      CLASS_CODE
,      CUSTOMER_PARTY_ID
,      AUTHORING_ORG_ID
,      WIN_PERCENT
,      EXPECTED_CLOSE_DATE
,      DATE_CANCELLED
,      DATE_SIGNED
,      START_DATE
,      END_DATE
,      DATE_TERMINATED
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EFFECTIVE_TERM_DATE
,      EFFECTIVE_EXPIRE_DATE
,      EFFECTIVE_ACTIVE_DATE
,      TERMINATION_ENTRY_DATE
,      STS_CODE
,      TRN_CODE
,      SERVICE_ITEM_CATEGORY_ID
,      SERVICE_ITEM_ORG_ID
,      RENEWAL_FLAG
,      EXP_RENEWAL_FLAG
,      PAST_DUE_DATE
,      PRICE_NEGOTIATED_F
,      PRICE_NEGOTIATED_G
,      PRICE_NEGOTIATED_SG
,      PRICE_NEGOTIATED_A
,      TRN_BILLED_VALUE_F
,      TRN_BILLED_VALUE_G
,      TRN_BILLED_VALUE_SG
,      TRN_BILLED_VALUE_A
,      C_PRICE_NEGOTIAED_F
,      C_PRICE_NEGOTIATED_G
,      C_PRICE_NEGOTIATED_SG
,      C_PRICE_NEGOTIATED_A
,      C_TRN_BILLED_VALUE_F
,      C_TRN_BILLED_VALUE_G
,      C_TRN_BILLED_VALUE_SG
,      C_TRN_BILLED_VALUE_A
,      C_TOTAL
,      HSTART_DATE
,      HEND_DATE
,      COMPLETE_K_NUMBER
FROM APPS.OKI_SRM_004_MV;

Dependencies

[top of page]

APPS.OKI_SRM_004_MV does not reference any database object

APPS.OKI_SRM_004_MV is referenced by following:

APPS

OKI_SRM_004_MV