[Home] [Help] [Dependency Information]
Object Name: | OKI_SRM_002_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.OKI_SRM_002_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_OKI_SRM_002_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("RG_ID") SYS_OP_MAP_NONNULL("PRG_ID") SYS_OP_MAP_NONNULL("UMARKER") SYS_OP_MAP_NONNULL("STS_CODE") SYS_OP_MAP_NONNULL("TRN_CODE") 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("RENEWAL_FLAG") SYS_OP_MAP_NONNULL("P_TERM_FLAG") SYS_OP_MAP_NONNULL("EXP_RENEWAL_FLAG") SYS_OP_MAP_NONNULL("EFFECTIVE_TERM_DATE") SYS_OP_MAP_NONNULL("EFFECTIVE_EXPIRE_DATE") |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVICE_ITEM_CATEGORY_ID | NUMBER | |||
CLASS_CODE | VARCHAR2 | (30) | Yes | |
SERVICE_ITEM_ORG_ID | VARCHAR2 | (81) | ||
AUTHORING_ORG_ID | NUMBER | Yes | ||
CUSTOMER_PARTY_ID | NUMBER | Yes | ||
RG_ID | NUMBER | |||
PRG_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
UMARKER | VARCHAR2 | (9) | ||
STS_CODE | VARCHAR2 | (30) | ||
TRN_CODE | VARCHAR2 | (30) | ||
CLE_CREATION_DATE | DATE | |||
DATE_SIGNED | DATE | |||
DATE_CANCELLED | DATE | |||
START_DATE | DATE | |||
DATE_TERMINATED | DATE | |||
EFFECTIVE_START_DATE | DATE | |||
EFFECTIVE_END_DATE | DATE | |||
EXPECTED_CLOSE_DATE | DATE | |||
P_GRACE_END_DATE | DATE | |||
WIN_PERCENT | NUMBER | |||
RENEWAL_FLAG | NUMBER | Yes | ||
P_TERM_FLAG | NUMBER | |||
EXP_RENEWAL_FLAG | NUMBER | |||
TRN_BILLED_VALUE_F | NUMBER | |||
TRN_BILLED_VALUE_G | NUMBER | |||
TRN_BILLED_VALUE_SG | NUMBER | |||
TRN_BILLED_VALUE_A | NUMBER | |||
PRICE_NEGOTIATED_F | NUMBER | |||
PRICE_NEGOTIATED_G | NUMBER | |||
PRICE_NEGOTIATED_SG | NUMBER | |||
PRICE_NEGOTIATED_A | NUMBER | |||
P_PRICE_NEGOTIATED_F | NUMBER | |||
P_PRICE_NEGOTIATED_G | NUMBER | |||
P_PRICE_NEGOTIATED_SG | NUMBER | |||
P_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_PRICE_NEGOTIATED_F | NUMBER | |||
C_PRICE_NEGOTIATED_G | NUMBER | |||
C_PRICE_NEGOTIATED_SG | NUMBER | |||
C_PRICE_NEGOTIATED_A | NUMBER | |||
C_P_PRICE_NEGOTIATED_F | NUMBER | |||
C_P_PRICE_NEGOTIATED_G | NUMBER | |||
C_P_PRICE_NEGOTIATED_SG | NUMBER | |||
C_P_PRICE_NEGOTIATED_A | NUMBER | |||
C_TOTAL | NUMBER | |||
EFFECTIVE_TERM_DATE | DATE | |||
EFFECTIVE_EXPIRE_DATE | DATE |
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
, RG_ID
, PRG_ID
, RESOURCE_ID
, UMARKER
, STS_CODE
, TRN_CODE
, 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
, RENEWAL_FLAG
, P_TERM_FLAG
, EXP_RENEWAL_FLAG
, TRN_BILLED_VALUE_F
, TRN_BILLED_VALUE_G
, TRN_BILLED_VALUE_SG
, TRN_BILLED_VALUE_A
, PRICE_NEGOTIATED_F
, PRICE_NEGOTIATED_G
, PRICE_NEGOTIATED_SG
, PRICE_NEGOTIATED_A
, P_PRICE_NEGOTIATED_F
, P_PRICE_NEGOTIATED_G
, P_PRICE_NEGOTIATED_SG
, P_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_P_PRICE_NEGOTIATED_F
, C_P_PRICE_NEGOTIATED_G
, C_P_PRICE_NEGOTIATED_SG
, C_P_PRICE_NEGOTIATED_A
, C_TOTAL
, EFFECTIVE_TERM_DATE
, EFFECTIVE_EXPIRE_DATE
FROM APPS.OKI_SRM_002_MV;
APPS.OKI_SRM_002_MV does not reference any database object
APPS.OKI_SRM_002_MV is referenced by following:
|
|
|