APPS.EDW_POA_RCV_TXNS_HOOK dependencies on EDW_ITEM_ITEMREV_LTC

Line 15: from EdW_Item_ItemRev_LTC IRev,

11:
12: Update POA_EDW_RCV_TXNS_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_Revision_FK = IRev.Item_Revision_PK) and
19: (Com.Item_PK = IOrg.Item_Number_FK) and

Line 24: from EdW_Item_ItemRev_LTC IRev,

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