APPS.EDW_POA_DUNS_HOOK dependencies on POA_DNB_TRD_PRTNR

Line 25: from POA_DNB_TRD_PRTNR Com,

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,
26: EDW_TPRT_TPARTNER_LOC_LTC TPrt
27: where ((lduns.DUNS_NUM_PK = Com.DUNS) and
28: (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));
29:

Line 39: from POA_DNB_TRD_PRTNR Com,

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,
40: EDW_TPRT_TPARTNER_LOC_LTC TPrt
41: where ((lduns.DUNS_NUM_PK = Com.DUNS) and
42: (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));
43:

Line 52: from POA_DNB_TRD_PRTNR Com,

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,
53: EDW_TPRT_TPARTNER_LOC_LTC TPrt
54: where ((lduns.DUNS_NUM_PK = Com.DUNS) and
55: (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));
56:

Line 65: from POA_DNB_TRD_PRTNR Com,

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,
66: EDW_TPRT_TPARTNER_LOC_LTC TPrt
67: where ((lduns.DUNS_NUM_PK = Com.DUNS) and
68: (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));
69:

Line 78: from POA_DNB_TRD_PRTNR Com,

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,
79: EDW_TPRT_TPARTNER_LOC_LTC TPrt
80: where ((lduns.DUNS_NUM_PK = Com.DUNS) and
81: (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));
82:

Line 91: from POA_DNB_TRD_PRTNR Com,

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,
92: EDW_TPRT_TPARTNER_LOC_LTC TPrt
93: where ((lduns.DUNS_NUM_PK = Com.DUNS) and
94: (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));
95: