|
|
| Legend: |
| Primary key columns |
| Columns with indexes |
| Implied relationships |
| Excluded column relationships |
| < n > number of related tables |
|
|
| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ITEM_ID |
number |
22 |
|
|
|
|
| ITEM.ITEM_ID
|
Implied Constraint R |
|
| ITEM_NO |
varchar2 |
32 |
|
|
|
|
|
| PROC_ITEM_NO |
varchar2 |
32 |
√ |
|
null |
|
|
| ITEM_GROUP |
varchar2 |
5 |
√ |
|
null |
|
|
| DESCR |
varchar2 |
100 |
√ |
|
null |
|
|
| PROC_DESCR |
varchar2 |
100 |
√ |
|
null |
|
|
| MFR_CAT_NO |
varchar2 |
35 |
√ |
|
null |
|
|
| MFR_ID |
number |
22 |
√ |
|
null |
|
| MFGR.MFR_ID
|
Implied Constraint R |
|
| MAJOR_CLASS |
varchar2 |
4 |
√ |
|
null |
|
|
| MINOR_CLASS |
varchar2 |
4 |
√ |
|
null |
|
|
| USAGE_IDENTIFIER |
varchar2 |
1 |
√ |
|
null |
|
|
| IMGLNK |
varchar2 |
255 |
√ |
|
null |
|
|
| STATUS |
char |
1 |
|
|
|
|
|
| CREATION_DT |
date |
7 |
|
|
|
|
|
| LAST_MODIFIED_DT |
date |
7 |
|
|
|
|
|
Analyzed at Wed May 18 12:10 CDT 2011
|
View Definition:
SELECT IL.ITEM_ID, IL.ITEM_NO,IP.ITEM_NO, IL.ITEM_GROUP, DECODE( IL.DESCR, null, IP.DESCR, IL.DESCR ), IP.DESCR, IL.MFR_CAT_NO, IL.MFR_ID, IP.MAJOR_CLASS, IP.MINOR_CLASS, IP.USAGE_IDENTIFIER, DECODE( IL.IMGLNK, null, IP.IMGLNK, IL.IMGLNK), IL.STATUS, IL.CREATION_DT,IL.LAST_MODIFIED_DT FROM ITEM IL, ITEM IP WHERE IL.EXT_DATA_IND = '0' AND IL.PROCUREMENT_ITEM_ID = IP.ITEM_ID(+)
Possibly Referenced Tables/Views:
