APPS.EDW_POA_UNSPSC_HOOK dependencies on POA_DNB_ITEMS

Line 24: from POA_DNB_ITEMS Com,

20: from EDW_SPSC_FUNCTION_LTC UNSPSC
21: where (litem.Function_PK = UNSPSC.Function_PK))
22: where (Fact.Item_FK_Key IN
23: (select IRev.Item_Revision_PK_Key
24: from POA_DNB_ITEMS Com,
25: EdW_Item_ItemRev_LTC IRev,
26: EdW_Item_ItemOrg_LTC IOrg
27: where ((litem.Function_PK = Com.Function) and
28: (Com.Item_PK = IOrg.Item_Number_FK) and

Line 39: from POA_DNB_ITEMS Com,

35: from EDW_SPSC_FUNCTION_LTC UNSPSC
36: where (litem.Function_PK = UNSPSC.Function_PK))
37: where (Fact.Item_Revision_FK_Key IN
38: (select IRev.Item_Revision_PK_Key
39: from POA_DNB_ITEMS Com,
40: EdW_Item_ItemRev_LTC IRev,
41: EdW_Item_ItemOrg_LTC IOrg
42: where ((litem.Function_PK = Com.Function) and
43: (Com.Item_PK = IOrg.Item_Number_FK) and

Line 54: from POA_DNB_ITEMS Com,

50: from EDW_SPSC_FUNCTION_LTC UNSPSC
51: where (litem.Function_PK = UNSPSC.Function_PK))
52: where (Fact.Item_Revision_FK_Key IN
53: (select IRev.Item_Revision_PK_Key
54: from POA_DNB_ITEMS Com,
55: EdW_Item_ItemRev_LTC IRev,
56: EdW_Item_ItemOrg_LTC IOrg
57: where ((litem.Function_PK = Com.Function) and
58: (Com.Item_PK = IOrg.Item_Number_FK) and

Line 70: from POA_DNB_ITEMS Com,

66: from EDW_SPSC_FUNCTION_LTC UNSPSC
67: where (litem.Function_PK = UNSPSC.Function_PK))
68: where (Fact.Item_FK_Key IN
69: (select IRev.Item_Revision_PK_Key
70: from POA_DNB_ITEMS Com,
71: EdW_Item_ItemRev_LTC IRev,
72: EdW_Item_ItemOrg_LTC IOrg
73: where ((litem.Function_PK = Com.Function) and
74: (Com.Item_PK = IOrg.Item_Number_FK) and

Line 86: from POA_DNB_ITEMS Com,

82: from EDW_SPSC_FUNCTION_LTC UNSPSC
83: where (litem.Function_PK = UNSPSC.Function_PK))
84: where (Fact.Item_FK_Key IN
85: (select IRev.Item_Revision_PK_Key
86: from POA_DNB_ITEMS Com,
87: EdW_Item_ItemRev_LTC IRev,
88: EdW_Item_ItemOrg_LTC IOrg
89: where ((litem.Function_PK = Com.Function) and
90: (Com.Item_PK = IOrg.Item_Number_FK) and