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_MARGIN_PERD_ILOG

Line 559: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_ILOG');

555: --
556: -- Clean up Temporary work tables data. if previous run failed these tables will have data.
557: --
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');

Line 754: insert into OPI_EDW_MARGIN_PERD_ILOG(ROW_ID,STATUS) (select /+ ALL_ROWS / distinct m_row$$ ,0 from MLOG$_OPI_EDW_MARGIN_F);

750: -- Take the backup of changed rows
751: --
752: --
753:
754: insert into OPI_EDW_MARGIN_PERD_ILOG(ROW_ID,STATUS) (select /*+ ALL_ROWS */ distinct m_row$$ ,0 from MLOG$_OPI_EDW_MARGIN_F);
755:
756: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows to be processed to build margin period summary'||SQL%ROWCOUNT);
757: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
758:

Line 765: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MARGIN_PERD_ILOG');

761: -- Gather table statistics these stats will be used by CBO for query optimisation.
762: --
763: --
764:
765: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MARGIN_PERD_ILOG');
766:
767: commit;
768:
769:

Line 906: UPDATE OPI_EDW_MARGIN_PERD_ILOG

902:
903: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_MAX_VALUES');
904:
905: LOOP
906: UPDATE OPI_EDW_MARGIN_PERD_ILOG
907: SET STATUS =1
908: WHERE STATUS = 0 AND
909: ROWNUM < l_chunk_size;
910: IF SQL%ROWCOUNT = 0 THEN

Line 919: INDEX(LOG, OPI_EDW_MARGIN_PERD_ILOG_U1) */

915: MAX_UNIT_SELLING_PRICE,
916: GL_DATE_FK_KEY,
917: ROW_ID)
918: SELECT /*+ INDEX(MRG, OPI_EDW_MARGIN_F_U)
919: INDEX(LOG, OPI_EDW_MARGIN_PERD_ILOG_U1) */
920: MAXVALS.MAX_GL_POSTED_DATE,
921: MAXVALS.MAX_UNIT_SELLING_PRICE,
922: MAXVALS.GL_DATE_FK_KEY,
923: MRG.ROWID

Line 925: OPI_EDW_MARGIN_PERD_ILOG LOG,

921: MAXVALS.MAX_UNIT_SELLING_PRICE,
922: MAXVALS.GL_DATE_FK_KEY,
923: MRG.ROWID
924: FROM
925: OPI_EDW_MARGIN_PERD_ILOG LOG,
926: OPI_EDW_MARGIN_F MRG,
927: OPI_EDW_MRG_MAX_VALUES MAXVALS
928: WHERE
929: MAXVALS.ORDER_LINE_ID = MRG.ORDER_LINE_ID

Line 960: UPDATE OPI_EDW_MARGIN_PERD_ILOG

956:
957: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);
958: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
959: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');
960: UPDATE OPI_EDW_MARGIN_PERD_ILOG
961: SET STATUS =2
962: WHERE STATUS = 1;
963: END LOOP;
964: UPDATE OPI_EDW_MARGIN_PERD_ILOG

Line 964: UPDATE OPI_EDW_MARGIN_PERD_ILOG

960: UPDATE OPI_EDW_MARGIN_PERD_ILOG
961: SET STATUS =2
962: WHERE STATUS = 1;
963: END LOOP;
964: UPDATE OPI_EDW_MARGIN_PERD_ILOG
965: SET STATUS =0;
966: COMMIT;
967: ELSIF p_Base_fact_name = 'OPI_EDW_COGS_F' /*COGS Fact */
968: THEN

Line 1107: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1103:
1104:
1105:
1106: LOOP
1107: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1108: SET STATUS =1
1109: WHERE STATUS = 0 AND
1110: ROWNUM < l_chunk_size;
1111: IF SQL%ROWCOUNT = 0 THEN

Line 1128: OPI_EDW_MARGIN_PERD_ILOG LOG,

1124: MAXVALS.MAX_ORDER_NUMBER,
1125: MAXVALS.MAX_COGS_DATE,
1126: MRG.ROWID
1127: FROM
1128: OPI_EDW_MARGIN_PERD_ILOG LOG,
1129: OPI_EDW_MARGIN_F MRG,
1130: OPI_EDW_MRG_MAX_VALUES MAXVALS
1131: WHERE
1132: MAXVALS.ORDER_LINE_ID = MRG.ORDER_LINE_ID

Line 1171: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1167: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1168:
1169: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');
1170:
1171: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1172: SET STATUS =2
1173: WHERE STATUS = 1;
1174: END LOOP;
1175: UPDATE OPI_EDW_MARGIN_PERD_ILOG

