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 4902: ENG_REVISED_ITEMS ERI

4898: -- EC: BUGFIX 2380517
4899: AND EFFECTIVITY_DATE =(
4900: SELECT MAX (EFFECTIVITY_DATE)
4901: FROM BOM_INVENTORY_COMPONENTS BIC2,
4902: ENG_REVISED_ITEMS ERI
4903: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
4904: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
4905: AND (decode(BIC2.IMPLEMENTATION_DATE,
4906: NULL, BIC2.OLD_COMPONENT_SEQUENCE_ID,

Line 4920: ENG_REVISED_ITEMS ERI1

4916: AND ( NVL(ERI.STATUS_TYPE,6) IN (4,6,7))
4917: AND NOT EXISTS (
4918: SELECT 'X'
4919: FROM BOM_INVENTORY_COMPONENTS BICN,
4920: ENG_REVISED_ITEMS ERI1
4921: WHERE BICN.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
4922: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
4923: BIC.COMPONENT_SEQUENCE_ID
4924: AND BICN.ACD_TYPE in (2,3)

Line 5164: ENG_REVISED_ITEMS ERI

5160: -- EC: BUGFIX 2380517
5161: AND EFFECTIVITY_DATE = (
5162: SELECT MAX(EFFECTIVITY_DATE)
5163: FROM BOM_INVENTORY_COMPONENTS BIC2,
5164: ENG_REVISED_ITEMS ERI
5165: WHERE BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
5166: AND BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
5167: AND (decode(BIC2.IMPLEMENTATION_DATE,
5168: NULL, BIC2.OLD_COMPONENT_SEQUENCE_ID,

Line 5181: ENG_REVISED_ITEMS ERI1

5177: AND (NVL(ERI.STATUS_TYPE,6) IN (4,6,7))
5178: AND NOT EXISTS (
5179: SELECT 'X'
5180: FROM BOM_INVENTORY_COMPONENTS BICN,
5181: ENG_REVISED_ITEMS ERI1
5182: WHERE BICN.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
5183: AND BICN.OLD_COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
5184: AND BICN.ACD_TYPE in (2,3)
5185: --AND BICN.DISABLE_DATE <= SYSDATE --BUGFIX 2380517