eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_OPM_COGS_PKG dependencies on OPI_DBI_OPM_COGSTST_PRIOR

Line 550: from opi_dbi_opm_cogstst_prior

546: ,SHIP_OU_ID
547: ,SELL_OU_ID
548: ,TURNS_COGS_FLAG
549: ,SOURCE
550: from opi_dbi_opm_cogstst_prior
551: union all
552: select
553: INVENTORY_ITEM_ID
554: ,ORGANIZATION_ID

Line 588: || '.opi_dbi_opm_cogstst_prior ';

584: execute immediate 'truncate table ' || g_opi_schema
585: || '.opi_dbi_opm_cogsled_current ';
586:
587: execute immediate 'truncate table ' || g_opi_schema
588: || '.opi_dbi_opm_cogstst_prior ';
589:
590: commit;
591: fnd_stats.gather_table_stats( ownname => g_opi_schema,
592: tabname => 'OPI_DBI_COGS_STG',

Line 596: insert /+ append / into opi_dbi_opm_cogstst_prior

592: tabname => 'OPI_DBI_COGS_STG',
593: percent => 10);
594:
595:
596: insert /*+ append */ into opi_dbi_opm_cogstst_prior
597: ( INVENTORY_ITEM_ID
598: ,ORGANIZATION_ID
599: ,ORDER_LINE_ID
600: ,MARGIN_OU_ID

Line 627: tabname => 'OPI_DBI_OPM_COGSTST_PRIOR',

623: from opi_dbi_opm_cogstst_current;
624:
625: commit;
626: fnd_stats.gather_table_stats( ownname => g_opi_schema,
627: tabname => 'OPI_DBI_OPM_COGSTST_PRIOR',
628: percent => 10);
629:
630:
631: execute immediate 'truncate table ' || g_opi_schema

Line 1160: from opi_dbi_opm_cogstst_prior TSTPRIOR

1156: ,SHIP_OU_ID
1157: ,SELL_OU_ID
1158: ,TURNS_COGS_FLAG
1159: ,SOURCE
1160: from opi_dbi_opm_cogstst_prior TSTPRIOR
1161: union all
1162: select /*+ PARALLEL(LED) */
1163: INVENTORY_ITEM_ID
1164: ,ORGANIZATION_ID

Line 1200: || '.opi_dbi_opm_cogstst_prior ';

1196: execute immediate 'truncate table ' || g_opi_schema
1197: || '.opi_dbi_opm_cogsled_current ';
1198:
1199: execute immediate 'truncate table ' || g_opi_schema
1200: || '.opi_dbi_opm_cogstst_prior ';
1201:
1202: fnd_stats.gather_table_stats( ownname => g_opi_schema,
1203: tabname => 'OPI_DBI_COGS_STG',
1204: percent => 10);

Line 1210: into opi_dbi_opm_cogstst_prior F

1206:
1207: -- execute immediate 'alter session force parallel query parallel '||p_degree ;
1208:
1209: insert /*+ APPEND PARALLEL(F) */
1210: into opi_dbi_opm_cogstst_prior F
1211: ( INVENTORY_ITEM_ID
1212: ,ORGANIZATION_ID
1213: ,ORDER_LINE_ID
1214: ,MARGIN_OU_ID

Line 1245: tabname => 'OPI_DBI_OPM_COGSTST_PRIOR',

1241: commit;
1242:
1243:
1244: fnd_stats.gather_table_stats( ownname => g_opi_schema,
1245: tabname => 'OPI_DBI_OPM_COGSTST_PRIOR',
1246: percent => 10);
1247:
1248:
1249:

Line 1735: || '.opi_dbi_opm_cogstst_prior ';

1731:
1732: execute immediate 'truncate table ' || g_opi_schema
1733: || '.opi_dbi_opm_cogstst_current ';
1734: execute immediate 'truncate table ' || g_opi_schema
1735: || '.opi_dbi_opm_cogstst_prior ';
1736: execute immediate 'truncate table ' || g_opi_schema
1737: || '.opi_dbi_opm_cogsled_current ';
1738:
1739: