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_COLLECTION_HOOK_P dependencies on OPI_EDW_PERD_MARGIN_F

Line 562: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');

558: --
559: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_ILOG');
560: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_MAX_VALUES');
561: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_KEYS');
562: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');
563: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');
564: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FIR');
565: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FDLG');
566: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FD');

Line 563: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');

559: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_ILOG');
560: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_MAX_VALUES');
561: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_KEYS');
562: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');
563: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');
564: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FIR');
565: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FDLG');
566: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FD');
567: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');

Line 737: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_F');

733: ELSE
734: /***********************************************************************************************************
735: *** Trancate the Period Margin Fact because margin fact is rebuilt so we need to rebuild period summary ****
736: ************************************************************************************************************/
737: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_F');
738: END IF;
739:
740: --
741: --

Line 1704: INSERT INTO OPI_EDW_PERD_MARGIN_FT(

1700: END IF;
1701: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows in processing'||SQL%ROWCOUNT);
1702: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1703: COMMIT;
1704: INSERT INTO OPI_EDW_PERD_MARGIN_FT(
1705: ITEM_ORG_FK_KEY
1706: ,OPERATING_UNIT_FK_KEY
1707: ,BASE_CURRENCY_FK_KEY
1708: ,SOB_FK_KEY

Line 1798: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FT '||SQL%ROWCOUNT);

1794: ,USER_FK3_KEY
1795: ,USER_FK2_KEY
1796: ,USER_FK1_KEY);
1797:
1798: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FT '||SQL%ROWCOUNT);
1799: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1800: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FT');
1801:
1802:

Line 1800: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FT');

1796: ,USER_FK1_KEY);
1797:
1798: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FT '||SQL%ROWCOUNT);
1799: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1800: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FT');
1801:
1802:
1803: INSERT INTO OPI_EDW_PERD_MARGIN_FUR(
1804: COGS_G

Line 1803: INSERT INTO OPI_EDW_PERD_MARGIN_FUR(

1799: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1800: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FT');
1801:
1802:
1803: INSERT INTO OPI_EDW_PERD_MARGIN_FUR(
1804: COGS_G
1805: ,COGS_B
1806: ,PROD_AMT_G
1807: ,PROD_AMT_B

Line 1837: FROM OPI_EDW_PERD_MARGIN_F MRGF, OPI_EDW_PERD_MARGIN_FT MRGFT

1833: ,NVL(MRGF.USER_MEASURE2,0) +NVL(MRGFT.USER_MEASURE2,0)
1834: ,NVL(MRGF.USER_MEASURE1,0) +NVL(MRGFT.USER_MEASURE1,0)
1835: ,MRGFT.ROWID
1836: ,MRGF.ROWID
1837: FROM OPI_EDW_PERD_MARGIN_F MRGF, OPI_EDW_PERD_MARGIN_FT MRGFT
1838: WHERE MRGF.ITEM_ORG_FK_KEY=MRGFT.ITEM_ORG_FK_KEY
1839: AND MRGF.OPERATING_UNIT_FK_KEY=MRGFT.OPERATING_UNIT_FK_KEY
1840: AND MRGF.BASE_CURR_FK_KEY = MRGFT.BASE_CURRENCY_FK_KEY
1841: AND MRGF.SOB_FK_KEY=MRGFT.SOB_FK_KEY

Line 1858: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FUR '||SQL%ROWCOUNT);

1854: AND NVL(MRGF.USER_FK3_KEY,0)=NVL(MRGFT.USER_FK3_KEY,0)
1855: AND NVL(MRGF.USER_FK2_KEY,0)=NVL(MRGFT.USER_FK2_KEY,0)
1856: AND NVL(MRGF.USER_FK1_KEY,0)=NVL(MRGFT.USER_FK1_KEY,0));
1857:
1858: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FUR '||SQL%ROWCOUNT);
1859: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1860: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FUR');
1861:
1862:

Line 1860: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FUR');

1856: AND NVL(MRGF.USER_FK1_KEY,0)=NVL(MRGFT.USER_FK1_KEY,0));
1857:
1858: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FUR '||SQL%ROWCOUNT);
1859: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1860: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FUR');
1861:
1862:
1863: COMMIT;
1864:

Line 1866: SELECT /+ ALL_ROWS / ROWID ROW_ID FROM OPI_EDW_PERD_MARGIN_FT

1862:
1863: COMMIT;
1864:
1865: INSERT INTO OPI_EDW_MARGIN_PERD_FIR (
1866: SELECT /*+ ALL_ROWS */ ROWID ROW_ID FROM OPI_EDW_PERD_MARGIN_FT
1867: MINUS
1868: SELECT /*+ ALL_ROWS */ ROW_ID ROW_ID FROM OPI_EDW_PERD_MARGIN_FUR);
1869:
1870: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows to be inserted into Margin period summary '||SQL%ROWCOUNT);

Line 1868: SELECT /+ ALL_ROWS / ROW_ID ROW_ID FROM OPI_EDW_PERD_MARGIN_FUR);

