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_COGSLED_CURRENT

Line 351: insert /+ append / into opi_dbi_opm_cogsled_current

347: percent => 10);
348:
349:
350:
351: insert /*+ append */ into opi_dbi_opm_cogsled_current
352: ( INVENTORY_ITEM_ID
353: ,ORGANIZATION_ID
354: ,ORDER_LINE_ID
355: ,MARGIN_OU_ID

Line 485: tabname => 'OPI_DBI_OPM_COGSLED_CURRENT',

481: ,SOURCE ;
482:
483: commit;
484: fnd_stats.gather_table_stats( ownname => g_opi_schema,
485: tabname => 'OPI_DBI_OPM_COGSLED_CURRENT',
486: percent => 10);
487:
488:
489:

Line 565: from opi_dbi_opm_cogsled_current

561: ,SHIP_OU_ID
562: ,SELL_OU_ID
563: ,TURNS_COGS_FLAG
564: ,SOURCE
565: from opi_dbi_opm_cogsled_current
566: )
567: group by
568: INVENTORY_ITEM_ID
569: ,ORGANIZATION_ID

Line 585: || '.opi_dbi_opm_cogsled_current ';

581:
582: l_stmt := 1;
583:
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:

Line 924: into opi_dbi_opm_cogsled_current F

920:
921: -- execute immediate 'alter session force parallel query parallel '||p_degree ;
922:
923: insert /*+ APPEND PARALLEL(F) */
924: into opi_dbi_opm_cogsled_current F
925: ( INVENTORY_ITEM_ID
926: ,ORGANIZATION_ID
927: ,ORDER_LINE_ID
928: ,MARGIN_OU_ID

Line 1093: tabname => 'OPI_DBI_OPM_COGSLED_CURRENT',

1089: -- execute immediate 'alter session disable parallel query';
1090:
1091: commit;
1092: fnd_stats.gather_table_stats( ownname => g_opi_schema,
1093: tabname => 'OPI_DBI_OPM_COGSLED_CURRENT',
1094: percent => 10);
1095:
1096:
1097: -- execute immediate 'alter session force parallel query parallel '||p_degree ;

Line 1175: from opi_dbi_opm_cogsled_current LED

1171: ,SHIP_OU_ID
1172: ,SELL_OU_ID
1173: ,TURNS_COGS_FLAG
1174: ,SOURCE
1175: from opi_dbi_opm_cogsled_current LED
1176: ) A
1177: group by
1178: INVENTORY_ITEM_ID
1179: ,ORGANIZATION_ID

Line 1197: || '.opi_dbi_opm_cogsled_current ';

1193:
1194: l_stmt := 1;
1195:
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:

Line 1737: || '.opi_dbi_opm_cogsled_current ';

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:
1740: commit;
1741: