DBA Data[Home] [Help] [Dependency Information]

MATERIALIZED VIEW: APPS.OKI_SRM_005_MV

Object Details
Object Name: OKI_SRM_005_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OKI_SRM_005_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

ENI_OLTP_ITEM_STAR
OKI_DBI_CLE_B

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SLE_ID NUMBER

Internal Identifier of Service Line
CHR_ID NUMBER
Yes Internal Identifier of Contract Header
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract number of Header
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract Number Modifier on the Header
COMPLETE_K_NUMBER VARCHAR2 (241)
Concatenation of Contract number and modifier
LINE_NUMBER VARCHAR2 (300)
Line Number of Service Line
STS_CODE VARCHAR2 (30)
Status Code of Service Line
TRN_CODE VARCHAR2 (30)
Termination Code of Service Line
RENEWAL_TYPE_CODE VARCHAR2 (30)
Renewal Type Code of Service Line
CURR_CODE VARCHAR2 (15)
Transactional Currency Code of Contract Header
CURR_CODE_F VARCHAR2 (15)
Functional Currency Code of Contract Header
ITEM_CATEGORY_ID NUMBER

Internal Category Identifier for this Service Item
ITEM_ID NUMBER

Internal Item Identifier of Service Item
INV_ORG_ID NUMBER

Inventory Organization identifier of Service Item
SCS_CODE VARCHAR2 (30)
Category Code of Contract
AUTHORING_ORG_ID NUMBER
Yes Operating Unit Identifier of Contract
TRX_FUNC_CURR_RATE NUMBER

Conversion Rate From Transactional to Functional Currency
FUNC_GLOBAL_CURR_RATE NUMBER

Conversion Rate from Functional to Primary Global Currency
FUNC_SGLOBAL_CURR_RATE NUMBER

Conversion Rate from Functional to Secondary Global Currency
DATE_CANCELLED DATE

Cancelled Date of Service Line
START_DATE DATE

Start Date of Service Line
END_DATE DATE

End Date of Service Line
DATE_TERMINATED DATE

Termination Date of Service Line
CREATION_DATE DATE

Creation Date of Service Line
LAST_UPDATE_DATE DATE

Last Update Date of Service Line
TERM_CANCEL_SOURCE VARCHAR2 (30)
Termination Source of Service Line
UBT_AMT NUMBER

Unbilled Amount in Transactional currency
UBT_AMT_F NUMBER

Unbilled Amount in Functional currency
UBT_AMT_G NUMBER

Unbilled Amount in Primary Global currency
UBT_AMT_SG NUMBER

Unbilled Amount in Secondary Global currency
UBT_AMT_A NUMBER

Annualized Unbilled Amount
SUPP_CREDIT NUMBER

Suppressed Amount in Transactional currency
SUPP_CREDIT_F NUMBER

Suppressed Amount in Functional currency
SUPP_CREDIT_G NUMBER

Suppressed Amount in Primary Global currency
SUPP_CREDIT_SG NUMBER

Suppressed Amount in Secondary Global currency
SUPP_CREDIT_A NUMBER

Annualized Suppressed Amount
CREDIT_AMT NUMBER

Credit Amount in Transactional currency
CREDIT_AMT_F NUMBER

Credit Amount in Functional currency
CREDIT_AMT_G NUMBER

Credit Amount in Primary Global currency
CREDIT_AMT_SG NUMBER

Credit Amount in Secondary Global currency
CREDIT_AMT_A NUMBER

Annualized Credit Amount
OVERRIDE_AMT NUMBER

Overridden Amount in Transactional currency
OVERRIDE_AMT_F NUMBER

Overridden Amount in Functional currency
OVERRIDE_AMT_G NUMBER

Overridden Amount in Primary Global currency
OVERRIDE_AMT_SG NUMBER

Overridden Amount in Secondary Global currency
OVERRIDE_AMT_A NUMBER

Annualized Overridden Amount
PRICE_NEGO NUMBER

Service line Amount in Transactional currency
PRICE_NEGO_F NUMBER

Service line Amount in Functional currency
PRICE_NEGO_A NUMBER