1864:
1865: INSERT INTO OPI_EDW_MARGIN_PERD_FIR (
1866: SELECT /*+ ALL_ROWS */ ROWID ROW_ID FROM OPI_EDW_PERD_MARGIN_FT
1867: MINUS
1868: SELECT /*+ ALL_ROWS */ ROW_ID ROW_ID FROM OPI_EDW_PERD_MARGIN_FUR);
1869:
1870: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows to be inserted into Margin period summary '||SQL%ROWCOUNT);
1871:
1872: l_insert := SQL%ROWCOUNT;

Line 1879: INSERT INTO OPI_EDW_PERD_MARGIN_F

1875: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MARGIN_PERD_FIR');
1876:
1877:
1878: IF l_insert <> 0 THEN
1879: INSERT INTO OPI_EDW_PERD_MARGIN_F
1880: (ITEM_ORG_FK_KEY
1881: ,OPERATING_UNIT_FK_KEY
1882: ,BASE_CURR_FK_KEY
1883: ,SOB_FK_KEY

Line 1951: FROM OPI_EDW_PERD_MARGIN_FT ,

1947: ,USER_MEASURE4
1948: ,USER_MEASURE3
1949: ,USER_MEASURE2
1950: ,USER_MEASURE1
1951: FROM OPI_EDW_PERD_MARGIN_FT ,
1952: OPI_EDW_MARGIN_PERD_FIR
1953: WHERE OPI_EDW_PERD_MARGIN_FT.ROWID = OPI_EDW_MARGIN_PERD_FIR.ROW_ID;
1954: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows inserted into Margin period summary '||SQL%ROWCOUNT);
1955: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

Line 1953: WHERE OPI_EDW_PERD_MARGIN_FT.ROWID = OPI_EDW_MARGIN_PERD_FIR.ROW_ID;

1949: ,USER_MEASURE2
1950: ,USER_MEASURE1
1951: FROM OPI_EDW_PERD_MARGIN_FT ,
1952: OPI_EDW_MARGIN_PERD_FIR
1953: WHERE OPI_EDW_PERD_MARGIN_FT.ROWID = OPI_EDW_MARGIN_PERD_FIR.ROW_ID;
1954: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows inserted into Margin period summary '||SQL%ROWCOUNT);
1955: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1956: END IF;
1957: COMMIT;

Line 1959: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_F');

1955: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1956: END IF;
1957: COMMIT;
1958:
1959: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_F');
1960:
1961: UPDATE OPI_EDW_PERD_MARGIN_F MRGF
1962: SET (COGS_G
1963: ,COGS_B

Line 1961: UPDATE OPI_EDW_PERD_MARGIN_F MRGF

1957: COMMIT;
1958:
1959: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_F');
1960:
1961: UPDATE OPI_EDW_PERD_MARGIN_F MRGF
1962: SET (COGS_G
1963: ,COGS_B
1964: ,PROD_AMT_G
1965: ,PROD_AMT_B

Line 1990: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU

1986: ,USER_MEASURE4
1987: ,USER_MEASURE3
1988: ,USER_MEASURE2
1989: ,USER_MEASURE1
1990: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
1991: WHERE MRGF.ROWID = MRGFU.ROW_ID1)
1992: WHERE EXISTS (SELECT 1
1993: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
1994: WHERE MRGF.ROWID = MRGFU.ROW_ID1);

Line 1993: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU

1989: ,USER_MEASURE1
1990: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
1991: WHERE MRGF.ROWID = MRGFU.ROW_ID1)
1992: WHERE EXISTS (SELECT 1
1993: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
1994: WHERE MRGF.ROWID = MRGFU.ROW_ID1);
1995: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows updated in Margin period summary '||SQL%ROWCOUNT);
1996: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1997: COMMIT;

Line 2001: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');

1997: COMMIT;
1998: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1999: SET STATUS =2
2000: WHERE STATUS = 1;
2001: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');
2002: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');
2003: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FIR');
2004: END LOOP;
2005: INSERT INTO OPI_EDW_PERD_MARGIN_FT(

Line 2002: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');

1998: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1999: SET STATUS =2
2000: WHERE STATUS = 1;
2001: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');
2002: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');
2003: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FIR');
2004: END LOOP;
2005: INSERT INTO OPI_EDW_PERD_MARGIN_FT(
2006: ITEM_ORG_FK_KEY

Line 2005: INSERT INTO OPI_EDW_PERD_MARGIN_FT(

2001: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');
2002: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');
2003: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FIR');
2004: END LOOP;
2005: INSERT INTO OPI_EDW_PERD_MARGIN_FT(
2006: ITEM_ORG_FK_KEY
2007: ,OPERATING_UNIT_FK_KEY
2008: ,BASE_CURRENCY_FK_KEY
2009: ,SOB_FK_KEY

Line 2096: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FT');

2092: ,USER_FK2_KEY
2093: ,USER_FK1_KEY);
2094: COMMIT;
2095:
2096: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FT');
2097:
2098:
2099: INSERT INTO OPI_EDW_PERD_MARGIN_FUR(
2100: COGS_G

Line 2099: INSERT INTO OPI_EDW_PERD_MARGIN_FUR(

2095:
2096: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FT');
2097:
2098:
2099: INSERT INTO OPI_EDW_PERD_MARGIN_FUR(
2100: COGS_G
2101: ,COGS_B
2102: ,PROD_AMT_G
2103: ,PROD_AMT_B

Line 2133: FROM OPI_EDW_PERD_MARGIN_F MRGF, OPI_EDW_PERD_MARGIN_FT MRGFT

2129: ,NVL(MRGF.USER_MEASURE2,0) -NVL(MRGFT.USER_MEASURE2,0)
2130: ,NVL(MRGF.USER_MEASURE1,0) -NVL(MRGFT.USER_MEASURE1,0)
2131: ,MRGFT.ROWID
2132: ,MRGF.ROWID
2133: FROM OPI_EDW_PERD_MARGIN_F MRGF, OPI_EDW_PERD_MARGIN_FT MRGFT
2134: WHERE MRGF.ITEM_ORG_FK_KEY=MRGFT.ITEM_ORG_FK_KEY
2135: AND MRGF.OPERATING_UNIT_FK_KEY=MRGFT.OPERATING_UNIT_FK_KEY
2136: AND MRGF.BASE_CURR_FK_KEY = MRGFT.BASE_CURRENCY_FK_KEY
2137: AND MRGF.SOB_FK_KEY=MRGFT.SOB_FK_KEY

Line 2155: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FUR');

2151: AND NVL(MRGF.USER_FK2_KEY,0)=NVL(MRGFT.USER_FK2_KEY,0)
2152: AND NVL(MRGF.USER_FK1_KEY,0)=NVL(MRGFT.USER_FK1_KEY,0));
2153: COMMIT;
2154:
2155: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FUR');
2156:
2157:
2158: UPDATE OPI_EDW_PERD_MARGIN_F MRGF
2159: SET (COGS_G

Line 2158: UPDATE OPI_EDW_PERD_MARGIN_F MRGF

2154:
2155: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FUR');
2156:
2157:
2158: UPDATE OPI_EDW_PERD_MARGIN_F MRGF
2159: SET (COGS_G
2160: ,COGS_B
2161: ,PROD_AMT_G
2162: ,PROD_AMT_B

Line 2187: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU

2183: ,USER_MEASURE4
2184: ,USER_MEASURE3
2185: ,USER_MEASURE2
2186: ,USER_MEASURE1
2187: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
2188: WHERE MRGF.ROWID = MRGFU.ROW_ID1)
2189: WHERE EXISTS (SELECT 1
2190: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
2191: WHERE MRGF.ROWID = MRGFU.ROW_ID1);

Line 2190: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU

2186: ,USER_MEASURE1
2187: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
2188: WHERE MRGF.ROWID = MRGFU.ROW_ID1)
2189: WHERE EXISTS (SELECT 1
2190: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
2191: WHERE MRGF.ROWID = MRGFU.ROW_ID1);
2192: COMMIT;
2193: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');
2194: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');

Line 2193: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');

2189: WHERE EXISTS (SELECT 1
2190: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
2191: WHERE MRGF.ROWID = MRGFU.ROW_ID1);
2192: COMMIT;
2193: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');
2194: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');
2195: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FIR');
2196: OPI_COLLECTION_HOOK_P.TURNC_TAB('MLOG$_OPI_EDW_MARGIN_F');
2197: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FDLG');

Line 2194: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');

2190: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
2191: WHERE MRGF.ROWID = MRGFU.ROW_ID1);
2192: COMMIT;
2193: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');
2194: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');
2195: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FIR');
2196: OPI_COLLECTION_HOOK_P.TURNC_TAB('MLOG$_OPI_EDW_MARGIN_F');
2197: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FDLG');
2198: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FD');