[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKI_SRM_006_MV |
|---|---|
| Object Type: | TABLE |
| Owner: | APPS |
| FND Design Data: |  FND.OKI_SRM_006_MV
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| I_SNAP$_OKI_SRM_006_MV | FUNCTION-BASED NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 SYS_OP_MAP_NONNULL("CHR_ID")
SYS_OP_MAP_NONNULL("CONTRACT_NUMBER")
SYS_OP_MAP_NONNULL("CONTRACT_NUMBER_MODIFIER")
SYS_OP_MAP_NONNULL("COMPLETE_K_NUMBER")
SYS_OP_MAP_NONNULL("CUSTOMER_PARTY_ID")
SYS_OP_MAP_NONNULL("SALESREP_ID")
SYS_OP_MAP_NONNULL("AUTHORING_ORG_ID")
SYS_OP_MAP_NONNULL("RG_ID")
SYS_OP_MAP_NONNULL("RESOURCE_ID")
SYS_OP_MAP_NONNULL("SCS_CODE")
SYS_OP_MAP_NONNULL("STS_CODE")
SYS_OP_MAP_NONNULL("TRN_CODE")
SYS_OP_MAP_NONNULL("RENEWAL_TYPE_CODE")
SYS_OP_MAP_NONNULL("ORDER_NUMBER")
SYS_OP_MAP_NONNULL("CURR_CODE")
SYS_OP_MAP_NONNULL("CURR_CODE_F")
SYS_OP_MAP_NONNULL("WIN_PERCENT")
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("DATE_APPROVED")
SYS_OP_MAP_NONNULL("DATE_TERMINATED")
SYS_OP_MAP_NONNULL("GRACE_END_DATE")
SYS_OP_MAP_NONNULL("CREATION_DATE")
SYS_OP_MAP_NONNULL("LAST_UPDATE_DATE")
SYS_OP_MAP_NONNULL("BILL_SITE_ID")
SYS_OP_MAP_NONNULL("SHIP_SITE_ID")
SYS_OP_MAP_NONNULL("ACCT_RULE_ID")
SYS_OP_MAP_NONNULL("SUBSEQUENT_RENEWAL_TYPE_CODE")
SYS_OP_MAP_NONNULL("NEGOTIATION_STATUS")
|
| OKI_SRM_006_MV_N1 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
START_DATE
|
| OKI_SRM_006_MV_N2 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
END_DATE
|
| OKI_SRM_006_MV_N3 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_CANCELLED
|
| OKI_SRM_006_MV_N4 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_TERMINATED
|
| OKI_SRM_006_MV_N5 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_APPROVED
|
| OKI_SRM_006_MV_N6 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
CUSTOMER_PARTY_ID
|
| OKI_SRM_006_MV_N7 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
RESOURCE_ID
|
| OKI_SRM_006_MV_N8 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
AUTHORING_ORG_ID
|
| OKI_SRM_006_MV_N9 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
STS_CODE
|
| OKI_SRM_006_MV_U1 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
CHR_ID
|
| OKI_SRM_006_MV_U2 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
CONTRACT_NUMBER
CONTRACT_NUMBER_MODIFIER
|
| 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 |
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;
APPS.OKI_SRM_006_MV does not reference any database object
APPS.OKI_SRM_006_MV is referenced by following:
APPS
OKI_SRM_006_MV
OKI_SRM_006_V
|
|
|
|