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.OE_CANCEL dependencies on BOM_EXPLOSIONS

Line 1627: FROM BOM_EXPLOSIONS

1623: IF (LOAD_BOM_RESULT = 1) THEN
1624:
1625: SELECT COUNT(*)
1626: INTO DUMMY2
1627: FROM BOM_EXPLOSIONS
1628: WHERE TOP_BILL_SEQUENCE_ID = V_TOP_BILL_SEQUENCE_ID
1629: AND EXPLOSION_TYPE = 'OPTIONAL'
1630: AND PLAN_LEVEL >= 0
1631: AND EFFECTIVITY_DATE <= TO_DATE(

Line 1657: FROM BOM_EXPLOSIONS

1653: END IF;
1654:
1655: SELECT COUNT(*)
1656: INTO DUMMY3
1657: FROM BOM_EXPLOSIONS
1658: WHERE TOP_BILL_SEQUENCE_ID = V_TOP_BILL_SEQUENCE_ID
1659: AND EXPLOSION_TYPE = 'OPTIONAL'
1660: AND PLAN_LEVEL >= 0
1661: AND EFFECTIVITY_DATE <= TO_DATE(NVL(substr(V_CREATION_DATE_TIME, 1, 16),

Line 1690: FROM BOM_EXPLOSIONS

1686: -- 'ORDERED QUANTITY OUT OF BOM RANGE'
1687:
1688: SELECT COUNT(*)
1689: INTO DUMMY4
1690: FROM BOM_EXPLOSIONS
1691: WHERE TOP_BILL_SEQUENCE_ID = V_TOP_BILL_SEQUENCE_ID
1692: AND EXPLOSION_TYPE = 'OPTIONAL'
1693: AND PLAN_LEVEL >= 0
1694: AND EFFECTIVITY_DATE <= TO_DATE(NVL(substr(V_CREATION_DATE_TIME, 1, 16),