eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_SIC_CODE_HOOK dependencies on EDW_TPRT_TPARTNER_LOC_LTC

Line 27: EDW_TPRT_TPARTNER_LOC_LTC TPrt

23: where (Fact.Supplier_Site_FK_Key IN
24: (select TPartner_Loc_PK_Key
25: from POA_DNB_SIC_CODE Com,
26: POA_DNB_TRD_PRTNR dnb,
27: EDW_TPRT_TPARTNER_LOC_LTC TPrt
28: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
29: (dnb.SIC_CODE = Com.SIC_CODE) and
30: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
31:

Line 43: EDW_TPRT_TPARTNER_LOC_LTC TPrt

39: where (Fact.Supplier_Site_FK_Key IN
40: (select TPartner_Loc_PK_Key
41: from POA_DNB_SIC_CODE Com,
42: POA_DNB_TRD_PRTNR dnb,
43: EDW_TPRT_TPARTNER_LOC_LTC TPrt
44: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
45: (dnb.SIC_CODE = Com.SIC_CODE) and
46: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
47:

Line 59: EDW_TPRT_TPARTNER_LOC_LTC TPrt

55: where (Fact.Supplier_Site_FK_Key IN
56: (select TPartner_Loc_PK_Key
57: from POA_DNB_SIC_CODE Com,
58: POA_DNB_TRD_PRTNR dnb,
59: EDW_TPRT_TPARTNER_LOC_LTC TPrt
60: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
61: (dnb.SIC_CODE = Com.SIC_CODE) and
62: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
63:

Line 75: EDW_TPRT_TPARTNER_LOC_LTC TPrt

71: where (Fact.Supplier_Site_FK_Key IN
72: (select TPartner_Loc_PK_Key
73: from POA_DNB_SIC_CODE Com,
74: POA_DNB_TRD_PRTNR dnb,
75: EDW_TPRT_TPARTNER_LOC_LTC TPrt
76: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
77: (dnb.SIC_CODE = Com.SIC_CODE) and
78: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
79:

Line 91: EDW_TPRT_TPARTNER_LOC_LTC TPrt

87: where (Fact.Supplier_Site_FK_Key IN
88: (select TPartner_Loc_PK_Key
89: from POA_DNB_SIC_CODE Com,
90: POA_DNB_TRD_PRTNR dnb,
91: EDW_TPRT_TPARTNER_LOC_LTC TPrt
92: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
93: (dnb.SIC_CODE = Com.SIC_CODE) and
94: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
95:

Line 107: EDW_TPRT_TPARTNER_LOC_LTC TPrt

103: where (Fact.Supplier_Site_FK_Key IN
104: (select TPartner_Loc_PK_Key
105: from POA_DNB_SIC_CODE Com,
106: POA_DNB_TRD_PRTNR dnb,
107: EDW_TPRT_TPARTNER_LOC_LTC TPrt
108: where ((lsic.SIC_CODE_PK = Com.SIC_CODE) and
109: (dnb.SIC_CODE = Com.SIC_CODE) and
110: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
111: