eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ISC.MLOG$_ISC_DBI_BSA_ORDER_LI

Object Details

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

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length
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)

Query Text

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;

Dependencies

[top of page]

ISC.MLOG$_ISC_DBI_BSA_ORDER_LI does not reference any database object

ISC.MLOG$_ISC_DBI_BSA_ORDER_LI is referenced by following:

APPS: MLOG$_ISC_DBI_BSA_ORDER_LI