APPS.OPI_DBI_OPM_COGS_PKG dependencies on OPI_DBI_MARGIN_F

Line 1397: merge INTO opi_dbi_margin_f m

1393: BIS_COLLECTION_UTILITIES.PUT_LINE('completed report_missing_rate ');
1394:
1395: IF l_exception_count = 0 AND l_missing_rate_count = 0 THEN
1396: BIS_COLLECTION_UTILITIES.PUT_LINE('merging into fact table');
1397: merge INTO opi_dbi_margin_f m
1398: using (SELECT *
1399: FROM opi_dbi_cogs_stg ) c
1400: ON ( m.order_line_id = c.order_line_id
1401: AND m.margin_ou_id = c.margin_ou_id )

Line 1710: /* IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_MARGIN_F' ) = false then

1706: l_industry VARCHAR2(30);
1707: l_revenue_count NUMBER := 0;
1708: l_cogs_count NUMBER := 0;
1709: BEGIN
1710: /* IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_MARGIN_F' ) = false then
1711: RAISE_APPLICATION_ERROR(-20000, errbuf);
1712: END IF;
1713: */
1714: -- setup globals

Line 1729: /* delete from opi_dbi_margin_f */

1725:
1726: /* delete from opi_dbi_cogs_stg */
1727: /* where source like 'OPM%'; */
1728:
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 ';

Line 1782: /* IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_MARGIN_F' ) = false then

1778: l_revenue_count NUMBER := 0;
1779: l_cogs_count NUMBER := 0;
1780: BEGIN
1781:
1782: /* IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_MARGIN_F' ) = false then
1783: RAISE_APPLICATION_ERROR(-20000, errbuf);
1784: END IF;
1785: */
1786: check_setup_globals(errbuf, retcode);