APPS.EDW_SICM_UNSPSC_HOOK dependencies on EDW_ITEM_ITEMREV_LTC

Line 20: EdW_Item_ItemRev_LTC IRev,

16: where (litem.Function_PK = UNSPSC.Function_PK))
17: where (Fact.Item_FK_Key IN
18: (select IRev.Item_Revision_PK_Key
19: from POA_DNB_ITEMS Com,
20: EdW_Item_ItemRev_LTC IRev,
21: EdW_Item_ItemOrg_LTC IOrg
22: where ((litem.Function_PK = Com.Function) and
23: (Com.Item_PK = IOrg.Item_Number_FK) and
24: (IOrg.Item_Org_PK = IRev.Item_Org_FK))));