APPS.EDW_SICM_SIC_HOOK dependencies on EDW_TPRT_TPARTNER_LOC_LTC

Line 22: EDW_TPRT_TPARTNER_LOC_LTC TPrt

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))));
26:

Line 37: EDW_TPRT_TPARTNER_LOC_LTC TPrt

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))));
41:

Line 52: EDW_TPRT_TPARTNER_LOC_LTC TPrt

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))));
56:

Line 67: EDW_TPRT_TPARTNER_LOC_LTC TPrt

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))));
71:

Line 82: EDW_TPRT_TPARTNER_LOC_LTC TPrt

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))));
86: END LOOP;