[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MLOG$_OKI_DBI_CLE_B |
|---|---|
| Object Type: | TABLE |
| Owner: | OKI |
| Subobject Name: | |
| Status: | VALID |
snapshot log for master table OKI.OKI_DBI_CLE_B
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 60 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| APPLICATION_ID | NUMBER | |||
| AUTHORING_ORG_ID | NUMBER | |||
| BUY_OR_SELL | VARCHAR2 | (3) | ||
| CHR_ID | NUMBER | |||
| CLE_CREATION_DATE | DATE | |||
| CLE_ID | NUMBER | |||
| CONTRACT_NUMBER | VARCHAR2 | (120) | ||
| CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | ||
| COVERED_ITEM_ID | NUMBER | |||
| COVERED_ITEM_ORG_ID | NUMBER | |||
| CREATED_BY | NUMBER | |||
| CREATION_DATE | DATE | |||
| CREDIT_AMT | NUMBER | |||
| CREDIT_AMT_F | NUMBER | |||
| CREDIT_AMT_G | NUMBER | |||
| CREDIT_AMT_SG | NUMBER | |||
| CUSTOMER_PARTY_ID | NUMBER | |||
| DATE_CANCELLED | DATE | |||
| DATE_SIGNED | DATE | |||
| DATE_TERMINATED | DATE | |||
| EFFECTIVE_END_DATE | DATE | |||
| EFFECTIVE_START_DATE | DATE | |||
| END_DATE | DATE | |||
| EXPECTED_CLOSE_DATE | DATE | |||
| FUNC_GLOBAL_CURR_RATE | NUMBER | |||
| FUNC_SGLOBAL_CURR_RATE | NUMBER | |||
| GRACE_END_DATE | DATE | |||
| HEND_DATE | DATE | |||
| HSTART_DATE | DATE | |||
| INV_ORGANIZATION_ID | NUMBER | |||
| LAST_UPDATED_BY | NUMBER | |||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATE_LOGIN | NUMBER | |||
| OVERRIDE_AMT | NUMBER | |||
| OVERRIDE_AMT_F | NUMBER | |||
| OVERRIDE_AMT_G | NUMBER | |||
| OVERRIDE_AMT_SG | NUMBER | |||
| PRICE_NEGOTIATED | NUMBER | |||
| PRICE_NEGOTIATED_F | NUMBER | |||
| PRICE_NEGOTIATED_G | NUMBER | |||
| PRICE_NEGOTIATED_SG | NUMBER | |||
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_LOGIN_ID | NUMBER | |||
| QUANTITY | NUMBER | |||
| RENEWAL_FLAG | NUMBER | |||
| RENEWAL_TYPE | VARCHAR2 | (30) | ||
| RENEWED_FLAG | VARCHAR2 | (1) | ||
| REQUEST_ID | NUMBER | |||
| RESOURCE_GROUP_ID | NUMBER | |||
| RESOURCE_ID | NUMBER | |||
| ROOT_LTY_CODE | VARCHAR2 | (30) | ||
| R_CHR_ID | NUMBER | |||
| R_CLE_CREATION_DATE | DATE | |||
| R_CLE_ID | NUMBER | |||
| R_CONTRACT_NUMBER | VARCHAR2 | (120) | ||
| R_CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | ||
| R_COVERED_ITEM_ID | NUMBER | |||
| R_COVERED_ITEM_ORG_ID | NUMBER | |||
| R_CREDIT_AMT | NUMBER | |||
| R_CREDIT_AMT_F | NUMBER | |||
| R_CREDIT_AMT_G | NUMBER | |||
| R_CREDIT_AMT_SG | NUMBER | |||
| R_DATE_CANCELLED | DATE | |||
| R_DATE_SIGNED | DATE | |||
| R_DATE_TERMINATED | DATE | |||
| R_EFFECTIVE_END_DATE | DATE | |||
| R_EFFECTIVE_START_DATE | DATE | |||
| R_END_DATE | DATE | |||
| R_EXPECTED_CLOSE_DATE | DATE | |||
| R_GRACE_END_DATE | DATE | |||
| R_OVERRIDE_AMT | NUMBER | |||
| R_OVERRIDE_AMT_F | NUMBER | |||
| R_OVERRIDE_AMT_G | NUMBER | |||
| R_OVERRIDE_AMT_SG | NUMBER | |||
| R_PRICE_NEGOTIATED | NUMBER | |||
| R_PRICE_NEGOTIATED_F | NUMBER | |||
| R_PRICE_NEGOTIATED_G | NUMBER | |||
| R_PRICE_NEGOTIATED_SG | NUMBER | |||
| R_RENEWAL_FLAG | NUMBER | |||
| R_RESOURCE_GROUP_ID | NUMBER | |||
| R_RESOURCE_ID | NUMBER | |||
| R_SALESREP_ID | NUMBER | |||
| R_SCS_CODE | VARCHAR2 | (30) | ||
| R_SERVICE_ITEM_ID | NUMBER | |||
| R_START_DATE | DATE | |||
| R_STS_CODE | VARCHAR2 | (30) | ||
| R_SUPP_CREDIT | NUMBER | |||
| R_SUPP_CREDIT_F | NUMBER | |||
| R_SUPP_CREDIT_G | NUMBER | |||
| R_SUPP_CREDIT_SG | NUMBER | |||
| R_TERM_FLAG | NUMBER | |||
| R_TRN_CODE | VARCHAR2 | (30) | ||
| R_UBT_AMT | NUMBER | |||
| R_UBT_AMT_F | NUMBER | |||
| R_UBT_AMT_G | NUMBER | |||
| R_UBT_AMT_SG | NUMBER | |||
| R_WIN_PERCENT | NUMBER | |||
| SALESREP_ID | NUMBER | |||
| SCS_CODE | VARCHAR2 | (30) | ||
| SECURITY_GROUP_ID | NUMBER | |||
| SERVICE_ITEM_ID | NUMBER | |||
| SLE_ID | NUMBER | |||
| START_DATE | DATE | |||
| STS_CODE | VARCHAR2 | (30) | ||
| SUPP_CREDIT | NUMBER | |||
| SUPP_CREDIT_F | NUMBER | |||
| SUPP_CREDIT_G | NUMBER | |||
| SUPP_CREDIT_SG | NUMBER | |||
| TERM_FLAG | NUMBER | |||
| TRN_CODE | VARCHAR2 | (30) | ||
| TRX_FUNC_CURR_RATE | NUMBER | |||
| TRX_MST_UOM_CONV_RATE | NUMBER | |||
| UBT_AMT | NUMBER | |||
| UBT_AMT_F | NUMBER | |||
| UBT_AMT_G | NUMBER | |||
| UBT_AMT_SG | NUMBER | |||
| UOM_CODE | VARCHAR2 | (3) | ||
| WIN_PERCENT | NUMBER | |||
| M_ROW$$ | VARCHAR2 | (255) | ||
| SEQUENCE$$ | NUMBER | |||
| SNAPTIME$$ | DATE | |||
| DMLTYPE$$ | VARCHAR2 | (1) | ||
| OLD_NEW$$ | VARCHAR2 | (1) | ||
| CHANGE_VECTOR$$ | RAW | (255) | ||
| ANNUALIZATION_FACTOR | NUMBER | |||
| CL_LAST_UPDATE_DATE | DATE | |||
| COV_PROD_ID | NUMBER | |||
| COV_PROD_SYSTEM_ID | NUMBER | |||
| CREDIT_AMT_A | NUMBER | |||
| CURR_CODE | VARCHAR2 | (15) | ||
| CURR_CODE_F | VARCHAR2 | (15) | ||
| DURATION_QTY | NUMBER | |||
| DURATION_UOM | VARCHAR2 | (3) | ||
| EFFECTIVE_ACTIVE_DATE | DATE | |||
| EFFECTIVE_EXPIRE_DATE | DATE | |||
| EFFECTIVE_TERM_DATE | DATE | |||
| FALSERNWLYN | VARCHAR2 | (1) | ||
| GSD_FLAG | NUMBER | |||
| HDR_ACCT_RULE_ID | NUMBER | |||
| HDR_BILL_SITE_ID | NUMBER | |||
| HDR_CREATION_DATE | DATE | |||
| HDR_DATE_APPROVED | DATE | |||
| HDR_DATE_CANCELLED | DATE | |||
| HDR_DATE_SIGNED | DATE | |||
| HDR_DATE_TERMINATED | DATE | |||
| HDR_GRACE_END_DATE | DATE | |||
| HDR_LAST_UPDATE_DATE | DATE | |||
| HDR_ORDER_NUMBER | NUMBER | |||
| HDR_RENEWAL_TYPE | VARCHAR2 | (30) | ||
| HDR_SHIP_SITE_ID | NUMBER | |||
| HDR_STS_CODE | VARCHAR2 | (30) | ||
| HDR_TRN_CODE | VARCHAR2 | (30) | ||
| LINE_NUMBER | VARCHAR2 | (300) | ||
| LINE_TYPE | VARCHAR2 | (30) | ||
| LIST_PRICE | NUMBER | |||
| LIST_PRICE_F | NUMBER | |||
| LIST_PRICE_G | NUMBER | |||
| LIST_PRICE_SG | NUMBER | |||
| ORDER_NUMBER | NUMBER | |||
| OVERRIDE_AMT_A | NUMBER | |||
| PRICE_NEGOTIATED_A | NUMBER | |||
| P_CHR_ID | NUMBER | |||
| P_CLE_ID | NUMBER | |||
| P_CREDIT_AMT | NUMBER | |||
| P_CREDIT_AMT_A | NUMBER | |||
| P_CREDIT_AMT_F | NUMBER | |||
| P_CREDIT_AMT_G | NUMBER | |||
| P_CREDIT_AMT_SG | NUMBER | |||
| P_END_DATE | DATE | |||
| P_GRACE_END_DATE | DATE | |||
| P_OVERRIDE_AMT | NUMBER | |||
| P_OVERRIDE_AMT_A | NUMBER | |||
| P_OVERRIDE_AMT_F | NUMBER | |||
| P_OVERRIDE_AMT_G | NUMBER | |||
| P_OVERRIDE_AMT_SG | NUMBER | |||
| P_PRICE_NEGOTIATED | NUMBER | |||
| P_PRICE_NEGOTIATED_A | NUMBER | |||
| P_PRICE_NEGOTIATED_F | NUMBER | |||
| P_PRICE_NEGOTIATED_G | NUMBER | |||
| P_PRICE_NEGOTIATED_SG | NUMBER | |||
| P_SUPP_CREDIT | NUMBER | |||
| P_SUPP_CREDIT_A | NUMBER | |||
| P_SUPP_CREDIT_F | NUMBER | |||
| P_SUPP_CREDIT_G | NUMBER | |||
| P_SUPP_CREDIT_SG | NUMBER | |||
| P_TERM_FLAG | NUMBER | |||
| P_UBT_AMT | NUMBER | |||
| P_UBT_AMT_A | NUMBER | |||
| P_UBT_AMT_F | NUMBER | |||
| P_UBT_AMT_G | NUMBER | |||
| P_UBT_AMT_SG | NUMBER | |||
| SERVICE_ITEM_ORG_ID | NUMBER | |||
| SL_CREATION_DATE | DATE | |||
| SL_DATE_CANCELLED | DATE | |||
| SL_DATE_TERMINATED | DATE | |||
| SL_END_DATE | DATE | |||
| SL_LAST_UPDATE_DATE | DATE | |||
| SL_LINE_NUMBER | VARCHAR2 | (300) | ||
| SL_RENEWAL_TYPE | VARCHAR2 | (30) | ||
| SL_START_DATE | DATE | |||
| SL_STS_CODE | VARCHAR2 | (30) | ||
| SL_TRN_CODE | VARCHAR2 | (30) | ||
| SUPP_CREDIT_A | NUMBER | |||
| TERMINATION_ENTRY_DATE | DATE | |||
| UBT_AMT_A | NUMBER | |||
| UNIT_PRICE | NUMBER | |||
| UNIT_PRICE_F | NUMBER | |||
| UNIT_PRICE_G | NUMBER | |||
| UNIT_PRICE_PERCENT | NUMBER | |||
| UNIT_PRICE_SG | NUMBER | |||
| HDR_SUBSEQUENT_RENEWAL_TYPE | VARCHAR2 | (30) | ||
| HDR_TERM_CANCEL_SOURCE | VARCHAR2 | (30) | ||
| NEGOTIATION_STATUS | VARCHAR2 | (30) | ||
| REMINDER | VARCHAR2 | (30) | ||
| SL_TERM_CANCEL_SOURCE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, AUTHORING_ORG_ID
, BUY_OR_SELL
, CHR_ID
, CLE_CREATION_DATE
, CLE_ID
, CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER
, COVERED_ITEM_ID
, COVERED_ITEM_ORG_ID
, CREATED_BY
, CREATION_DATE
, CREDIT_AMT
, CREDIT_AMT_F
, CREDIT_AMT_G
, CREDIT_AMT_SG
, CUSTOMER_PARTY_ID
, DATE_CANCELLED
, DATE_SIGNED
, DATE_TERMINATED
, EFFECTIVE_END_DATE
, EFFECTIVE_START_DATE
, END_DATE
, EXPECTED_CLOSE_DATE
, FUNC_GLOBAL_CURR_RATE
, FUNC_SGLOBAL_CURR_RATE
, GRACE_END_DATE
, HEND_DATE
, HSTART_DATE
, INV_ORGANIZATION_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OVERRIDE_AMT
, OVERRIDE_AMT_F
, OVERRIDE_AMT_G
, OVERRIDE_AMT_SG
, PRICE_NEGOTIATED
, PRICE_NEGOTIATED_F
, PRICE_NEGOTIATED_G
, PRICE_NEGOTIATED_SG
, PRIMARY_UOM_CODE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, QUANTITY
, RENEWAL_FLAG
, RENEWAL_TYPE
, RENEWED_FLAG
, REQUEST_ID
, RESOURCE_GROUP_ID
, RESOURCE_ID
, ROOT_LTY_CODE
, R_CHR_ID
, R_CLE_CREATION_DATE
, R_CLE_ID
, R_CONTRACT_NUMBER
, R_CONTRACT_NUMBER_MODIFIER
, R_COVERED_ITEM_ID
, R_COVERED_ITEM_ORG_ID
, R_CREDIT_AMT
, R_CREDIT_AMT_F
, R_CREDIT_AMT_G
, R_CREDIT_AMT_SG
, R_DATE_CANCELLED
, R_DATE_SIGNED
, R_DATE_TERMINATED
, R_EFFECTIVE_END_DATE
, R_EFFECTIVE_START_DATE
, R_END_DATE
, R_EXPECTED_CLOSE_DATE
, R_GRACE_END_DATE
, R_OVERRIDE_AMT
, R_OVERRIDE_AMT_F
, R_OVERRIDE_AMT_G
, R_OVERRIDE_AMT_SG
, R_PRICE_NEGOTIATED
, R_PRICE_NEGOTIATED_F
, R_PRICE_NEGOTIATED_G
, R_PRICE_NEGOTIATED_SG
, R_RENEWAL_FLAG
, R_RESOURCE_GROUP_ID
, R_RESOURCE_ID
, R_SALESREP_ID
, R_SCS_CODE
, R_SERVICE_ITEM_ID
, R_START_DATE
, R_STS_CODE
, R_SUPP_CREDIT
, R_SUPP_CREDIT_F
, R_SUPP_CREDIT_G
, R_SUPP_CREDIT_SG
, R_TERM_FLAG
, R_TRN_CODE
, R_UBT_AMT
, R_UBT_AMT_F
, R_UBT_AMT_G
, R_UBT_AMT_SG
, R_WIN_PERCENT
, SALESREP_ID
, SCS_CODE
, SECURITY_GROUP_ID
, SERVICE_ITEM_ID
, SLE_ID
, START_DATE
, STS_CODE
, SUPP_CREDIT
, SUPP_CREDIT_F
, SUPP_CREDIT_G
, SUPP_CREDIT_SG
, TERM_FLAG
, TRN_CODE
, TRX_FUNC_CURR_RATE
, TRX_MST_UOM_CONV_RATE
, UBT_AMT
, UBT_AMT_F
, UBT_AMT_G
, UBT_AMT_SG
, UOM_CODE
, WIN_PERCENT
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
, ANNUALIZATION_FACTOR
, CL_LAST_UPDATE_DATE
, COV_PROD_ID
, COV_PROD_SYSTEM_ID
, CREDIT_AMT_A
, CURR_CODE
, CURR_CODE_F
, DURATION_QTY
, DURATION_UOM
, EFFECTIVE_ACTIVE_DATE
, EFFECTIVE_EXPIRE_DATE
, EFFECTIVE_TERM_DATE
, FALSERNWLYN
, GSD_FLAG
, HDR_ACCT_RULE_ID
, HDR_BILL_SITE_ID
, HDR_CREATION_DATE
, HDR_DATE_APPROVED
, HDR_DATE_CANCELLED
, HDR_DATE_SIGNED
, HDR_DATE_TERMINATED
, HDR_GRACE_END_DATE
, HDR_LAST_UPDATE_DATE
, HDR_ORDER_NUMBER
, HDR_RENEWAL_TYPE
, HDR_SHIP_SITE_ID
, HDR_STS_CODE
, HDR_TRN_CODE
, LINE_NUMBER
, LINE_TYPE
, LIST_PRICE
, LIST_PRICE_F
, LIST_PRICE_G
, LIST_PRICE_SG
, ORDER_NUMBER
, OVERRIDE_AMT_A
, PRICE_NEGOTIATED_A
, P_CHR_ID
, P_CLE_ID
, P_CREDIT_AMT
, P_CREDIT_AMT_A
, P_CREDIT_AMT_F
, P_CREDIT_AMT_G
, P_CREDIT_AMT_SG
, P_END_DATE
, P_GRACE_END_DATE
, P_OVERRIDE_AMT
, P_OVERRIDE_AMT_A
, P_OVERRIDE_AMT_F
, P_OVERRIDE_AMT_G
, P_OVERRIDE_AMT_SG
, P_PRICE_NEGOTIATED
, P_PRICE_NEGOTIATED_A
, P_PRICE_NEGOTIATED_F
, P_PRICE_NEGOTIATED_G
, P_PRICE_NEGOTIATED_SG
, P_SUPP_CREDIT
, P_SUPP_CREDIT_A
, P_SUPP_CREDIT_F
, P_SUPP_CREDIT_G
, P_SUPP_CREDIT_SG
, P_TERM_FLAG
, P_UBT_AMT
, P_UBT_AMT_A
, P_UBT_AMT_F
, P_UBT_AMT_G
, P_UBT_AMT_SG
, SERVICE_ITEM_ORG_ID
, SL_CREATION_DATE
, SL_DATE_CANCELLED
, SL_DATE_TERMINATED
, SL_END_DATE
, SL_LAST_UPDATE_DATE
, SL_LINE_NUMBER
, SL_RENEWAL_TYPE
, SL_START_DATE
, SL_STS_CODE
, SL_TRN_CODE
, SUPP_CREDIT_A
, TERMINATION_ENTRY_DATE
, UBT_AMT_A
, UNIT_PRICE
, UNIT_PRICE_F
, UNIT_PRICE_G
, UNIT_PRICE_PERCENT
, UNIT_PRICE_SG
, HDR_SUBSEQUENT_RENEWAL_TYPE
, HDR_TERM_CANCEL_SOURCE
, NEGOTIATION_STATUS
, REMINDER
, SL_TERM_CANCEL_SOURCE
FROM OKI.MLOG$_OKI_DBI_CLE_B;
OKI.MLOG$_OKI_DBI_CLE_B does not reference any database object
OKI.MLOG$_OKI_DBI_CLE_B is referenced by following:
APPS
MLOG$_OKI_DBI_CLE_B
|
|
|
|