[Home] [Help] [Dependency Information]
Object Name: | OKI_SRM_004_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.OKI_SRM_004_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHR_ID | NUMBER | Yes | ||
RESOURCE_GROUP_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
CLASS_CODE | VARCHAR2 | (30) | Yes | |
CUSTOMER_PARTY_ID | NUMBER | Yes | ||
AUTHORING_ORG_ID | NUMBER | Yes | ||
WIN_PERCENT | NUMBER | |||
EXPECTED_CLOSE_DATE | DATE | |||
DATE_CANCELLED | DATE | |||
DATE_SIGNED | DATE | |||
START_DATE | DATE | |||
END_DATE | DATE | |||
DATE_TERMINATED | DATE | |||
EFFECTIVE_START_DATE | DATE | |||
EFFECTIVE_END_DATE | DATE | |||
EFFECTIVE_TERM_DATE | DATE | |||
EFFECTIVE_EXPIRE_DATE | DATE | |||
EFFECTIVE_ACTIVE_DATE | DATE | |||
TERMINATION_ENTRY_DATE | DATE | |||
STS_CODE | VARCHAR2 | (30) | ||
TRN_CODE | VARCHAR2 | (30) | ||
SERVICE_ITEM_CATEGORY_ID | NUMBER | |||
SERVICE_ITEM_ORG_ID | VARCHAR2 | (81) | ||
RENEWAL_FLAG | NUMBER | Yes | ||
EXP_RENEWAL_FLAG | NUMBER | |||
PAST_DUE_DATE | DATE | |||
PRICE_NEGOTIATED_F | NUMBER | |||
PRICE_NEGOTIATED_G | NUMBER | |||
PRICE_NEGOTIATED_SG | NUMBER | |||
PRICE_NEGOTIATED_A | NUMBER | |||
TRN_BILLED_VALUE_F | NUMBER | |||
TRN_BILLED_VALUE_G | NUMBER | |||
TRN_BILLED_VALUE_SG | NUMBER | |||
TRN_BILLED_VALUE_A | NUMBER | |||
C_PRICE_NEGOTIAED_F | NUMBER | |||
C_PRICE_NEGOTIATED_G | NUMBER | |||
C_PRICE_NEGOTIATED_SG | NUMBER | |||
C_PRICE_NEGOTIATED_A | NUMBER | |||
C_TRN_BILLED_VALUE_F | NUMBER | |||
C_TRN_BILLED_VALUE_G | NUMBER | |||
C_TRN_BILLED_VALUE_SG | NUMBER | |||
C_TRN_BILLED_VALUE_A | NUMBER | |||
C_TOTAL | NUMBER | |||
HSTART_DATE | DATE | Yes | ||
HEND_DATE | DATE | |||
COMPLETE_K_NUMBER | VARCHAR2 | (241) |
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;
APPS.OKI_SRM_004_MV does not reference any database object
APPS.OKI_SRM_004_MV is referenced by following:
|
|
|