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 EDW_TIME_M

Line 1616: FROM EDW_TIME_M TIM1,

1612: UPDATE OPI_EDW_MARGIN_F MRG
1613: SET MARGIN_DATE_FK_KEY = MRG.COGS_DATE_FK_KEY,
1614: GL_PERIOD_FK_KEY =
1615: (SELECT TIM2.CDAY_CAL_DAY_PK_KEY
1616: FROM EDW_TIME_M TIM1,
1617: EDW_TIME_M TIM2,
1618: EDW_TIME_CAL_PERIOD_LTC PERDLTC
1619: WHERE MRG.SHIP_DATE IS NOT NULL
1620: AND MRG.INVOICE_DATE IS NOT NULL

Line 1617: EDW_TIME_M TIM2,

1613: SET MARGIN_DATE_FK_KEY = MRG.COGS_DATE_FK_KEY,
1614: GL_PERIOD_FK_KEY =
1615: (SELECT TIM2.CDAY_CAL_DAY_PK_KEY
1616: FROM EDW_TIME_M TIM1,
1617: EDW_TIME_M TIM2,
1618: EDW_TIME_CAL_PERIOD_LTC PERDLTC
1619: WHERE MRG.SHIP_DATE IS NOT NULL
1620: AND MRG.INVOICE_DATE IS NOT NULL
1621: AND MRG.COGS_DATE_FK_KEY = TIM1.CDAY_CAL_DAY_PK_KEY

Line 1641: FROM EDW_TIME_M TIM1,

1637: SET MARGIN_DATE_FK_KEY = MRG.COGS_DATE_FK_KEY,
1638: invoice_date= MRG.ship_date ,
1639: GL_PERIOD_FK_KEY =
1640: (SELECT TIM2.CDAY_CAL_DAY_PK_KEY
1641: FROM EDW_TIME_M TIM1,
1642: EDW_TIME_M TIM2,
1643: EDW_TIME_CAL_PERIOD_LTC PERDLTC
1644: WHERE MRG.SHIP_DATE IS NOT NULL
1645: AND MRG.INVOICE_DATE IS NOT NULL

Line 1642: EDW_TIME_M TIM2,

1638: invoice_date= MRG.ship_date ,
1639: GL_PERIOD_FK_KEY =
1640: (SELECT TIM2.CDAY_CAL_DAY_PK_KEY
1641: FROM EDW_TIME_M TIM1,
1642: EDW_TIME_M TIM2,
1643: EDW_TIME_CAL_PERIOD_LTC PERDLTC
1644: WHERE MRG.SHIP_DATE IS NOT NULL
1645: AND MRG.INVOICE_DATE IS NOT NULL
1646: AND MRG.COGS_DATE_FK_KEY = TIM1.CDAY_CAL_DAY_PK_KEY

Line 1660: FROM EDW_TIME_M TIM1,

1656: UPDATE OPI_EDW_MARGIN_F MRG
1657: SET MARGIN_DATE_FK_KEY = MRG.REVENUE_DATE_FK_KEY,
1658: GL_PERIOD_FK_KEY =
1659: (SELECT TIM2.CDAY_CAL_DAY_PK_KEY
1660: FROM EDW_TIME_M TIM1,
1661: EDW_TIME_M TIM2,
1662: EDW_TIME_CAL_PERIOD_LTC PERDLTC
1663: WHERE MRG.SHIP_DATE is NOT NULL
1664: AND MRG.INVOICE_DATE is NOT NULL

Line 1661: EDW_TIME_M TIM2,

1657: SET MARGIN_DATE_FK_KEY = MRG.REVENUE_DATE_FK_KEY,
1658: GL_PERIOD_FK_KEY =
1659: (SELECT TIM2.CDAY_CAL_DAY_PK_KEY
1660: FROM EDW_TIME_M TIM1,
1661: EDW_TIME_M TIM2,
1662: EDW_TIME_CAL_PERIOD_LTC PERDLTC
1663: WHERE MRG.SHIP_DATE is NOT NULL
1664: AND MRG.INVOICE_DATE is NOT NULL
1665: AND MRG.REVENUE_DATE_FK_KEY = TIM1.CDAY_CAL_DAY_PK_KEY