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

Line 4908: ENG_REVISED_ITEMS ERI

4904: -- EC: BUGFIX 2380517
4905: AND EFFECTIVITY_DATE =(
4906: SELECT MAX (EFFECTIVITY_DATE)
4907: FROM BOM_INVENTORY_COMPONENTS BIC2,
4908: ENG_REVISED_ITEMS ERI
4909: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
4910: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
4911: AND (decode(BIC2.IMPLEMENTATION_DATE,
4912: NULL, BIC2.OLD_COMPONENT_SEQUENCE_ID,

Line 4926: ENG_REVISED_ITEMS ERI1

4922: AND ( NVL(ERI.STATUS_TYPE,6) IN (4,6,7))
4923: AND NOT EXISTS (
4924: SELECT 'X'
4925: FROM BOM_INVENTORY_COMPONENTS BICN,
4926: ENG_REVISED_ITEMS ERI1
4927: WHERE BICN.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
4928: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
4929: BIC.COMPONENT_SEQUENCE_ID
4930: AND BICN.ACD_TYPE in (2,3)

Line 5170: ENG_REVISED_ITEMS ERI

5166: -- EC: BUGFIX 2380517
5167: AND EFFECTIVITY_DATE = (
5168: SELECT MAX(EFFECTIVITY_DATE)
5169: FROM BOM_INVENTORY_COMPONENTS BIC2,
5170: ENG_REVISED_ITEMS ERI
5171: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
5172: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
5173: AND (decode(BIC2.IMPLEMENTATION_DATE,
5174: NULL, BIC2.OLD_COMPONENT_SEQUENCE_ID,

Line 5187: ENG_REVISED_ITEMS ERI1

5183: AND (NVL(ERI.STATUS_TYPE,6) IN (4,6,7))
5184: AND NOT EXISTS (
5185: SELECT 'X'
5186: FROM BOM_INVENTORY_COMPONENTS BICN,
5187: ENG_REVISED_ITEMS ERI1
5188: WHERE BICN.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
5189: AND BICN.OLD_COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
5190: AND BICN.ACD_TYPE in (2,3)
5191: --AND BICN.DISABLE_DATE <= SYSDATE --BUGFIX 2380517