DBA Data[Home] [Help]

APPS.EDW_SICM_INV_LINES_HOOK dependencies on POA_DNB_ITEMS

Line 28: POA_DNB_ITEMS Com

24: set UNSPSC_FK =
25: (select Com.Function
26: from EdW_Item_ItemRev_LTC IRev,
27: EdW_Item_ItemOrg_LTC IOrg,
28: POA_DNB_ITEMS Com
29: where ((Fact.Item_FK = IRev.Item_Revision_PK) and
30: (IOrg.Item_Org_PK=IRev.Item_Org_FK) and
31: (IOrg.Item_Number_FK = Com.Item_PK)))
32: where ((Fact.Collection_Status = 'READY') and

Line 36: POA_DNB_ITEMS Com

32: where ((Fact.Collection_Status = 'READY') and
33: (Fact.Item_FK IN (select IRev.Item_Revision_PK
34: from EdW_Item_ItemRev_LTC IRev,
35: EdW_Item_ItemOrg_LTC IOrg,
36: POA_DNB_ITEMS Com
37: where (IOrg.Item_Number_FK = Com.Item_PK) and
38: (IOrg.Item_Org_PK=IRev.Item_Org_FK))));
39:
40: return true;