APPS.EDW_SICM_SIC_HOOK dependencies on POA_DNB_SIC_CODE

Line 20: from POA_DNB_SIC_CODE Com,

16: from EDW_SICM_SIC_LTC SIC
17: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
18: where (Fact.Supplier_FK_Key IN
19: (select TPartner_Loc_PK_Key
20: from POA_DNB_SIC_CODE Com,
21: POA_DNB_TRD_PRTNR dnb,
22: EDW_TPRT_TPARTNER_LOC_LTC TPrt
23: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
24: (dnb.SIC_CODE = Com.SIC_CODE) and

Line 35: from POA_DNB_SIC_CODE Com,

31: from EDW_SICM_SIC_LTC SIC
32: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
33: where (Fact.Supplier_FK_Key IN
34: (select TPartner_Loc_PK_Key
35: from POA_DNB_SIC_CODE Com,
36: POA_DNB_TRD_PRTNR dnb,
37: EDW_TPRT_TPARTNER_LOC_LTC TPrt
38: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
39: (dnb.SIC_CODE = Com.SIC_CODE) and

Line 50: from POA_DNB_SIC_CODE Com,

46: from EDW_SICM_SIC_LTC SIC
47: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
48: where (Fact.Supplier_FK_Key IN
49: (select TPartner_Loc_PK_Key
50: from POA_DNB_SIC_CODE Com,
51: POA_DNB_TRD_PRTNR dnb,
52: EDW_TPRT_TPARTNER_LOC_LTC TPrt
53: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
54: (dnb.SIC_CODE = Com.SIC_CODE) and

Line 65: from POA_DNB_SIC_CODE Com,

61: from EDW_SICM_SIC_LTC SIC
62: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
63: where (Fact.Supplier_FK_Key IN
64: (select TPartner_Loc_PK_Key
65: from POA_DNB_SIC_CODE Com,
66: POA_DNB_TRD_PRTNR dnb,
67: EDW_TPRT_TPARTNER_LOC_LTC TPrt
68: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
69: (dnb.SIC_CODE = Com.SIC_CODE) and

Line 80: from POA_DNB_SIC_CODE Com,

76: from EDW_SICM_SIC_LTC SIC
77: where (lsic.SIC_CODE_PK = SIC.SIC_CODE_PK))
78: where (Fact.Supplier_FK_Key IN
79: (select TPartner_Loc_PK_Key
80: from POA_DNB_SIC_CODE Com,
81: POA_DNB_TRD_PRTNR dnb,
82: EDW_TPRT_TPARTNER_LOC_LTC TPrt
83: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
84: (dnb.SIC_CODE = Com.SIC_CODE) and