Line 1175: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1171: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1172: SET STATUS =2
1173: WHERE STATUS = 1;
1174: END LOOP;
1175: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1176: SET STATUS =0;
1177: COMMIT;
1178: ELSIF p_base_fact_name = 'OPI_EDW_MARGIN_F' /* if it is a full Refesh */
1179: THEN

Line 1311: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1307:
1308: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_MAX_VALUES');
1309:
1310: LOOP
1311: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1312: SET STATUS =1
1313: WHERE STATUS = 0 AND
1314: ROWNUM < l_chunk_size;
1315: IF SQL%ROWCOUNT = 0 THEN

Line 1328: OPI_EDW_MARGIN_PERD_ILOG LOG,

1324: MAXVALS.MAX_UNIT_SELLING_PRICE,
1325: MAXVALS.GL_DATE_FK_KEY,
1326: MRG.ROWID
1327: FROM
1328: OPI_EDW_MARGIN_PERD_ILOG LOG,
1329: OPI_EDW_MARGIN_F MRG,
1330: OPI_EDW_MRG_MAX_VALUES MAXVALS
1331: WHERE
1332: MAXVALS.ORDER_LINE_ID = MRG.ORDER_LINE_ID

Line 1367: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1363: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1364:
1365: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');
1366:
1367: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1368: SET STATUS =2
1369: WHERE STATUS = 1;
1370: END LOOP;
1371: UPDATE OPI_EDW_MARGIN_PERD_ILOG

Line 1371: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1367: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1368: SET STATUS =2
1369: WHERE STATUS = 1;
1370: END LOOP;
1371: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1372: SET STATUS =0;
1373: COMMIT;
1374:
1375: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_MAX_VALUES');

Line 1518: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1514:
1515:
1516:
1517: LOOP
1518: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1519: SET STATUS =1
1520: WHERE STATUS = 0 AND
1521: ROWNUM < l_chunk_size;
1522: IF SQL%ROWCOUNT = 0 THEN

Line 1539: OPI_EDW_MARGIN_PERD_ILOG LOG,

1535: MAXVALS.MAX_ORDER_NUMBER,
1536: MAXVALS.MAX_COGS_DATE,
1537: MRG.ROWID
1538: FROM
1539: OPI_EDW_MARGIN_PERD_ILOG LOG,
1540: OPI_EDW_MARGIN_F MRG,
1541: OPI_EDW_MRG_MAX_VALUES MAXVALS
1542: WHERE
1543: MAXVALS.ORDER_LINE_ID = MRG.ORDER_LINE_ID

Line 1582: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1578: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1579:
1580: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');
1581:
1582: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1583: SET STATUS =2
1584: WHERE STATUS = 1;
1585: END LOOP;
1586: UPDATE OPI_EDW_MARGIN_PERD_ILOG

Line 1586: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1582: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1583: SET STATUS =2
1584: WHERE STATUS = 1;
1585: END LOOP;
1586: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1587: SET STATUS =0;
1588: COMMIT;
1589:
1590: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from cogs fact'||SQL%ROWCOUNT);

Line 1600: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1596: *** with either COGS Date FK KEy OR Revenue Date Fk Key ***
1597: +*****************************************************************************************/
1598:
1599: LOOP
1600: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1601: SET STATUS =1
1602: WHERE STATUS = 0 AND
1603: ROWNUM < l_chunk_size;
1604: IF SQL%ROWCOUNT = 0 THEN

Line 1628: FROM OPI_EDW_MARGIN_PERD_ILOG