Service line Amount in Primary Global currency
PRICE_NEGO_G NUMBER

Service line Amount in Secondary Global currency
PRICE_NEGO_SG NUMBER

Annualized Service line Amount
C_UBT_AMT NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_UBT_AMT_F NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_UBT_AMT_G NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_UBT_AMT_SG NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_UBT_AMT_A NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_SUPP_CREDIT NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_SUPP_CREDIT_F NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_SUPP_CREDIT_G NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_SUPP_CREDIT_SG NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_SUPP_CREDIT_A NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_CREDIT_AMT NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_CREDIT_AMT_F NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_CREDIT_AMT_G NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_CREDIT_AMT_SG NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_CREDIT_AMT_A NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_OVERRIDE_AMT NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_OVERRIDE_AMT_F NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_OVERRIDE_AMT_G NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_OVERRIDE_AMT_SG NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_OVERRIDE_AMT_A NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_PRICE_NEGO NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_PRICE_NEGO_F NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_PRICE_NEGO_A NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_PRICE_NEGO_G NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_PRICE_NEGO_SG NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
C_TOTAL NUMBER

Count Columns required to make this Materialized View as Fast Refreshable
Query Text

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


SELECT SLE_ID
,      CHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_K_NUMBER
,      LINE_NUMBER
,      STS_CODE
,      TRN_CODE
,      RENEWAL_TYPE_CODE
,      CURR_CODE
,      CURR_CODE_F
,      ITEM_CATEGORY_ID
,      ITEM_ID
,      INV_ORG_ID
,      SCS_CODE
,      AUTHORING_ORG_ID
,      TRX_FUNC_CURR_RATE
,      FUNC_GLOBAL_CURR_RATE
,      FUNC_SGLOBAL_CURR_RATE
,      DATE_CANCELLED
,      START_DATE
,      END_DATE
,      DATE_TERMINATED
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      TERM_CANCEL_SOURCE
,      UBT_AMT
,      UBT_AMT_F
,      UBT_AMT_G
,      UBT_AMT_SG
,      UBT_AMT_A
,      SUPP_CREDIT
,      SUPP_CREDIT_F
,      SUPP_CREDIT_G
,      SUPP_CREDIT_SG
,      SUPP_CREDIT_A
,      CREDIT_AMT
,      CREDIT_AMT_F
,      CREDIT_AMT_G
,      CREDIT_AMT_SG
,      CREDIT_AMT_A
,      OVERRIDE_AMT
,      OVERRIDE_AMT_F
,      OVERRIDE_AMT_G
,      OVERRIDE_AMT_SG
,      OVERRIDE_AMT_A
,      PRICE_NEGO
,      PRICE_NEGO_F
,      PRICE_NEGO_A
,      PRICE_NEGO_G
,      PRICE_NEGO_SG
,      C_UBT_AMT
,      C_UBT_AMT_F
,      C_UBT_AMT_G
,      C_UBT_AMT_SG
,      C_UBT_AMT_A
,      C_SUPP_CREDIT
,      C_SUPP_CREDIT_F
,      C_SUPP_CREDIT_G
,      C_SUPP_CREDIT_SG
,      C_SUPP_CREDIT_A
,      C_CREDIT_AMT
,      C_CREDIT_AMT_F
,      C_CREDIT_AMT_G
,      C_CREDIT_AMT_SG
,      C_CREDIT_AMT_A
,      C_OVERRIDE_AMT
,      C_OVERRIDE_AMT_F
,      C_OVERRIDE_AMT_G
,      C_OVERRIDE_AMT_SG
,      C_OVERRIDE_AMT_A
,      C_PRICE_NEGO
,      C_PRICE_NEGO_F
,      C_PRICE_NEGO_A
,      C_PRICE_NEGO_G
,      C_PRICE_NEGO_SG
,      C_TOTAL
FROM APPS.OKI_SRM_005_MV;

Dependencies

[top of page]

APPS.OKI_SRM_005_MV references the following:

SchemaAPPS
TableOKI_SRM_005_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaOKI
TableOKI_DBI_CLE_B

APPS.OKI_SRM_005_MV is not referenced by any database object