[Home] [Help] [Dependency Information]
Object Name: | MLOG$_ISC_DBI_BSA_ORDER_LI |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
snapshot log for master table ISC.ISC_DBI_BSA_ORDER_LINES_F
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGREEMENT_TYPE_ID | NUMBER | |||
BLANKET_HEADER_ID | NUMBER | |||
BLANKET_LINE_ID | NUMBER | |||
BLANKET_LINE_MIN_AMT | NUMBER | |||
BLANKET_LINE_NUMBER | NUMBER | |||
BLANKET_MIN_AMT | NUMBER | |||
BLANKET_NUMBER | NUMBER | |||
COMMIT_PRORATED_AMT_G | NUMBER | |||
COMMIT_PRORATED_AMT_G1 | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
FULFILLED_AMT_G | NUMBER | |||
FULFILLED_AMT_G1 | NUMBER | |||
FULFILLED_OUTSTAND_AMT_G | NUMBER | |||
FULFILLED_OUTSTAND_AMT_G1 | NUMBER | |||
H_CNT | NUMBER | |||
H_END_DATE_ACTIVE | DATE | |||
H_START_DATE_ACTIVE | DATE | |||
INVENTORY_ITEM_ID | NUMBER | |||
ITEM_INV_ORG_ID | NUMBER | |||
LINE_NUMBER | VARCHAR2 | (240) | ||
L_CNT | NUMBER | |||
L_END_DATE_ACTIVE | DATE | |||
L_START_DATE_ACTIVE | DATE | |||
ORDER_LINE_ID | NUMBER | |||
ORDER_NUMBER | NUMBER | |||
ORG_ID | NUMBER | |||
SALESREP_ID | NUMBER | |||
SALES_GRP_ID | NUMBER | |||
SOLD_TO_ORG_ID | NUMBER | |||
TERMINATION_DATE | DATE | |||
TIME_ACTIVATION_DATE_ID | DATE | |||
TIME_EFFECTIVE_END_DATE_ID | DATE | |||
TIME_EXPIRATION_DATE_ID | DATE | |||
TIME_FULFILLED_DATE_ID | DATE | |||
TIME_TERMINATION_DATE_ID | DATE | |||
TRANSACTION_PHASE_CODE | VARCHAR2 | (80) | ||
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 AGREEMENT_TYPE_ID
, BLANKET_HEADER_ID
, BLANKET_LINE_ID
, BLANKET_LINE_MIN_AMT
, BLANKET_LINE_NUMBER
, BLANKET_MIN_AMT
, BLANKET_NUMBER
, COMMIT_PRORATED_AMT_G
, COMMIT_PRORATED_AMT_G1
, CUSTOMER_ID
, FULFILLED_AMT_G
, FULFILLED_AMT_G1
, FULFILLED_OUTSTAND_AMT_G
, FULFILLED_OUTSTAND_AMT_G1
, H_CNT
, H_END_DATE_ACTIVE
, H_START_DATE_ACTIVE
, INVENTORY_ITEM_ID
, ITEM_INV_ORG_ID
, LINE_NUMBER
, L_CNT
, L_END_DATE_ACTIVE
, L_START_DATE_ACTIVE
, ORDER_LINE_ID
, ORDER_NUMBER
, ORG_ID
, SALESREP_ID
, SALES_GRP_ID
, SOLD_TO_ORG_ID
, TERMINATION_DATE
, TIME_ACTIVATION_DATE_ID
, TIME_EFFECTIVE_END_DATE_ID
, TIME_EXPIRATION_DATE_ID
, TIME_FULFILLED_DATE_ID
, TIME_TERMINATION_DATE_ID
, TRANSACTION_PHASE_CODE
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
FROM ISC.MLOG$_ISC_DBI_BSA_ORDER_LI;
ISC.MLOG$_ISC_DBI_BSA_ORDER_LI does not reference any database object
ISC.MLOG$_ISC_DBI_BSA_ORDER_LI is referenced by following:
|
|
|