[Home] [Help] [Dependency Information]
Object Name: | OKI_SRM_004_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | OKI_SRM_004_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
ENI_OLTP_ITEM_STAR
FII_PARTY_MKT_CLASS
OKI_DBI_CLE_B
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 is not referenced by any database object
|
|
|