APPS.WF_INSTALL dependencies on USER_TABLES

Line 35: FROM USER_TABLES

31: SELECT TABLESPACE_NAME, INITIAL_EXTENT, NEXT_EXTENT,
32: PCT_INCREASE,PARTITIONED
33: INTO v_tablespace_name, v_initial, v_next,
34: v_pctinc, v_partitioned
35: FROM USER_TABLES
36: WHERE TABLE_NAME = tblname;
37:
38: -- initial extent could be much larger than next extent
39: -- if it is greater than 10M, we made next extent at least 10M

Line 57: USER_TABLES UT

53: NVL(to_char(UT.PCT_INCREASE),UPT.DEF_PCT_INCREASE),
54: UT.PARTITIONED
55: INTO v_tablespace_name, v_initial, v_next, v_pctinc, v_partitioned
56: FROM USER_PART_TABLES UPT,
57: USER_TABLES UT
58: WHERE UT.TABLE_NAME = tblname
59: AND UPT.TABLE_NAME(+) = UT.TABLE_NAME;
60:
61: -- In a partitioned table, next extent is much bigger, so we use that

Line 506: FROM USER_INDEXES I, USER_TABLES T

502: SELECT I.TABLESPACE_NAME, I.INITIAL_EXTENT, I.NEXT_EXTENT, I.PCT_INCREASE,
503: I.PARTITIONED, T.PARTITIONED
504: INTO v_tablespace_name, v_initial, v_next, v_pctinc,
505: v_idxpartitioned, v_tblpartitioned
506: FROM USER_INDEXES I, USER_TABLES T
507: WHERE I.INDEX_NAME = idxname
508: AND I.TABLE_NAME = T.TABLE_NAME;
509:
510: -- initial extent could be much larger than next extent

Line 529: FROM USER_INDEXES I, USER_TABLES T, USER_PART_INDEXES UPI

525: NVL(to_char(I.PCT_INCREASE),UPI.DEF_PCT_INCREASE),
526: I.PARTITIONED, T.PARTITIONED
527: INTO v_tablespace_name, v_initial, v_next, v_pctinc,
528: v_idxpartitioned, v_tblpartitioned
529: FROM USER_INDEXES I, USER_TABLES T, USER_PART_INDEXES UPI
530: WHERE I.INDEX_NAME = idxname
531: AND I.TABLE_NAME = T.TABLE_NAME
532: AND UPI.INDEX_NAME(+) = I.INDEX_NAME;
533: