APPS.EDW_SICM_SIC_HOOK dependencies on POA_DNB_TRD_PRTNR

Line 21: POA_DNB_TRD_PRTNR dnb,

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
25: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));

Line 36: POA_DNB_TRD_PRTNR dnb,

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
40: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));

Line 51: POA_DNB_TRD_PRTNR dnb,

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
55: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));

Line 66: POA_DNB_TRD_PRTNR dnb,

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
70: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));

Line 81: POA_DNB_TRD_PRTNR dnb,

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
85: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));