[Home] [Help] [Dependency Information]

TABLE: APPS.OKI_SRM_001_MV

Object Details

Object Name:	OKI_SRM_001_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.OKI_SRM_001_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_001_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("SERVICE_ITEM_CATEGORY_ID") SYS_OP_MAP_NONNULL("CLASS_CODE") SYS_OP_MAP_NONNULL("SERVICE_ITEM_ORG_ID") SYS_OP_MAP_NONNULL("AUTHORING_ORG_ID") SYS_OP_MAP_NONNULL("CUSTOMER_PARTY_ID") SYS_OP_MAP_NONNULL("RESOURCE_GROUP_ID") SYS_OP_MAP_NONNULL("RESOURCE_ID") SYS_OP_MAP_NONNULL("STS_CODE") SYS_OP_MAP_NONNULL("TRN_CODE") SYS_OP_MAP_NONNULL("RENEWAL_FLAG") SYS_OP_MAP_NONNULL("CLE_CREATION_DATE") SYS_OP_MAP_NONNULL("DATE_SIGNED") SYS_OP_MAP_NONNULL("DATE_CANCELLED") SYS_OP_MAP_NONNULL("START_DATE") SYS_OP_MAP_NONNULL("DATE_TERMINATED") SYS_OP_MAP_NONNULL("EFFECTIVE_START_DATE") SYS_OP_MAP_NONNULL("EFFECTIVE_END_DATE") SYS_OP_MAP_NONNULL("EXPECTED_CLOSE_DATE") SYS_OP_MAP_NONNULL("P_GRACE_END_DATE") SYS_OP_MAP_NONNULL("WIN_PERCENT") SYS_OP_MAP_NONNULL("EXP_RENEWAL_FLAG") SYS_OP_MAP_NONNULL("P_TERM_FLAG") SYS_OP_MAP_NONNULL("EFFECTIVE_TERM_DATE") SYS_OP_MAP_NONNULL("EFFECTIVE_EXPIRE_DATE")

Columns

Query Text

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

SELECT SERVICE_ITEM_CATEGORY_ID
,      CLASS_CODE
,      SERVICE_ITEM_ORG_ID
,      AUTHORING_ORG_ID
,      CUSTOMER_PARTY_ID
,      RESOURCE_GROUP_ID
,      RESOURCE_ID
,      STS_CODE
,      TRN_CODE
,      RENEWAL_FLAG
,      CLE_CREATION_DATE
,      DATE_SIGNED
,      DATE_CANCELLED
,      START_DATE
,      DATE_TERMINATED
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EXPECTED_CLOSE_DATE
,      P_GRACE_END_DATE
,      WIN_PERCENT
,      EXP_RENEWAL_FLAG
,      P_TERM_FLAG
,      TRN_BILLED_VALUE_F
,      TRN_BILLED_VALUE_G
,      TRN_BILLED_VALUE_SG
,      TRN_BILLED_VALUE_A
,      P_PRICE_NEGOTIATED_F
,      P_PRICE_NEGOTIATED_G
,      P_PRICE_NEGOTIATED_SG
,      P_PRICE_NEGOTIATED_A
,      C_P_PRICE_NEGOTIATED_F
,      C_P_PRICE_NEGOTIATED_G
,      C_P_PRICE_NEGOTIATED_SG
,      C_P_PRICE_NEGOTIATED_A
,      PRICE_NEGOTIATED_F
,      PRICE_NEGOTIATED_G
,      PRICE_NEGOTIATED_SG
,      PRICE_NEGOTIATED_A
,      C_TRN_BILLED_VALUE_F
,      C_TRN_BILLED_VALUE_G
,      C_TRN_BILLED_VALUE_SG
,      C_TRN_BILLED_VALUE_A
,      C_PRICE_NEGOTIATED_F
,      C_PRICE_NEGOTIATED_G
,      C_PRICE_NEGOTIATED_SG
,      C_PRICE_NEGOTIATED_A
,      C_TOTAL
,      EFFECTIVE_TERM_DATE
,      EFFECTIVE_EXPIRE_DATE
FROM APPS.OKI_SRM_001_MV;

Dependencies

[top of page]

APPS.OKI_SRM_001_MV does not reference any database object

APPS.OKI_SRM_001_MV is referenced by following:

APPS

OKI_SRM_001_MV

OKI_SRM_002_MV

OKI_SRM_011_MV

OKI_SRM_012_MV

OKI_SRM_013_MV

OKI_SRM_014_MV

OKI_SRM_015_MV

OKI_SRM_016_MV

OKI_SRM_017_MV

OKI_SRM_018_MV

OKI_SRM_019_MV

OKI_SRM_020_MV

OKI_SRM_031_MV

OKI_SRM_032_MV

OKI_SRM_033_MV

OKI_SRM_034_MV

OKI_SRM_035_MV

OKI_SRM_036_MV

OKI_SRM_037_MV

OKI_SRM_038_MV

OKI_SRM_039_MV

OKI_SRM_040_MV