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.WSMPWROT dependencies on ENG_REVISED_ITEMS

Line 244: ENG_REVISED_ITEMS ERI

240: AND A.EFFECTIVITY_DATE =
241: (
242: SELECT MAX(EFFECTIVITY_DATE)
243: FROM BOM_INVENTORY_COMPONENTS BIC,
244: ENG_REVISED_ITEMS ERI
245: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
246: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
247: AND (decode(BIC.IMPLEMENTATION_DATE, NULL,
248: BIC.OLD_COMPONENT_SEQUENCE_ID,

Line 261: FROM BOM_INVENTORY_COMPONENTS BICN, ENG_REVISED_ITEMS ERI1

257: ERI.REVISED_ITEM_SEQUENCE_ID(+)
258: AND (nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
259: AND NOT EXISTS
260: (SELECT 'X'
261: FROM BOM_INVENTORY_COMPONENTS BICN, ENG_REVISED_ITEMS ERI1
262: WHERE BICN.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
263: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
264: A.COMPONENT_SEQUENCE_ID
265: AND BICN.ACD_TYPE in (2,3)

Line 770: ENG_REVISED_ITEMS ERI

766: AND A.EFFECTIVITY_DATE =
767: (
768: SELECT MAX(EFFECTIVITY_DATE)
769: FROM BOM_INVENTORY_COMPONENTS BIC,
770: ENG_REVISED_ITEMS ERI
771: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
772: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
773: AND (
774: decode(BIC.IMPLEMENTATION_DATE, NULL,

Line 788: FROM BOM_INVENTORY_COMPONENTS BICN, ENG_REVISED_ITEMS ERI1

784: ERI.REVISED_ITEM_SEQUENCE_ID(+)
785: AND ( nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
786: AND NOT EXISTS
787: (SELECT 'X'
788: FROM BOM_INVENTORY_COMPONENTS BICN, ENG_REVISED_ITEMS ERI1
789: WHERE BICN.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
790: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
791: A.COMPONENT_SEQUENCE_ID
792: AND BICN.ACD_TYPE in (2,3)