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.EDW_POA_DIST_HOOK dependencies on EDW_ITEM_ITEMREV_LTC

Line 15: from EdW_Item_ItemRev_LTC IRev,

11:
12: Update POA_EDW_PO_DIST_FSTG Fact
13: set UNSPSC_FK =
14: (select Com.Function
15: from EdW_Item_ItemRev_LTC IRev,
16: EdW_Item_ItemOrg_LTC IOrg,
17: POA_DNB_ITEMS Com
18: where ((Fact.Item_FK = IRev.Item_Revision_PK) and
19: (Com.Item_PK = IOrg.Item_Number_FK) and

Line 23: from EdW_Item_ItemRev_LTC IRev,

19: (Com.Item_PK = IOrg.Item_Number_FK) and
20: (IOrg.Item_Org_PK = IRev.Item_Org_FK)))
21: where ((Fact.Collection_Status = 'READY') and
22: (Fact.Item_FK IN (select IRev.Item_Revision_PK
23: from EdW_Item_ItemRev_LTC IRev,
24: EdW_Item_ItemOrg_LTC IOrg,
25: POA_DNB_ITEMS Com
26: where (Com.Item_PK = IOrg.Item_Number_FK) and
27: (IOrg.Item_Org_PK = IRev.Item_Org_FK))));