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 POA_DNB_SIC_CODE

Line 25: from POA_DNB_SIC_CODE Com,

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,
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

Line 41: from POA_DNB_SIC_CODE Com,

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,
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

Line 57: from POA_DNB_SIC_CODE Com,

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,
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

Line 73: from POA_DNB_SIC_CODE Com,

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,
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

Line 89: from POA_DNB_SIC_CODE Com,

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,
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

Line 105: from POA_DNB_SIC_CODE Com,

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,
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