[Home] [Help] [Dependency Information]
Object Name: | MLOG$_OKI_SRM_002_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
snapshot log for master table APPS.OKI_SRM_002_MV
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 60 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUTHORING_ORG_ID | NUMBER | |||
CLASS_CODE | VARCHAR2 | (30) | ||
CLE_CREATION_DATE | DATE | |||
CUSTOMER_PARTY_ID | NUMBER | |||
DATE_CANCELLED | DATE | |||
DATE_SIGNED | DATE | |||
DATE_TERMINATED | DATE | |||
EFFECTIVE_END_DATE | DATE | |||
EFFECTIVE_EXPIRE_DATE | DATE | |||
EFFECTIVE_START_DATE | DATE | |||
EFFECTIVE_TERM_DATE | DATE | |||
EXPECTED_CLOSE_DATE | DATE | |||
EXP_RENEWAL_FLAG | NUMBER | |||
PRG_ID | NUMBER | |||
PRICE_NEGOTIATED_A | NUMBER | |||
PRICE_NEGOTIATED_F | NUMBER | |||
PRICE_NEGOTIATED_G | NUMBER | |||
PRICE_NEGOTIATED_SG | NUMBER | |||
P_GRACE_END_DATE | DATE | |||
P_PRICE_NEGOTIATED_A | NUMBER | |||
P_PRICE_NEGOTIATED_F | NUMBER | |||
P_PRICE_NEGOTIATED_G | NUMBER | |||
P_PRICE_NEGOTIATED_SG | NUMBER | |||
P_TERM_FLAG | NUMBER | |||
RENEWAL_FLAG | NUMBER | |||
RESOURCE_ID | NUMBER | |||
RG_ID | NUMBER | |||
SERVICE_ITEM_CATEGORY_ID | NUMBER | |||
SERVICE_ITEM_ORG_ID | VARCHAR2 | (81) | ||
START_DATE | DATE | |||
STS_CODE | VARCHAR2 | (30) | ||
TRN_BILLED_VALUE_A | NUMBER | |||
TRN_BILLED_VALUE_F | NUMBER | |||
TRN_BILLED_VALUE_G | NUMBER | |||
TRN_BILLED_VALUE_SG | NUMBER | |||
TRN_CODE | VARCHAR2 | (30) | ||
UMARKER | VARCHAR2 | (9) | ||
WIN_PERCENT | NUMBER | |||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) |
Cut, paste (and edit) the following text to query this object:
SELECT AUTHORING_ORG_ID
, CLASS_CODE
, CLE_CREATION_DATE
, CUSTOMER_PARTY_ID
, DATE_CANCELLED
, DATE_SIGNED
, DATE_TERMINATED
, EFFECTIVE_END_DATE
, EFFECTIVE_EXPIRE_DATE
, EFFECTIVE_START_DATE
, EFFECTIVE_TERM_DATE
, EXPECTED_CLOSE_DATE
, EXP_RENEWAL_FLAG
, PRG_ID
, PRICE_NEGOTIATED_A
, PRICE_NEGOTIATED_F
, PRICE_NEGOTIATED_G
, PRICE_NEGOTIATED_SG
, P_GRACE_END_DATE
, P_PRICE_NEGOTIATED_A
, P_PRICE_NEGOTIATED_F
, P_PRICE_NEGOTIATED_G
, P_PRICE_NEGOTIATED_SG
, P_TERM_FLAG
, RENEWAL_FLAG
, RESOURCE_ID
, RG_ID
, SERVICE_ITEM_CATEGORY_ID
, SERVICE_ITEM_ORG_ID
, START_DATE
, STS_CODE
, TRN_BILLED_VALUE_A
, TRN_BILLED_VALUE_F
, TRN_BILLED_VALUE_G
, TRN_BILLED_VALUE_SG
, TRN_CODE
, UMARKER
, WIN_PERCENT
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
FROM APPS.MLOG$_OKI_SRM_002_MV;
APPS.MLOG$_OKI_SRM_002_MV does not reference any database object
APPS.MLOG$_OKI_SRM_002_MV is not referenced by any database object
|
|
|