DBA Data[Home] [Help]

APPS.CST_INVENTORY_PUB dependencies on FND_STATS

Line 204: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_ITEM_LIST_TEMP');

200:
201: IF l_schema IS NOT NULL
202: THEN
203: l_stmt_num := 37;
204: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_ITEM_LIST_TEMP');
205: l_stmt_num := 38;
206: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_CG_LIST_TEMP');
207: l_stmt_num := 39;
208: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_SUB_LIST_TEMP');

Line 206: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_CG_LIST_TEMP');

202: THEN
203: l_stmt_num := 37;
204: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_ITEM_LIST_TEMP');
205: l_stmt_num := 38;
206: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_CG_LIST_TEMP');
207: l_stmt_num := 39;
208: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_SUB_LIST_TEMP');
209: END IF;
210:

Line 208: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_SUB_LIST_TEMP');

204: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_ITEM_LIST_TEMP');
205: l_stmt_num := 38;
206: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_CG_LIST_TEMP');
207: l_stmt_num := 39;
208: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_SUB_LIST_TEMP');
209: END IF;
210:
211: -- Re-establish the savepoint because gather statistics does an implicit commit
212: SAVEPOINT Calculate_InventoryValue_PUB;

Line 304: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_INV_QTY_TEMP');

300:
301: IF l_schema IS NOT NULL
302: THEN
303: l_stmt_num := 66;
304: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_INV_QTY_TEMP');
305: END IF;
306:
307: -- Re-establish the savepoint because gather statistics does an implicit commit
308: SAVEPOINT Calculate_InventoryValue_PUB;

Line 330: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_INV_COST_TEMP');

326: THEN
327: IF l_schema IS NOT NULL
328: THEN
329: l_stmt_num := 75;
330: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_INV_COST_TEMP');
331: END IF;
332: END IF;
333:
334: l_stmt_num := 80;