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.EDW_POA_DUNS_HOOK dependencies on EDW_DUNS_NUMBER_LTC

Line 21: from EDW_DUNS_NUMBER_LTC DUNS

17: -- Updating PO Contract Lines
18: Update POA_EDW_ALINES_F Fact
19: set (DUNS_FK_KEY) =
20: (select DUNS.DUNS_NUM_PK_KEY
21: from EDW_DUNS_NUMBER_LTC DUNS
22: where (lduns.DUNS_NUM_PK = DUNS.DUNS_NUM_PK))
23: where (Fact.Supplier_Site_FK_Key IN
24: (select TPartner_Loc_PK_Key
25: from POA_DNB_TRD_PRTNR Com,

Line 35: from EDW_DUNS_NUMBER_LTC DUNS

31: -- Updating PO Contract
32: Update POA_EDW_CONTRACT_F Fact
33: set (DUNS_FK_KEY) =
34: (select DUNS.DUNS_NUM_PK_KEY
35: from EDW_DUNS_NUMBER_LTC DUNS
36: where (lduns.DUNS_NUM_PK = DUNS.DUNS_NUM_PK))
37: where (Fact.Supplier_Site_FK_Key IN
38: (select TPartner_Loc_PK_Key
39: from POA_DNB_TRD_PRTNR Com,

Line 48: from EDW_DUNS_NUMBER_LTC DUNS

44: -- Updating Custom Measure
45: Update POA_EDW_CSTM_MSR_F Fact
46: set (DUNS_FK_KEY) =
47: (select DUNS.DUNS_NUM_PK_KEY
48: from EDW_DUNS_NUMBER_LTC DUNS
49: where (lduns.DUNS_NUM_PK = DUNS.DUNS_NUM_PK))
50: where (Fact.Supplier_Site_FK_Key IN
51: (select TPartner_Loc_PK_Key
52: from POA_DNB_TRD_PRTNR Com,

Line 61: from EDW_DUNS_NUMBER_LTC DUNS

57: -- Updating PO Distributions
58: Update POA_EDW_PO_DIST_F Fact
59: set (DUNS_FK_KEY) =
60: (select DUNS.DUNS_NUM_PK_KEY
61: from EDW_DUNS_NUMBER_LTC DUNS
62: where (lduns.DUNS_NUM_PK = DUNS.DUNS_NUM_PK))
63: where (Fact.Supplier_Site_FK_Key IN
64: (select TPartner_Loc_PK_Key
65: from POA_DNB_TRD_PRTNR Com,

Line 74: from EDW_DUNS_NUMBER_LTC DUNS

70: -- Updating Recieving
71: Update POA_EDW_RCV_TXNS_F Fact
72: set (DUNS_FK_KEY) =
73: (select DUNS.DUNS_NUM_PK_KEY
74: from EDW_DUNS_NUMBER_LTC DUNS
75: where (lduns.DUNS_NUM_PK = DUNS.DUNS_NUM_PK))
76: where (Fact.Supplier_Site_FK_Key IN
77: (select TPartner_Loc_PK_Key
78: from POA_DNB_TRD_PRTNR Com,

Line 87: from EDW_DUNS_NUMBER_LTC DUNS

83: -- Updating Supplier Performance
84: Update POA_EDW_SUP_PERF_F Fact
85: set (DUNS_FK_KEY) =
86: (select DUNS.DUNS_NUM_PK_KEY
87: from EDW_DUNS_NUMBER_LTC DUNS
88: where (lduns.DUNS_NUM_PK = DUNS.DUNS_NUM_PK))
89: where (Fact.Supplier_Site_FK_Key IN
90: (select TPartner_Loc_PK_Key
91: from POA_DNB_TRD_PRTNR Com,