APPS.FA_MC_UPG1_PKG dependencies on AD_DDL

Line 57: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

53: fa_debug_pkg.add('create_drop_indexes','mode',
54: 'Dropping');
55: end if;
56:
57: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
58: ad_ddl.drop_index,
59: 'drop index FA_MC_ADJUSTMENTS_N1','INDEX');
60:
61: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 58: ad_ddl.drop_index,

54: 'Dropping');
55: end if;
56:
57: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
58: ad_ddl.drop_index,
59: 'drop index FA_MC_ADJUSTMENTS_N1','INDEX');
60:
61: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
62: ad_ddl.drop_index,

Line 61: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

57: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
58: ad_ddl.drop_index,
59: 'drop index FA_MC_ADJUSTMENTS_N1','INDEX');
60:
61: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
62: ad_ddl.drop_index,
63: 'drop index FA_MC_ADJUSTMENTS_N2','INDEX');
64:
65: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 62: ad_ddl.drop_index,

58: ad_ddl.drop_index,
59: 'drop index FA_MC_ADJUSTMENTS_N1','INDEX');
60:
61: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
62: ad_ddl.drop_index,
63: 'drop index FA_MC_ADJUSTMENTS_N2','INDEX');
64:
65: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
66: ad_ddl.drop_index,

Line 65: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

61: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
62: ad_ddl.drop_index,
63: 'drop index FA_MC_ADJUSTMENTS_N2','INDEX');
64:
65: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
66: ad_ddl.drop_index,
67: 'drop index FA_MC_ADJUSTMENTS_N3','INDEX');
68:
69: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 66: ad_ddl.drop_index,

62: ad_ddl.drop_index,
63: 'drop index FA_MC_ADJUSTMENTS_N2','INDEX');
64:
65: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
66: ad_ddl.drop_index,
67: 'drop index FA_MC_ADJUSTMENTS_N3','INDEX');
68:
69: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
70: ad_ddl.drop_index,

Line 69: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

65: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
66: ad_ddl.drop_index,
67: 'drop index FA_MC_ADJUSTMENTS_N3','INDEX');
68:
69: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
70: ad_ddl.drop_index,
71: 'drop index FA_MC_ADJUSTMENTS_N4','INDEX');
72:
73: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 70: ad_ddl.drop_index,

66: ad_ddl.drop_index,
67: 'drop index FA_MC_ADJUSTMENTS_N3','INDEX');
68:
69: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
70: ad_ddl.drop_index,
71: 'drop index FA_MC_ADJUSTMENTS_N4','INDEX');
72:
73: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
74: ad_ddl.drop_index,

Line 73: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

69: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
70: ad_ddl.drop_index,
71: 'drop index FA_MC_ADJUSTMENTS_N4','INDEX');
72:
73: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
74: ad_ddl.drop_index,
75: 'drop index FA_MC_ASSET_INVOICES_N1','INDEX');
76:
77: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 74: ad_ddl.drop_index,

70: ad_ddl.drop_index,
71: 'drop index FA_MC_ADJUSTMENTS_N4','INDEX');
72:
73: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
74: ad_ddl.drop_index,
75: 'drop index FA_MC_ASSET_INVOICES_N1','INDEX');
76:
77: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
78: ad_ddl.drop_index,

Line 77: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

73: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
74: ad_ddl.drop_index,
75: 'drop index FA_MC_ASSET_INVOICES_N1','INDEX');
76:
77: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
78: ad_ddl.drop_index,
79: 'drop index FA_MC_BOOKS_U1','INDEX');
80:
81: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 78: ad_ddl.drop_index,

74: ad_ddl.drop_index,
75: 'drop index FA_MC_ASSET_INVOICES_N1','INDEX');
76:
77: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
78: ad_ddl.drop_index,
79: 'drop index FA_MC_BOOKS_U1','INDEX');
80:
81: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
82: ad_ddl.drop_index,

Line 81: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

77: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
78: ad_ddl.drop_index,
79: 'drop index FA_MC_BOOKS_U1','INDEX');
80:
81: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
82: ad_ddl.drop_index,
83: 'drop index FA_MC_BOOKS_RATES_N1','INDEX');
84:
85: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 82: ad_ddl.drop_index,

78: ad_ddl.drop_index,
79: 'drop index FA_MC_BOOKS_U1','INDEX');
80:
81: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
82: ad_ddl.drop_index,
83: 'drop index FA_MC_BOOKS_RATES_N1','INDEX');
84:
85: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
86: ad_ddl.drop_index,

Line 85: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

81: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
82: ad_ddl.drop_index,
83: 'drop index FA_MC_BOOKS_RATES_N1','INDEX');
84:
85: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
86: ad_ddl.drop_index,
87: 'drop index FA_MC_BOOKS_RATES_U1','INDEX');
88:
89: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 86: ad_ddl.drop_index,

82: ad_ddl.drop_index,
83: 'drop index FA_MC_BOOKS_RATES_N1','INDEX');
84:
85: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
86: ad_ddl.drop_index,
87: 'drop index FA_MC_BOOKS_RATES_U1','INDEX');
88:
89: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
90: ad_ddl.drop_index,

Line 89: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

85: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
86: ad_ddl.drop_index,
87: 'drop index FA_MC_BOOKS_RATES_U1','INDEX');
88:
89: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
90: ad_ddl.drop_index,
91: 'drop index FA_MC_BOOK_CONTROLS_U1','INDEX');
92:
93: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 90: ad_ddl.drop_index,

86: ad_ddl.drop_index,
87: 'drop index FA_MC_BOOKS_RATES_U1','INDEX');
88:
89: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
90: ad_ddl.drop_index,
91: 'drop index FA_MC_BOOK_CONTROLS_U1','INDEX');
92:
93: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
94: ad_ddl.drop_index,

Line 93: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

89: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
90: ad_ddl.drop_index,
91: 'drop index FA_MC_BOOK_CONTROLS_U1','INDEX');
92:
93: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
94: ad_ddl.drop_index,
95: 'drop index FA_MC_DEFERRED_DEPRN_N1','INDEX');
96:
97: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 94: ad_ddl.drop_index,

90: ad_ddl.drop_index,
91: 'drop index FA_MC_BOOK_CONTROLS_U1','INDEX');
92:
93: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
94: ad_ddl.drop_index,
95: 'drop index FA_MC_DEFERRED_DEPRN_N1','INDEX');
96:
97: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
98: ad_ddl.drop_index,

Line 97: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

93: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
94: ad_ddl.drop_index,
95: 'drop index FA_MC_DEFERRED_DEPRN_N1','INDEX');
96:
97: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
98: ad_ddl.drop_index,
99: 'drop index FA_MC_DEFERRED_DEPRN_N2','INDEX');
100:
101: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 98: ad_ddl.drop_index,

94: ad_ddl.drop_index,
95: 'drop index FA_MC_DEFERRED_DEPRN_N1','INDEX');
96:
97: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
98: ad_ddl.drop_index,
99: 'drop index FA_MC_DEFERRED_DEPRN_N2','INDEX');
100:
101: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
102: ad_ddl.drop_index,

Line 101: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

97: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
98: ad_ddl.drop_index,
99: 'drop index FA_MC_DEFERRED_DEPRN_N2','INDEX');
100:
101: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
102: ad_ddl.drop_index,
103: 'drop index FA_MC_DEFERRED_DEPRN_N3','INDEX');
104:
105: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 102: ad_ddl.drop_index,

98: ad_ddl.drop_index,
99: 'drop index FA_MC_DEFERRED_DEPRN_N2','INDEX');
100:
101: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
102: ad_ddl.drop_index,
103: 'drop index FA_MC_DEFERRED_DEPRN_N3','INDEX');
104:
105: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
106: ad_ddl.drop_index,

Line 105: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

101: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
102: ad_ddl.drop_index,
103: 'drop index FA_MC_DEFERRED_DEPRN_N3','INDEX');
104:
105: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
106: ad_ddl.drop_index,
107: 'drop index FA_MC_DEFERRED_DEPRN_N4','INDEX');
108:
109: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 106: ad_ddl.drop_index,

102: ad_ddl.drop_index,
103: 'drop index FA_MC_DEFERRED_DEPRN_N3','INDEX');
104:
105: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
106: ad_ddl.drop_index,
107: 'drop index FA_MC_DEFERRED_DEPRN_N4','INDEX');
108:
109: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
110: ad_ddl.drop_index,

Line 109: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

105: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
106: ad_ddl.drop_index,
107: 'drop index FA_MC_DEFERRED_DEPRN_N4','INDEX');
108:
109: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
110: ad_ddl.drop_index,
111: 'drop index FA_MC_DEPRN_DETAIL_N1','INDEX');
112:
113: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 110: ad_ddl.drop_index,

106: ad_ddl.drop_index,
107: 'drop index FA_MC_DEFERRED_DEPRN_N4','INDEX');
108:
109: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
110: ad_ddl.drop_index,
111: 'drop index FA_MC_DEPRN_DETAIL_N1','INDEX');
112:
113: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
114: ad_ddl.drop_index,

Line 113: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

109: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
110: ad_ddl.drop_index,
111: 'drop index FA_MC_DEPRN_DETAIL_N1','INDEX');
112:
113: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
114: ad_ddl.drop_index,
115: 'drop index FA_MC_DEPRN_DETAIL_N2','INDEX');
116:
117: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 114: ad_ddl.drop_index,

110: ad_ddl.drop_index,
111: 'drop index FA_MC_DEPRN_DETAIL_N1','INDEX');
112:
113: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
114: ad_ddl.drop_index,
115: 'drop index FA_MC_DEPRN_DETAIL_N2','INDEX');
116:
117: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
118: ad_ddl.drop_index,

Line 117: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

113: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
114: ad_ddl.drop_index,
115: 'drop index FA_MC_DEPRN_DETAIL_N2','INDEX');
116:
117: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
118: ad_ddl.drop_index,
119: 'drop index FA_MC_DEPRN_DETAIL_U1','INDEX');
120:
121: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 118: ad_ddl.drop_index,

114: ad_ddl.drop_index,
115: 'drop index FA_MC_DEPRN_DETAIL_N2','INDEX');
116:
117: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
118: ad_ddl.drop_index,
119: 'drop index FA_MC_DEPRN_DETAIL_U1','INDEX');
120:
121: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
122: ad_ddl.drop_index,

Line 121: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

117: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
118: ad_ddl.drop_index,
119: 'drop index FA_MC_DEPRN_DETAIL_U1','INDEX');
120:
121: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
122: ad_ddl.drop_index,
123: 'drop index FA_MC_DEPRN_PERIODS_U1','INDEX');
124:
125: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 122: ad_ddl.drop_index,

118: ad_ddl.drop_index,
119: 'drop index FA_MC_DEPRN_DETAIL_U1','INDEX');
120:
121: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
122: ad_ddl.drop_index,
123: 'drop index FA_MC_DEPRN_PERIODS_U1','INDEX');
124:
125: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
126: ad_ddl.drop_index,

Line 125: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

121: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
122: ad_ddl.drop_index,
123: 'drop index FA_MC_DEPRN_PERIODS_U1','INDEX');
124:
125: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
126: ad_ddl.drop_index,
127: 'drop index FA_MC_DEPRN_PERIODS_U2','INDEX');
128:
129: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 126: ad_ddl.drop_index,

122: ad_ddl.drop_index,
123: 'drop index FA_MC_DEPRN_PERIODS_U1','INDEX');
124:
125: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
126: ad_ddl.drop_index,
127: 'drop index FA_MC_DEPRN_PERIODS_U2','INDEX');
128:
129: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
130: ad_ddl.drop_index,

Line 129: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

125: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
126: ad_ddl.drop_index,
127: 'drop index FA_MC_DEPRN_PERIODS_U2','INDEX');
128:
129: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
130: ad_ddl.drop_index,
131: 'drop index FA_MC_DEPRN_PERIODS_U3','INDEX');
132:
133: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 130: ad_ddl.drop_index,

126: ad_ddl.drop_index,
127: 'drop index FA_MC_DEPRN_PERIODS_U2','INDEX');
128:
129: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
130: ad_ddl.drop_index,
131: 'drop index FA_MC_DEPRN_PERIODS_U3','INDEX');
132:
133: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
134: ad_ddl.drop_index,

Line 133: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

129: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
130: ad_ddl.drop_index,
131: 'drop index FA_MC_DEPRN_PERIODS_U3','INDEX');
132:
133: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
134: ad_ddl.drop_index,
135: 'drop index FA_MC_DEPRN_SUMMARY_N1','INDEX');
136:
137: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 134: ad_ddl.drop_index,

130: ad_ddl.drop_index,
131: 'drop index FA_MC_DEPRN_PERIODS_U3','INDEX');
132:
133: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
134: ad_ddl.drop_index,
135: 'drop index FA_MC_DEPRN_SUMMARY_N1','INDEX');
136:
137: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
138: ad_ddl.drop_index,

Line 137: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

133: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
134: ad_ddl.drop_index,
135: 'drop index FA_MC_DEPRN_SUMMARY_N1','INDEX');
136:
137: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
138: ad_ddl.drop_index,
139: 'drop index FA_MC_DEPRN_SUMMARY_U1','INDEX');
140:
141: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 138: ad_ddl.drop_index,

134: ad_ddl.drop_index,
135: 'drop index FA_MC_DEPRN_SUMMARY_N1','INDEX');
136:
137: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
138: ad_ddl.drop_index,
139: 'drop index FA_MC_DEPRN_SUMMARY_U1','INDEX');
140:
141: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
142: ad_ddl.drop_index,

Line 141: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

137: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
138: ad_ddl.drop_index,
139: 'drop index FA_MC_DEPRN_SUMMARY_U1','INDEX');
140:
141: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
142: ad_ddl.drop_index,
143: 'drop index FA_MC_RETIREMENTS_U1','INDEX');
144:
145: ELSIF (p_mode = 'C') then

Line 142: ad_ddl.drop_index,

138: ad_ddl.drop_index,
139: 'drop index FA_MC_DEPRN_SUMMARY_U1','INDEX');
140:
141: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
142: ad_ddl.drop_index,
143: 'drop index FA_MC_RETIREMENTS_U1','INDEX');
144:
145: ELSIF (p_mode = 'C') then
146: -- create all the indexes

Line 153: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

149: fa_debug_pkg.add('create_drop_indexes','mode',
150: 'Creating');
151: end if;
152:
153: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
154: ad_ddl.create_index,
155: 'create index FA_MC_ADJUSTMENTS_N1 ON
156: FA_MC_ADJUSTMENTS(
157: DISTRIBUTION_ID,

Line 154: ad_ddl.create_index,

150: 'Creating');
151: end if;
152:
153: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
154: ad_ddl.create_index,
155: 'create index FA_MC_ADJUSTMENTS_N1 ON
156: FA_MC_ADJUSTMENTS(
157: DISTRIBUTION_ID,
158: BOOK_TYPE_CODE,

Line 164: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

160: SOURCE_TYPE_CODE,
161: ADJUSTMENT_TYPE,
162: SET_OF_BOOKS_ID)', 'INDEX');
163:
164: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
165: ad_ddl.create_index,
166: 'create index FA_MC_ADJUSTMENTS_N2 ON
167: FA_MC_ADJUSTMENTS(
168: ASSET_ID,

Line 165: ad_ddl.create_index,

161: ADJUSTMENT_TYPE,
162: SET_OF_BOOKS_ID)', 'INDEX');
163:
164: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
165: ad_ddl.create_index,
166: 'create index FA_MC_ADJUSTMENTS_N2 ON
167: FA_MC_ADJUSTMENTS(
168: ASSET_ID,
169: BOOK_TYPE_CODE,

Line 173: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

169: BOOK_TYPE_CODE,
170: PERIOD_COUNTER_CREATED,
171: SET_OF_BOOKS_ID)', 'INDEX');
172:
173: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
174: ad_ddl.create_index,
175: 'create index FA_MC_ADJUSTMENTS_N3 ON
176: FA_MC_ADJUSTMENTS(
177: JE_HEADER_ID,

Line 174: ad_ddl.create_index,

170: PERIOD_COUNTER_CREATED,
171: SET_OF_BOOKS_ID)', 'INDEX');
172:
173: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
174: ad_ddl.create_index,
175: 'create index FA_MC_ADJUSTMENTS_N3 ON
176: FA_MC_ADJUSTMENTS(
177: JE_HEADER_ID,
178: JE_LINE_NUM,

Line 181: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

177: JE_HEADER_ID,
178: JE_LINE_NUM,
179: SET_OF_BOOKS_ID)', 'INDEX');
180:
181: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
182: ad_ddl.create_index,
183: 'create index FA_MC_ADJUSTMENTS_N4 ON
184: FA_MC_ADJUSTMENTS(
185: BOOK_TYPE_CODE,

Line 182: ad_ddl.create_index,

178: JE_LINE_NUM,
179: SET_OF_BOOKS_ID)', 'INDEX');
180:
181: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
182: ad_ddl.create_index,
183: 'create index FA_MC_ADJUSTMENTS_N4 ON
184: FA_MC_ADJUSTMENTS(
185: BOOK_TYPE_CODE,
186: PERIOD_COUNTER_CREATED,

Line 190: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

186: PERIOD_COUNTER_CREATED,
187: SET_OF_BOOKS_ID)', 'INDEX');
188:
189:
190: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
191: ad_ddl.create_index,
192: 'create index FA_MC_ASSET_INVOICES_N1 ON
193: FA_MC_ASSET_INVOICES(
194: ASSET_ID,

Line 191: ad_ddl.create_index,

187: SET_OF_BOOKS_ID)', 'INDEX');
188:
189:
190: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
191: ad_ddl.create_index,
192: 'create index FA_MC_ASSET_INVOICES_N1 ON
193: FA_MC_ASSET_INVOICES(
194: ASSET_ID,
195: ASSET_INVOICE_ID,

Line 198: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

194: ASSET_ID,
195: ASSET_INVOICE_ID,
196: SET_OF_BOOKS_ID)', 'INDEX');
197:
198: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
199: ad_ddl.create_index,
200: 'create unique index FA_MC_BOOKS_U1 ON
201: FA_MC_BOOKS(
202: TRANSACTION_HEADER_ID_IN,

Line 199: ad_ddl.create_index,

195: ASSET_INVOICE_ID,
196: SET_OF_BOOKS_ID)', 'INDEX');
197:
198: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
199: ad_ddl.create_index,
200: 'create unique index FA_MC_BOOKS_U1 ON
201: FA_MC_BOOKS(
202: TRANSACTION_HEADER_ID_IN,
203: SET_OF_BOOKS_ID)', 'INDEX');

Line 206: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

202: TRANSACTION_HEADER_ID_IN,
203: SET_OF_BOOKS_ID)', 'INDEX');
204:
205:
206: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
207: ad_ddl.create_index,
208: 'create index FA_MC_BOOKS_RATES_N1 ON
209: FA_MC_BOOKS_RATES(
210: SET_OF_BOOKS_ID,

Line 207: ad_ddl.create_index,

203: SET_OF_BOOKS_ID)', 'INDEX');
204:
205:
206: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
207: ad_ddl.create_index,
208: 'create index FA_MC_BOOKS_RATES_N1 ON
209: FA_MC_BOOKS_RATES(
210: SET_OF_BOOKS_ID,
211: TRANSACTION_HEADER_ID)', 'INDEX');

Line 213: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

209: FA_MC_BOOKS_RATES(
210: SET_OF_BOOKS_ID,
211: TRANSACTION_HEADER_ID)', 'INDEX');
212:
213: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
214: ad_ddl.create_index,
215: 'create unique index FA_MC_BOOKS_RATES_U1 ON
216: FA_MC_BOOKS_RATES(
217: SET_OF_BOOKS_ID,

Line 214: ad_ddl.create_index,

210: SET_OF_BOOKS_ID,
211: TRANSACTION_HEADER_ID)', 'INDEX');
212:
213: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
214: ad_ddl.create_index,
215: 'create unique index FA_MC_BOOKS_RATES_U1 ON
216: FA_MC_BOOKS_RATES(
217: SET_OF_BOOKS_ID,
218: TRANSACTION_HEADER_ID,

Line 221: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

217: SET_OF_BOOKS_ID,
218: TRANSACTION_HEADER_ID,
219: INVOICE_TRANSACTION_ID)', 'INDEX');
220:
221: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
222: ad_ddl.create_index,
223: 'create unique index FA_MC_BOOK_CONTROLS_U1 ON
224: FA_MC_BOOK_CONTROLS(
225: SET_OF_BOOKS_ID,

Line 222: ad_ddl.create_index,

218: TRANSACTION_HEADER_ID,
219: INVOICE_TRANSACTION_ID)', 'INDEX');
220:
221: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
222: ad_ddl.create_index,
223: 'create unique index FA_MC_BOOK_CONTROLS_U1 ON
224: FA_MC_BOOK_CONTROLS(
225: SET_OF_BOOKS_ID,
226: BOOK_TYPE_CODE)', 'INDEX');

Line 228: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

224: FA_MC_BOOK_CONTROLS(
225: SET_OF_BOOKS_ID,
226: BOOK_TYPE_CODE)', 'INDEX');
227:
228: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
229: ad_ddl.create_index,
230: 'create index FA_MC_DEFERRED_DEPRN_N1 ON
231: FA_MC_DEFERRED_DEPRN(
232: CORP_BOOK_TYPE_CODE,

Line 229: ad_ddl.create_index,

225: SET_OF_BOOKS_ID,
226: BOOK_TYPE_CODE)', 'INDEX');
227:
228: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
229: ad_ddl.create_index,
230: 'create index FA_MC_DEFERRED_DEPRN_N1 ON
231: FA_MC_DEFERRED_DEPRN(
232: CORP_BOOK_TYPE_CODE,
233: TAX_BOOK_TYPE_CODE,

Line 237: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

233: TAX_BOOK_TYPE_CODE,
234: EXPENSE_JE_LINE_NUM,
235: SET_OF_BOOKS_ID)', 'INDEX');
236:
237: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
238: ad_ddl.create_index,
239: 'create index FA_MC_DEFERRED_DEPRN_N2 ON
240: FA_MC_DEFERRED_DEPRN(
241: CORP_BOOK_TYPE_CODE,

Line 238: ad_ddl.create_index,

234: EXPENSE_JE_LINE_NUM,
235: SET_OF_BOOKS_ID)', 'INDEX');
236:
237: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
238: ad_ddl.create_index,
239: 'create index FA_MC_DEFERRED_DEPRN_N2 ON
240: FA_MC_DEFERRED_DEPRN(
241: CORP_BOOK_TYPE_CODE,
242: TAX_BOOK_TYPE_CODE,

Line 246: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

242: TAX_BOOK_TYPE_CODE,
243: RESERVE_JE_LINE_NUM,
244: SET_OF_BOOKS_ID)', 'INDEX');
245:
246: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
247: ad_ddl.create_index,
248: 'create index FA_MC_DEFERRED_DEPRN_N3 ON
249: FA_MC_DEFERRED_DEPRN(
250: JE_HEADER_ID,

Line 247: ad_ddl.create_index,

243: RESERVE_JE_LINE_NUM,
244: SET_OF_BOOKS_ID)', 'INDEX');
245:
246: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
247: ad_ddl.create_index,
248: 'create index FA_MC_DEFERRED_DEPRN_N3 ON
249: FA_MC_DEFERRED_DEPRN(
250: JE_HEADER_ID,
251: EXPENSE_JE_LINE_NUM,

Line 254: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

250: JE_HEADER_ID,
251: EXPENSE_JE_LINE_NUM,
252: SET_OF_BOOKS_ID)', 'INDEX');
253:
254: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
255: ad_ddl.create_index,
256: 'create index FA_MC_DEFERRED_DEPRN_N4 ON
257: FA_MC_DEFERRED_DEPRN(
258: JE_HEADER_ID,

Line 255: ad_ddl.create_index,

251: EXPENSE_JE_LINE_NUM,
252: SET_OF_BOOKS_ID)', 'INDEX');
253:
254: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
255: ad_ddl.create_index,
256: 'create index FA_MC_DEFERRED_DEPRN_N4 ON
257: FA_MC_DEFERRED_DEPRN(
258: JE_HEADER_ID,
259: RESERVE_JE_LINE_NUM,

Line 262: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

258: JE_HEADER_ID,
259: RESERVE_JE_LINE_NUM,
260: SET_OF_BOOKS_ID)', 'INDEX');
261:
262: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
263: ad_ddl.create_index,
264: 'create index FA_MC_DEPRN_DETAIL_N1 ON
265: FA_MC_DEPRN_DETAIL(
266: ASSET_ID,

Line 263: ad_ddl.create_index,

259: RESERVE_JE_LINE_NUM,
260: SET_OF_BOOKS_ID)', 'INDEX');
261:
262: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
263: ad_ddl.create_index,
264: 'create index FA_MC_DEPRN_DETAIL_N1 ON
265: FA_MC_DEPRN_DETAIL(
266: ASSET_ID,
267: BOOK_TYPE_CODE,

Line 271: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

267: BOOK_TYPE_CODE,
268: PERIOD_COUNTER,
269: SET_OF_BOOKS_ID)', 'INDEX');
270:
271: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
272: ad_ddl.create_index,
273: 'create index FA_MC_DEPRN_DETAIL_N2 ON
274: FA_MC_DEPRN_DETAIL(
275: BOOK_TYPE_CODE,

Line 272: ad_ddl.create_index,

268: PERIOD_COUNTER,
269: SET_OF_BOOKS_ID)', 'INDEX');
270:
271: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
272: ad_ddl.create_index,
273: 'create index FA_MC_DEPRN_DETAIL_N2 ON
274: FA_MC_DEPRN_DETAIL(
275: BOOK_TYPE_CODE,
276: PERIOD_COUNTER,

Line 279: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

275: BOOK_TYPE_CODE,
276: PERIOD_COUNTER,
277: SET_OF_BOOKS_ID)', 'INDEX');
278:
279: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
280: ad_ddl.create_index,
281: 'create unique index FA_MC_DEPRN_DETAIL_U1 ON
282: FA_MC_DEPRN_DETAIL(
283: DISTRIBUTION_ID,

Line 280: ad_ddl.create_index,

276: PERIOD_COUNTER,
277: SET_OF_BOOKS_ID)', 'INDEX');
278:
279: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
280: ad_ddl.create_index,
281: 'create unique index FA_MC_DEPRN_DETAIL_U1 ON
282: FA_MC_DEPRN_DETAIL(
283: DISTRIBUTION_ID,
284: ASSET_ID,

Line 289: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

285: BOOK_TYPE_CODE,
286: PERIOD_COUNTER,
287: SET_OF_BOOKS_ID)', 'INDEX');
288:
289: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
290: ad_ddl.create_index,
291: 'create unique index FA_MC_DEPRN_PERIODS_U1 ON
292: FA_MC_DEPRN_PERIODS(
293: BOOK_TYPE_CODE,

Line 290: ad_ddl.create_index,

286: PERIOD_COUNTER,
287: SET_OF_BOOKS_ID)', 'INDEX');
288:
289: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
290: ad_ddl.create_index,
291: 'create unique index FA_MC_DEPRN_PERIODS_U1 ON
292: FA_MC_DEPRN_PERIODS(
293: BOOK_TYPE_CODE,
294: PERIOD_NAME,

Line 297: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

293: BOOK_TYPE_CODE,
294: PERIOD_NAME,
295: SET_OF_BOOKS_ID)', 'INDEX');
296:
297: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
298: ad_ddl.create_index,
299: 'create unique index FA_MC_DEPRN_PERIODS_U2 ON
300: FA_MC_DEPRN_PERIODS(
301: BOOK_TYPE_CODE,

Line 298: ad_ddl.create_index,

294: PERIOD_NAME,
295: SET_OF_BOOKS_ID)', 'INDEX');
296:
297: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
298: ad_ddl.create_index,
299: 'create unique index FA_MC_DEPRN_PERIODS_U2 ON
300: FA_MC_DEPRN_PERIODS(
301: BOOK_TYPE_CODE,
302: FISCAL_YEAR,

Line 306: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

302: FISCAL_YEAR,
303: PERIOD_NUM,
304: SET_OF_BOOKS_ID)', 'INDEX');
305:
306: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
307: ad_ddl.create_index,
308: 'create unique index FA_MC_DEPRN_PERIODS_U3 ON
309: FA_MC_DEPRN_PERIODS(
310: BOOK_TYPE_CODE,

Line 307: ad_ddl.create_index,

303: PERIOD_NUM,
304: SET_OF_BOOKS_ID)', 'INDEX');
305:
306: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
307: ad_ddl.create_index,
308: 'create unique index FA_MC_DEPRN_PERIODS_U3 ON
309: FA_MC_DEPRN_PERIODS(
310: BOOK_TYPE_CODE,
311: PERIOD_COUNTER,

Line 313: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

309: FA_MC_DEPRN_PERIODS(
310: BOOK_TYPE_CODE,
311: PERIOD_COUNTER,
312: SET_OF_BOOKS_ID)', 'INDEX');
313: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
314: ad_ddl.create_index,
315: 'create index FA_MC_DEPRN_SUMMARY_N1 ON
316: FA_MC_DEPRN_SUMMARY(
317: BOOK_TYPE_CODE,

Line 314: ad_ddl.create_index,

310: BOOK_TYPE_CODE,
311: PERIOD_COUNTER,
312: SET_OF_BOOKS_ID)', 'INDEX');
313: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
314: ad_ddl.create_index,
315: 'create index FA_MC_DEPRN_SUMMARY_N1 ON
316: FA_MC_DEPRN_SUMMARY(
317: BOOK_TYPE_CODE,
318: PERIOD_COUNTER,

Line 321: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

317: BOOK_TYPE_CODE,
318: PERIOD_COUNTER,
319: SET_OF_BOOKS_ID)', 'INDEX');
320:
321: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
322: ad_ddl.create_index,
323: 'create unique index FA_MC_DEPRN_SUMMARY_U1 ON
324: FA_MC_DEPRN_SUMMARY(
325: ASSET_ID,

Line 322: ad_ddl.create_index,

318: PERIOD_COUNTER,
319: SET_OF_BOOKS_ID)', 'INDEX');
320:
321: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
322: ad_ddl.create_index,
323: 'create unique index FA_MC_DEPRN_SUMMARY_U1 ON
324: FA_MC_DEPRN_SUMMARY(
325: ASSET_ID,
326: BOOK_TYPE_CODE,

Line 330: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

326: BOOK_TYPE_CODE,
327: PERIOD_COUNTER,
328: SET_OF_BOOKS_ID)', 'INDEX');
329:
330: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
331: ad_ddl.create_index,
332: 'create unique index FA_MC_RETIREMENTS_U1 ON
333: FA_MC_RETIREMENTS(
334: SET_OF_BOOKS_ID,

Line 331: ad_ddl.create_index,

327: PERIOD_COUNTER,
328: SET_OF_BOOKS_ID)', 'INDEX');
329:
330: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
331: ad_ddl.create_index,
332: 'create unique index FA_MC_RETIREMENTS_U1 ON
333: FA_MC_RETIREMENTS(
334: SET_OF_BOOKS_ID,
335: RETIREMENT_ID)', 'INDEX');