APPS.POA_SIC_CODE_HOOK dependencies on EDW_SICM_SIC_LTC

Line 21: from EDW_SICM_SIC_LTC SIC

17: -- Updating PO Contract Lines
18: Update POA_EDW_ALINES_F Fact
19: set (SIC_CODE_FK_KEY) =
20: (select SIC.SIC_CODE_PK_KEY
21: from EDW_SICM_SIC_LTC SIC
22: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
23: where (Fact.Supplier_Site_FK_Key IN
24: (select TPartner_Loc_PK_Key
25: from POA_DNB_SIC_CODE Com,

Line 37: from EDW_SICM_SIC_LTC SIC

33: -- Updating PO Contract
34: Update POA_EDW_CONTRACT_F Fact
35: set (SIC_CODE_FK_KEY) =
36: (select SIC.SIC_CODE_PK_KEY
37: from EDW_SICM_SIC_LTC SIC
38: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
39: where (Fact.Supplier_Site_FK_Key IN
40: (select TPartner_Loc_PK_Key
41: from POA_DNB_SIC_CODE Com,

Line 53: from EDW_SICM_SIC_LTC SIC

49: -- Updating Custom Measure
50: Update POA_EDW_CSTM_MSR_F Fact
51: set (SIC_CODE_FK_KEY) =
52: (select SIC.SIC_CODE_PK_KEY
53: from EDW_SICM_SIC_LTC SIC
54: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
55: where (Fact.Supplier_Site_FK_Key IN
56: (select TPartner_Loc_PK_Key
57: from POA_DNB_SIC_CODE Com,

Line 69: from EDW_SICM_SIC_LTC SIC

65: -- Updating PO Distributions
66: Update POA_EDW_PO_DIST_F Fact
67: set (SIC_CODE_FK_KEY) =
68: (select SIC.SIC_CODE_PK_KEY
69: from EDW_SICM_SIC_LTC SIC
70: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
71: where (Fact.Supplier_Site_FK_Key IN
72: (select TPartner_Loc_PK_Key
73: from POA_DNB_SIC_CODE Com,

Line 85: from EDW_SICM_SIC_LTC SIC

81: -- Updating Recieving
82: Update POA_EDW_RCV_TXNS_F Fact
83: set (SIC_CODE_FK_KEY) =
84: (select SIC.SIC_CODE_PK_KEY
85: from EDW_SICM_SIC_LTC SIC
86: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
87: where (Fact.Supplier_Site_FK_Key IN
88: (select TPartner_Loc_PK_Key
89: from POA_DNB_SIC_CODE Com,

Line 101: from EDW_SICM_SIC_LTC SIC

97: -- Updating Supplier Performance
98: Update POA_EDW_SUP_PERF_F Fact
99: set (SIC_CODE_FK_KEY) =
100: (select SIC.SIC_CODE_PK_KEY
101: from EDW_SICM_SIC_LTC SIC
102: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
103: where (Fact.Supplier_Site_FK_Key IN
104: (select TPartner_Loc_PK_Key
105: from POA_DNB_SIC_CODE Com,