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_CURRENT

Line 212: insert /+ append / into opi_dbi_opm_cogstst_current

208:
209: BEGIN
210:
211: -- Regular sales order
212: insert /*+ append */ into opi_dbi_opm_cogstst_current
213: ( INVENTORY_ITEM_ID
214: ,ORGANIZATION_ID
215: ,ORDER_LINE_ID
216: ,MARGIN_OU_ID

Line 346: tabname => 'OPI_DBI_OPM_COGSTST_CURRENT',

342: ,SOURCE ;
343:
344: commit;
345: fnd_stats.gather_table_stats( ownname => g_opi_schema,
346: tabname => 'OPI_DBI_OPM_COGSTST_CURRENT',
347: percent => 10);
348:
349:
350:

Line 535: from opi_dbi_opm_cogstst_current

531: ,SHIP_OU_ID
532: ,SELL_OU_ID
533: ,TURNS_COGS_FLAG
534: ,SOURCE
535: from opi_dbi_opm_cogstst_current
536: union all
537: select
538: INVENTORY_ITEM_ID
539: ,ORGANIZATION_ID

Line 623: from opi_dbi_opm_cogstst_current;

619: ,SHIP_OU_ID
620: ,SELL_OU_ID
621: ,TURNS_COGS_FLAG
622: ,SOURCE
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',

Line 632: || '.opi_dbi_opm_cogstst_current ';

628: percent => 10);
629:
630:
631: execute immediate 'truncate table ' || g_opi_schema
632: || '.opi_dbi_opm_cogstst_current ';
633:
634: x_status := 1; -- complete successfully
635: x_msg := NULL;
636: EXCEPTION WHEN OTHERS THEN

Line 749: into opi_dbi_opm_cogstst_current F

745: -- execute immediate 'alter session force parallel query parallel '||p_degree ;
746:
747: -- Regular sales order
748: insert /*+ APPEND PARALLEL(F) */
749: into opi_dbi_opm_cogstst_current F
750: ( INVENTORY_ITEM_ID
751: ,ORGANIZATION_ID
752: ,ORDER_LINE_ID
753: ,MARGIN_OU_ID

Line 918: tabname => 'OPI_DBI_OPM_COGSTST_CURRENT',

914:
915: commit;
916:
917: fnd_stats.gather_table_stats( ownname => g_opi_schema,
918: tabname => 'OPI_DBI_OPM_COGSTST_CURRENT',
919: percent => 10);
920:
921: -- execute immediate 'alter session force parallel query parallel '||p_degree ;
922:

Line 1145: from opi_dbi_opm_cogstst_current TSTCURR

1141: ,SHIP_OU_ID
1142: ,SELL_OU_ID
1143: ,TURNS_COGS_FLAG
1144: ,SOURCE
1145: from opi_dbi_opm_cogstst_current TSTCURR
1146: union all
1147: select /*+ PARALLEL(TSTPRIOR) */
1148: INVENTORY_ITEM_ID
1149: ,ORGANIZATION_ID

Line 1237: from opi_dbi_opm_cogstst_current curr;

1233: ,SHIP_OU_ID
1234: ,SELL_OU_ID
1235: ,TURNS_COGS_FLAG
1236: ,SOURCE
1237: from opi_dbi_opm_cogstst_current curr;
1238:
1239: -- execute immediate 'alter session disable parallel query';
1240:
1241: commit;

Line 1251: || '.opi_dbi_opm_cogstst_current ';

1247:
1248:
1249:
1250: execute immediate 'truncate table ' || g_opi_schema
1251: || '.opi_dbi_opm_cogstst_current ';
1252:
1253:
1254: x_status := 1; -- complete successfully
1255: x_msg := NULL;

Line 1733: || '.opi_dbi_opm_cogstst_current ';

1729: /* delete from opi_dbi_margin_f */
1730: /* where cogs_source like 'OPM%'; */
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 ';