APPS.OPI_DBI_COGS_OPM_PKG dependencies on OPI_DBI_COGS_FSTG

Line 135: insert into opi_dbi_cogs_fstg

131: bis_collection_utilities.put_line('Load incremental OPM Test Subr cogs into stg '
132: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
133:
134: -- Regular sales order
135: insert into opi_dbi_cogs_fstg
136: (
137: INVENTORY_ITEM_ID
138: ,ORGANIZATION_ID
139: ,ORDER_LINE_ID

Line 240: insert into opi_dbi_cogs_fstg

236: commit;
237: bis_collection_utilities.put_line('Load incremental OPM Final Subr cogs into stg '
238: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
239:
240: insert into opi_dbi_cogs_fstg
241: (
242: INVENTORY_ITEM_ID
243: ,ORGANIZATION_ID
244: ,ORDER_LINE_ID

Line 352: tabname => 'OPI_DBI_COGS_FSTG',

348:
349: l_stmt := 1;
350:
351: fnd_stats.gather_table_stats( ownname => g_opi_schema,
352: tabname => 'OPI_DBI_COGS_FSTG',
353: percent => 10);
354:
355:
356:

Line 387: insert /*+ append parallel(opi_dbi_cogs_fstg) */ into opi_dbi_cogs_fstg

383: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
384:
385:
386: -- Regular sales order
387: insert /*+ append parallel(opi_dbi_cogs_fstg) */ into opi_dbi_cogs_fstg
388: (
389: INVENTORY_ITEM_ID
390: ,ORGANIZATION_ID
391: ,ORDER_LINE_ID

Line 496: insert /*+ append parallel(opi_dbi_cogs_fstg) */ into opi_dbi_cogs_fstg

492: bis_collection_utilities.put_line('Load OPM Final Subr cogs into stg '
493: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
494:
495: commit;
496: insert /*+ append parallel(opi_dbi_cogs_fstg) */ into opi_dbi_cogs_fstg
497: (
498: INVENTORY_ITEM_ID
499: ,ORGANIZATION_ID
500: ,ORDER_LINE_ID

Line 594: tabname => 'OPI_DBI_COGS_FSTG',

590:
591: l_stmt := 1;
592:
593: fnd_stats.gather_table_stats( ownname => g_opi_schema,
594: tabname => 'OPI_DBI_COGS_FSTG',
595: percent => 10);
596:
597: commit;
598: