DBA Data[Home] [Help]

APPS.EDW_POA_SUP_PERF_HOOK dependencies on EDW_ITEM_ITEMREV_LTC

Line 14: from EdW_Item_ItemRev_LTC IRev,

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

Line 22: from EdW_Item_ItemRev_LTC IRev,

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