Skip to content

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

MATERIALIZED VIEW: APPS.OKI_SRM_006_MV

Object Details
Object Name: OKI_SRM_006_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OKI_SRM_006_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:

OKI_DBI_CLE_B

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
CHR_ID NUMBER
Yes Unique Contract Header Id
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number on the header
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract Number Modifier on the Header
COMPLETE_K_NUMBER VARCHAR2 (241)
Concatenation of Contract number and modifier
CUSTOMER_PARTY_ID NUMBER
Yes Customer Identifier of Contract
SALESREP_ID NUMBER

Salesrep Identifier of Contract
AUTHORING_ORG_ID NUMBER
Yes Operating Unit Identifier of Contract
RG_ID NUMBER

Resource Group Identifier of Contract
RESOURCE_ID NUMBER

Resource Identifier of Contract
SCS_CODE VARCHAR2 (30)
Catetory Identifier of Contract
STS_CODE VARCHAR2 (30)
Status Code of Contract
TRN_CODE VARCHAR2 (30)
Termination Code of Contract
RENEWAL_TYPE_CODE VARCHAR2 (30)
Renewal Type Code of Contract
ORDER_NUMBER NUMBER

Order Number of Contract
CURR_CODE VARCHAR2 (15)
Transactional Currency Code of Contract
CURR_CODE_F VARCHAR2 (15)
Functional Currency Code of Contract
WIN_PERCENT NUMBER

Estimation Percent
EXPECTED_CLOSE_DATE DATE

Estimated Close Date of Contract
DATE_CANCELLED DATE

Cancellation Date of Contract
DATE_SIGNED DATE

Signed Date of Contract
START_DATE DATE

Start Date of Contract
END_DATE DATE

End Date of Contract
GRACE_END_DATE DATE

Grace End Date of Contract
DATE_APPROVED DATE

Approved Date of contract
DATE_TERMINATED DATE

Termination Date of contract
CREATION_DATE DATE

Contract Creation Date
LAST_UPDATE_DATE DATE

Contract Last update Date
BILL_SITE_ID NUMBER

Bill to Site Identifier of Contract
SHIP_SITE_ID NUMBER

Ship to Site Identifier of Contract
ACCT_RULE_ID NUMBER

Account Rule Identifier of Contract
SUBSEQUENT_RENEWAL_TYPE_CODE VARCHAR2 (30)
Subsequent Renewal Type Code of Contract
NEGOTIATION_STATUS VARCHAR2 (30)
Provides Negotiation Status of the Contract
REMINDER VARCHAR2 (30)
Provides status of reminder, whether it is enable or disable
TERM_CANCEL_SOURCE VARCHAR2 (30)
Provides Termination source of Contract
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

Contract Amount in Transactional currency
PRICE_NEGO_F NUMBER

Contract Amount in Functional currency
PRICE_NEGO_A NUMBER

Contract Amount in Primary Global currency
PRICE_NEGO_G NUMBER

Contract Amount in Secondary Global currency
PRICE_NEGO_SG NUMBER

Annualized Contract 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 CHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_K_NUMBER
,      CUSTOMER_PARTY_ID
,      SALESREP_ID
,      AUTHORING_ORG_ID
,      RG_ID
,      RESOURCE_ID
,      SCS_CODE
,      STS_CODE
,      TRN_CODE
,      RENEWAL_TYPE_CODE
,      ORDER_NUMBER
,      CURR_CODE
,      CURR_CODE_F
,      WIN_PERCENT
,      EXPECTED_CLOSE_DATE
,      DATE_CANCELLED
,      DATE_SIGNED
,      START_DATE
,      END_DATE
,      GRACE_END_DATE
,      DATE_APPROVED
,      DATE_TERMINATED
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      BILL_SITE_ID
,      SHIP_SITE_ID
,      ACCT_RULE_ID
,      SUBSEQUENT_RENEWAL_TYPE_CODE
,      NEGOTIATION_STATUS
,      REMINDER
,      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_006_MV;

Dependencies

[top of page]

APPS.OKI_SRM_006_MV references the following:

SchemaAPPS
TableOKI_SRM_006_MV
SchemaOKI
TableOKI_DBI_CLE_B

APPS.OKI_SRM_006_MV is not referenced by any database object