1624: WHERE MRG.SHIP_DATE IS NOT NULL
1625: AND MRG.INVOICE_DATE IS NOT NULL
1626: AND MRG.ship_date >= MRG.invoice_date
1627: AND EXISTS (SELECT 1
1628: FROM OPI_EDW_MARGIN_PERD_ILOG
1629: WHERE MRG.ROWID = ROW_ID
1630: AND STATUS = 1);
1631: /*************************************************************************
1632: *** Update Margin Date FK Key with Revenue Date FK Key if Ship date is **

Line 1652: FROM OPI_EDW_MARGIN_PERD_ILOG

1648: AND TIM2.CDAY_CAL_DAY_PK = PERDLTC.CAL_PERIOD_PK ||'-CPER' )
1649: WHERE MRG.SHIP_DATE IS NOT NULL
1650: AND MRG.RMA_QTY IS NOT NULL
1651: AND EXISTS (SELECT 1
1652: FROM OPI_EDW_MARGIN_PERD_ILOG
1653: WHERE MRG.ROWID = ROW_ID
1654: AND STATUS = 1);
1655: -- End of addition --
1656: UPDATE OPI_EDW_MARGIN_F MRG

Line 1672: FROM OPI_EDW_MARGIN_PERD_ILOG

1668: WHERE MRG.SHIP_DATE is NOT NULL
1669: AND MRG.INVOICE_DATE is NOT NULL
1670: AND MRG.ship_date < MRG.invoice_date
1671: AND EXISTS (SELECT 1
1672: FROM OPI_EDW_MARGIN_PERD_ILOG
1673: WHERE MRG.ROWID = ROW_ID
1674: AND STATUS = 1);
1675:
1676: UPDATE OPI_EDW_MARGIN_PERD_ILOG

Line 1676: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1672: FROM OPI_EDW_MARGIN_PERD_ILOG
1673: WHERE MRG.ROWID = ROW_ID
1674: AND STATUS = 1);
1675:
1676: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1677: SET STATUS =2
1678: WHERE STATUS = 1;
1679: END LOOP;
1680: UPDATE OPI_EDW_MARGIN_PERD_ILOG

Line 1680: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1676: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1677: SET STATUS =2
1678: WHERE STATUS = 1;
1679: END LOOP;
1680: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1681: SET STATUS =0;
1682: COMMIT;
1683:
1684: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F generated period FK KEY'||SQL%ROWCOUNT);

Line 1694: UPDATE OPI_EDW_MARGIN_PERD_ILOG

1690:
1691:
1692: -- delete MLOG$_OPI_EDW_MARGIN_F;
1693: LOOP
1694: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1695: SET STATUS =1
1696: WHERE STATUS = 0 AND
1697: ROWNUM < l_chunk_size;
1698: IF SQL%ROWCOUNT = 0 THEN

Line 1772: FROM OPI_EDW_MARGIN_F, OPI_EDW_MARGIN_PERD_ILOG

1768: ,SUM(USER_MEASURE4)
1769: ,SUM(USER_MEASURE3)
1770: ,SUM(USER_MEASURE2)
1771: ,SUM(USER_MEASURE1)
1772: FROM OPI_EDW_MARGIN_F, OPI_EDW_MARGIN_PERD_ILOG
1773: WHERE OPI_EDW_MARGIN_PERD_ILOG.ROW_ID = OPI_EDW_MARGIN_F.ROWID
1774: AND OPI_EDW_MARGIN_PERD_ILOG.STATUS = 1
1775: AND GL_PERIOD_FK_KEY IS NOT NULL
1776: AND GL_PERIOD_FK_KEY <> '0'

Line 1773: WHERE OPI_EDW_MARGIN_PERD_ILOG.ROW_ID = OPI_EDW_MARGIN_F.ROWID

1769: ,SUM(USER_MEASURE3)
1770: ,SUM(USER_MEASURE2)
1771: ,SUM(USER_MEASURE1)
1772: FROM OPI_EDW_MARGIN_F, OPI_EDW_MARGIN_PERD_ILOG
1773: WHERE OPI_EDW_MARGIN_PERD_ILOG.ROW_ID = OPI_EDW_MARGIN_F.ROWID
1774: AND OPI_EDW_MARGIN_PERD_ILOG.STATUS = 1
1775: AND GL_PERIOD_FK_KEY IS NOT NULL
1776: AND GL_PERIOD_FK_KEY <> '0'
1777: GROUP BY

Line 1774: AND OPI_EDW_MARGIN_PERD_ILOG.STATUS = 1

1770: ,SUM(USER_MEASURE2)
1771: ,SUM(USER_MEASURE1)
1772: FROM OPI_EDW_MARGIN_F, OPI_EDW_MARGIN_PERD_ILOG
1773: WHERE OPI_EDW_MARGIN_PERD_ILOG.ROW_ID = OPI_EDW_MARGIN_F.ROWID
1774: AND OPI_EDW_MARGIN_PERD_ILOG.STATUS = 1
1775: AND GL_PERIOD_FK_KEY IS NOT NULL
1776: AND GL_PERIOD_FK_KEY <> '0'
1777: GROUP BY
1778: ITEM_ORG_FK_KEY

Line 1998: UPDATE OPI_EDW_MARGIN_PERD_ILOG

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;
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');

Line 2199: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_ILOG');

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');
2199: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_ILOG');
2200: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_REV_LOG');
2201: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_MAX_VALUES');
2202: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_KEYS');
2203: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_COGS_LOG');