APPS.EDW_POA_UNSPSC_HOOK dependencies on EDW_ITEM_ITEMORG_LTC

Line 26: EdW_Item_ItemOrg_LTC IOrg

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
29: (IOrg.Item_Org_PK = IRev.Item_Org_FK))));
30:

Line 41: EdW_Item_ItemOrg_LTC IOrg

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
44: (IOrg.Item_Org_PK = IRev.Item_Org_FK))));
45:

Line 56: EdW_Item_ItemOrg_LTC IOrg

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
59: (IOrg.Item_Org_PK = IRev.Item_Org_FK))));
60:

Line 72: EdW_Item_ItemOrg_LTC IOrg

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
75: (IOrg.Item_Org_PK = IRev.Item_Org_FK))));
76:

Line 88: EdW_Item_ItemOrg_LTC IOrg

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
91: (IOrg.Item_Org_PK = IRev.Item_Org_FK))));
92: