APPS.EDW_POA_UNSPSC_HOOK dependencies on EDW_SPSC_FUNCTION_LTC

Line 20: from EDW_SPSC_FUNCTION_LTC UNSPSC

16: -- Updating Distribution fact
17: Update POA_EDW_PO_DIST_F Fact
18: set (UNSPSC_FK_Key) =
19: (select UNSPSC.Function_PK_Key
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,

Line 35: from EDW_SPSC_FUNCTION_LTC UNSPSC

31: -- Update Receiving Fact
32: Update POA_EDW_RCV_TXNS_F Fact
33: set (UNSPSC_FK_Key) =
34: (select UNSPSC.Function_PK_Key
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,

Line 50: from EDW_SPSC_FUNCTION_LTC UNSPSC

46: -- Update PO Agreement Lines
47: Update POA_EDW_ALINES_F Fact
48: set (UNSPSC_FK_Key) =
49: (select UNSPSC.Function_PK_Key
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,

Line 66: from EDW_SPSC_FUNCTION_LTC UNSPSC

62: -- Update Cutomer Measure Fact
63: Update POA_EDW_CSTM_MSR_F Fact
64: set (UNSPSC_FK_Key) =
65: (select UNSPSC.Function_PK_Key
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,

Line 82: from EDW_SPSC_FUNCTION_LTC UNSPSC

78: -- Update Supplier Performance
79: Update POA_EDW_SUP_PERF_F Fact
80: set (UNSPSC_FK_Key) =
81: (select UNSPSC.Function_PK_Key
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,