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_DUNS_M_C dependencies on POA_TPRT_INTERFACE

Line 101: POA_TPRT_INTERFACE dnb

97: Procedure Push_EDW_DNB_TPRT IS
98: CURSOR c_vendors IS
99: select distinct Trade_Partner_FK, Name
100: from EDW_TPRT_TPARTNER_LOC_LTC TPRT,
101: POA_TPRT_INTERFACE dnb
102: where (TPRT.TPartner_Loc_PK = dnb.Trading_Partner_PK);
103:
104: CURSOR c_dnb_failure IS
105: select distinct FAILURE_IND

Line 106: from POA_TPRT_INTERFACE dnb

102: where (TPRT.TPartner_Loc_PK = dnb.Trading_Partner_PK);
103:
104: CURSOR c_dnb_failure IS
105: select distinct FAILURE_IND
106: from POA_TPRT_INTERFACE dnb
107: where (FAILURE_IND IS NOT NULL);
108:
109: CURSOR c_dnb_high_risk IS
110: select distinct HIGH_RISK_INDCATOR

Line 111: from POA_TPRT_INTERFACE dnb

107: where (FAILURE_IND IS NOT NULL);
108:
109: CURSOR c_dnb_high_risk IS
110: select distinct HIGH_RISK_INDCATOR
111: from POA_TPRT_INTERFACE dnb
112: where (HIGH_RISK_INDCATOR IS NOT NULL);
113:
114: CURSOR c_dnb_minority_owned IS
115: select distinct MINORITY_OWNED_IND

Line 116: from POA_TPRT_INTERFACE dnb

112: where (HIGH_RISK_INDCATOR IS NOT NULL);
113:
114: CURSOR c_dnb_minority_owned IS
115: select distinct MINORITY_OWNED_IND
116: from POA_TPRT_INTERFACE dnb
117: where (MINORITY_OWNED_IND IS NOT NULL);
118:
119: CURSOR c_dnb_current_statement IS
120: select distinct CURRENT_STATEMENT_TYPE

Line 121: from POA_TPRT_INTERFACE dnb

117: where (MINORITY_OWNED_IND IS NOT NULL);
118:
119: CURSOR c_dnb_current_statement IS
120: select distinct CURRENT_STATEMENT_TYPE
121: from POA_TPRT_INTERFACE dnb
122: where (CURRENT_STATEMENT_TYPE IS NOT NULL);
123:
124: CURSOR c_dnb_legal_status IS
125: select distinct LEGAL_STATUS

Line 126: from POA_TPRT_INTERFACE dnb

122: where (CURRENT_STATEMENT_TYPE IS NOT NULL);
123:
124: CURSOR c_dnb_legal_status IS
125: select distinct LEGAL_STATUS
126: from POA_TPRT_INTERFACE dnb
127: where (LEGAL_STATUS IS NOT NULL);
128:
129: CURSOR c_dnb_fire_disaster IS
130: select distinct FIRE_DISASTER_IND

Line 131: from POA_TPRT_INTERFACE dnb

127: where (LEGAL_STATUS IS NOT NULL);
128:
129: CURSOR c_dnb_fire_disaster IS
130: select distinct FIRE_DISASTER_IND
131: from POA_TPRT_INTERFACE dnb
132: where (FIRE_DISASTER_IND IS NOT NULL);
133:
134: CURSOR c_dnb_owns_rents IS
135: select distinct OWNS_RENTS_IND

Line 136: from POA_TPRT_INTERFACE dnb

132: where (FIRE_DISASTER_IND IS NOT NULL);
133:
134: CURSOR c_dnb_owns_rents IS
135: select distinct OWNS_RENTS_IND
136: from POA_TPRT_INTERFACE dnb
137: where (OWNS_RENTS_IND IS NOT NULL);
138:
139: CURSOR c_dnb_history IS
140: select distinct HISTORY

Line 141: from POA_TPRT_INTERFACE dnb

137: where (OWNS_RENTS_IND IS NOT NULL);
138:
139: CURSOR c_dnb_history IS
140: select distinct HISTORY
141: from POA_TPRT_INTERFACE dnb
142: where (HISTORY IS NOT NULL);
143:
144: CURSOR c_dnb_location_status IS
145: select distinct LOCATION_STATUS_IND

Line 146: from POA_TPRT_INTERFACE dnb

142: where (HISTORY IS NOT NULL);
143:
144: CURSOR c_dnb_location_status IS
145: select distinct LOCATION_STATUS_IND
146: from POA_TPRT_INTERFACE dnb
147: where (LOCATION_STATUS_IND IS NOT NULL);
148:
149: CURSOR c_dnb_oob IS
150: select distinct OOB_IND

Line 151: from POA_TPRT_INTERFACE dnb

147: where (LOCATION_STATUS_IND IS NOT NULL);
148:
149: CURSOR c_dnb_oob IS
150: select distinct OOB_IND
151: from POA_TPRT_INTERFACE dnb
152: where (OOB_IND IS NOT NULL);
153:
154: CURSOR c_dnb_criminal_proceedings IS
155: select distinct CRIMINAL_PROCEEDINGS_IND

Line 156: from POA_TPRT_INTERFACE dnb

152: where (OOB_IND IS NOT NULL);
153:
154: CURSOR c_dnb_criminal_proceedings IS
155: select distinct CRIMINAL_PROCEEDINGS_IND
156: from POA_TPRT_INTERFACE dnb
157: where (CRIMINAL_PROCEEDINGS_IND IS NOT NULL);
158:
159: CURSOR c_dnb_bankruptcy IS
160: select distinct BANKRUPTCY_IND

Line 161: from POA_TPRT_INTERFACE dnb

157: where (CRIMINAL_PROCEEDINGS_IND IS NOT NULL);
158:
159: CURSOR c_dnb_bankruptcy IS
160: select distinct BANKRUPTCY_IND
161: from POA_TPRT_INTERFACE dnb
162: where (BANKRUPTCY_IND IS NOT NULL);
163:
164: CURSOR c_dnb_business_moved IS
165: select distinct BUSINESS_MOVED_IND

Line 166: from POA_TPRT_INTERFACE dnb

162: where (BANKRUPTCY_IND IS NOT NULL);
163:
164: CURSOR c_dnb_business_moved IS
165: select distinct BUSINESS_MOVED_IND
166: from POA_TPRT_INTERFACE dnb
167: where (BUSINESS_MOVED_IND IS NOT NULL);
168:
169: BEGIN
170:

Line 174: Update POA_TPRT_INTERFACE dnb

170:
171: -- Update the lookup values in the Interface table
172: edw_log.put_line('Updating dnb failure code');
173: For lfailure in c_dnb_failure loop
174: Update POA_TPRT_INTERFACE dnb
175: set (FAILURE_VALUE) =
176: (select Description
177: from fnd_lookups fnd
178: where ((fnd.lookup_code = lfailure.FAILURE_IND) and

Line 183: Update POA_TPRT_INTERFACE dnb

179: (fnd.lookup_type = 'POA_DNB_FAILURE_IND')))
180: where (dnb.FAILURE_IND = lfailure.FAILURE_IND);
181: end loop;
182:
183: Update POA_TPRT_INTERFACE dnb
184: set FAILURE_VALUE = FAILURE_IND
185: where (FAILURE_VALUE IS NULL);
186:
187: edw_log.put_line('Updating Dnb High Risk Code');

Line 189: Update POA_TPRT_INTERFACE dnb

185: where (FAILURE_VALUE IS NULL);
186:
187: edw_log.put_line('Updating Dnb High Risk Code');
188: For lhigh_risk in c_dnb_high_risk loop
189: Update POA_TPRT_INTERFACE dnb
190: set (HIGH_RISK_VALUE) =
191: (select Description
192: from fnd_lookups fnd
193: where ((fnd.lookup_code = lhigh_risk.HIGH_RISK_INDCATOR) and

Line 198: Update POA_TPRT_INTERFACE dnb

194: (fnd.lookup_type = 'POA_DNB_HIGH_RISK_IND')))
195: where (dnb.HIGH_RISK_INDCATOR = lhigh_risk.HIGH_RISK_INDCATOR);
196: end loop;
197:
198: Update POA_TPRT_INTERFACE dnb
199: set HIGH_RISK_VALUE = HIGH_RISK_INDCATOR
200: where (HIGH_RISK_VALUE IS NULL);
201:
202: edw_log.put_line('Updating Minority Code');

Line 204: Update POA_TPRT_INTERFACE dnb

200: where (HIGH_RISK_VALUE IS NULL);
201:
202: edw_log.put_line('Updating Minority Code');
203: For lminority_owned in c_dnb_minority_owned loop
204: Update POA_TPRT_INTERFACE dnb
205: set (MINORITY_OWNED_VALUE) =
206: (select Description
207: from fnd_lookups fnd
208: where ((fnd.lookup_code = lminority_owned.MINORITY_OWNED_IND) and

Line 213: Update POA_TPRT_INTERFACE dnb

209: (fnd.lookup_type = 'POA_DNB_MINORITY_OWNED_TYPE')))
210: where (dnb.MINORITY_OWNED_IND = lminority_owned.MINORITY_OWNED_IND);
211: end loop;
212:
213: Update POA_TPRT_INTERFACE dnb
214: set MINORITY_OWNED_VALUE = MINORITY_OWNED_IND
215: where (MINORITY_OWNED_VALUE IS NULL);
216:
217: edw_log.put_line('Updating DNB Current Statement');

Line 219: Update POA_TPRT_INTERFACE dnb

215: where (MINORITY_OWNED_VALUE IS NULL);
216:
217: edw_log.put_line('Updating DNB Current Statement');
218: For lcurrent_statement in c_dnb_current_statement loop
219: Update POA_TPRT_INTERFACE dnb
220: set (CURRENT_STATEMENT_VALUE) =
221: (select Description
222: from fnd_lookups fnd
223: where ((fnd.lookup_code =

Line 230: Update POA_TPRT_INTERFACE dnb

226: where (dnb.CURRENT_STATEMENT_TYPE =
227: lcurrent_statement.CURRENT_STATEMENT_TYPE);
228: end loop;
229:
230: Update POA_TPRT_INTERFACE dnb
231: set CURRENT_STATEMENT_VALUE = CURRENT_STATEMENT_TYPE
232: where (CURRENT_STATEMENT_VALUE IS NULL);
233:
234: edw_log.put_line('Updating Legal Status');

Line 236: Update POA_TPRT_INTERFACE dnb

232: where (CURRENT_STATEMENT_VALUE IS NULL);
233:
234: edw_log.put_line('Updating Legal Status');
235: For llegal_status in c_dnb_legal_status loop
236: Update POA_TPRT_INTERFACE dnb
237: set (LEGAL_STATUS_VALUE) =
238: (select Description
239: from fnd_lookups fnd
240: where ((fnd.lookup_code = llegal_status.LEGAL_STATUS) and

Line 245: Update POA_TPRT_INTERFACE dnb

241: (fnd.lookup_type = 'POA_DNB_LEGAL_STATUS')))
242: where (dnb.LEGAL_STATUS = llegal_status.LEGAL_STATUS);
243: end loop;
244:
245: Update POA_TPRT_INTERFACE dnb
246: set LEGAL_STATUS_VALUE = LEGAL_STATUS
247: where (LEGAL_STATUS_VALUE IS NULL);
248:
249: edw_log.put_line('Updating Fire Disaster Code');

Line 251: Update POA_TPRT_INTERFACE dnb

247: where (LEGAL_STATUS_VALUE IS NULL);
248:
249: edw_log.put_line('Updating Fire Disaster Code');
250: For lfire_disaster in c_dnb_fire_disaster loop
251: Update POA_TPRT_INTERFACE dnb
252: set (FIRE_DISASTER_VALUE) =
253: (select Description
254: from fnd_lookups fnd
255: where ((fnd.lookup_code = lfire_disaster.FIRE_DISASTER_IND) and

Line 260: Update POA_TPRT_INTERFACE dnb

256: (fnd.lookup_type = 'POA_DNB_FIRE_DISASTER_IND')))
257: where (dnb.FIRE_DISASTER_IND = lfire_disaster.FIRE_DISASTER_IND);
258: end loop;
259:
260: Update POA_TPRT_INTERFACE dnb
261: set FIRE_DISASTER_VALUE = FIRE_DISASTER_IND
262: where (FIRE_DISASTER_VALUE IS NULL);
263:
264: edw_log.put_line('Updating DNB owns/Rents Code');

Line 266: Update POA_TPRT_INTERFACE dnb

262: where (FIRE_DISASTER_VALUE IS NULL);
263:
264: edw_log.put_line('Updating DNB owns/Rents Code');
265: For lowns_rents in c_dnb_owns_rents loop
266: Update POA_TPRT_INTERFACE dnb
267: set (OWNS_RENTS_VALUE) =
268: (select Description
269: from fnd_lookups fnd
270: where ((fnd.lookup_code = lowns_rents.OWNS_RENTS_IND) and

Line 275: Update POA_TPRT_INTERFACE dnb

271: (fnd.lookup_type = 'POA_DNB_OWNS_RENTS_IND')))
272: where (dnb.OWNS_RENTS_IND = lowns_rents.OWNS_RENTS_IND);
273: end loop;
274:
275: Update POA_TPRT_INTERFACE dnb
276: set OWNS_RENTS_VALUE = OWNS_RENTS_IND
277: where (OWNS_RENTS_VALUE IS NULL);
278:
279: edw_log.put_line('Updating History Code');

Line 281: Update POA_TPRT_INTERFACE dnb

277: where (OWNS_RENTS_VALUE IS NULL);
278:
279: edw_log.put_line('Updating History Code');
280: For lhistory in c_dnb_history loop
281: Update POA_TPRT_INTERFACE dnb
282: set (HISTORY_VALUE) =
283: (select Description
284: from fnd_lookups fnd
285: where ((fnd.lookup_code = lhistory.HISTORY) and

Line 290: Update POA_TPRT_INTERFACE dnb

286: (fnd.lookup_type = 'POA_DNB_HISTORY_IND')))
287: where (dnb.HISTORY = lhistory.HISTORY);
288: end loop;
289:
290: Update POA_TPRT_INTERFACE dnb
291: set HISTORY_VALUE = HISTORY
292: where (HISTORY IS NULL);
293:
294: edw_log.put_line('Updating Location Status Code');

Line 296: Update POA_TPRT_INTERFACE dnb

292: where (HISTORY IS NULL);
293:
294: edw_log.put_line('Updating Location Status Code');
295: For llocation_status in c_dnb_location_status loop
296: Update POA_TPRT_INTERFACE dnb
297: set (LOCATION_STATUS_VALUE) =
298: (select Description
299: from fnd_lookups fnd
300: where ((fnd.lookup_code = llocation_status.LOCATION_STATUS_IND) and

Line 305: Update POA_TPRT_INTERFACE dnb

301: (fnd.lookup_type = 'POA_DNB_LOCATION_STATUS')))
302: where (dnb.LOCATION_STATUS_IND = llocation_status.LOCATION_STATUS_IND);
303: end loop;
304:
305: Update POA_TPRT_INTERFACE dnb
306: set LOCATION_STATUS_VALUE = LOCATION_STATUS_IND
307: where (LOCATION_STATUS_VALUE IS NULL);
308:
309: edw_log.put_line('Updating DNB OOB');

Line 311: Update POA_TPRT_INTERFACE dnb

307: where (LOCATION_STATUS_VALUE IS NULL);
308:
309: edw_log.put_line('Updating DNB OOB');
310: For loob in c_dnb_oob loop
311: Update POA_TPRT_INTERFACE dnb
312: set (OOB_VALUE) =
313: (select Description
314: from fnd_lookups fnd
315: where ((fnd.lookup_code = loob.OOB_IND) and

Line 320: Update POA_TPRT_INTERFACE dnb

316: (fnd.lookup_type = 'POA_DNB_OOB_IND')))
317: where (dnb.OOB_IND = loob.OOB_IND);
318: end loop;
319:
320: Update POA_TPRT_INTERFACE dnb
321: set OOB_VALUE = OOB_IND
322: where (OOB_VALUE IS NULL);
323:
324: edw_log.put_line('Updating Criminal Proceedings Code');

Line 326: Update POA_TPRT_INTERFACE dnb

322: where (OOB_VALUE IS NULL);
323:
324: edw_log.put_line('Updating Criminal Proceedings Code');
325: For lcriminal_proceedings in c_dnb_criminal_proceedings loop
326: Update POA_TPRT_INTERFACE dnb
327: set (CRIMINAL_PROCEEDINGS_VALUE) =
328: (select Description
329: from fnd_lookups fnd
330: where ((fnd.lookup_code =

Line 337: Update POA_TPRT_INTERFACE dnb

333: where (dnb.CRIMINAL_PROCEEDINGS_IND =
334: lcriminal_proceedings.CRIMINAL_PROCEEDINGS_IND);
335: end loop;
336:
337: Update POA_TPRT_INTERFACE dnb
338: set CRIMINAL_PROCEEDINGS_VALUE = CRIMINAL_PROCEEDINGS_IND
339: where (CRIMINAL_PROCEEDINGS_VALUE IS NULL);
340:
341: edw_log.put_line('Updating Bankruptcy Code');

Line 343: Update POA_TPRT_INTERFACE dnb

339: where (CRIMINAL_PROCEEDINGS_VALUE IS NULL);
340:
341: edw_log.put_line('Updating Bankruptcy Code');
342: For lbankruptcy in c_dnb_bankruptcy loop
343: Update POA_TPRT_INTERFACE dnb
344: set (BANKRUPTCY_VALUE) =
345: (select Description
346: from fnd_lookups fnd
347: where ((fnd.lookup_code = lbankruptcy.BANKRUPTCY_IND) and

Line 352: Update POA_TPRT_INTERFACE dnb

348: (fnd.lookup_type = 'POA_DNB_BANKRUPTCY_IND')))
349: where (dnb.BANKRUPTCY_IND = lbankruptcy.BANKRUPTCY_IND);
350: end loop;
351:
352: Update POA_TPRT_INTERFACE dnb
353: set BANKRUPTCY_VALUE = BANKRUPTCY_IND
354: where (BANKRUPTCY_VALUE IS NULL);
355:
356: edw_log.put_line('Updating Business Moved Code');

Line 358: Update POA_TPRT_INTERFACE dnb

354: where (BANKRUPTCY_VALUE IS NULL);
355:
356: edw_log.put_line('Updating Business Moved Code');
357: For lbusiness_moved in c_dnb_business_moved loop
358: Update POA_TPRT_INTERFACE dnb
359: set (BUSINESS_MOVED_VALUE) =
360: (select Description
361: from fnd_lookups fnd
362: where ((fnd.lookup_code = lbusiness_moved.BUSINESS_MOVED_IND) and

Line 367: Update POA_TPRT_INTERFACE dnb

363: (fnd.lookup_type = 'POA_DNB_BUSINESS_MOVED_IND')))
364: where (dnb.BUSINESS_MOVED_IND = lbusiness_moved.BUSINESS_MOVED_IND);
365: end loop;
366:
367: Update POA_TPRT_INTERFACE dnb
368: set BUSINESS_MOVED_VALUE = BUSINESS_MOVED_IND
369: where (BUSINESS_MOVED_VALUE IS NULL);
370:
371: -- Update Trading Partner Vendor Sites (Lowest Level)

Line 389: sysdate from POA_TPRT_INTERFACE dnb

385: TRADING_PARTNER_NAME,
386: DUNS,
387: SIC_CODE_1,
388: sysdate,
389: sysdate from POA_TPRT_INTERFACE dnb
390: where (poa.TRADING_PARTNER_PK = dnb.TRADING_PARTNER_PK))
391: where TRADING_PARTNER_PK IN
392: (select TRADING_PARTNER_PK
393: from POA_TPRT_INTERFACE dnb

Line 393: from POA_TPRT_INTERFACE dnb

389: sysdate from POA_TPRT_INTERFACE dnb
390: where (poa.TRADING_PARTNER_PK = dnb.TRADING_PARTNER_PK))
391: where TRADING_PARTNER_PK IN
392: (select TRADING_PARTNER_PK
393: from POA_TPRT_INTERFACE dnb
394: where ((poa.TRADING_PARTNER_PK = dnb.TRADING_PARTNER_PK) and
395: ((poa.DUNS <> dnb.DUNS) OR
396: (poa.SIC_CODE <> dnb.SIC_CODE_1))));
397:

Line 414: sysdate from POA_TPRT_INTERFACE dnb

410: DUNS,
411: SIC_CODE_1,
412: sysdate,
413: sysdate,
414: sysdate from POA_TPRT_INTERFACE dnb
415: where NOT EXISTS
416: (select 'X' FROM
417: POA_DNB_TRD_PRTNR pdtp
418: where ltrim(rtrim(pdtp.TRADING_PARTNER_PK)) IS NOT NULL

Line 430: -- Also, the duns interface table poa_tprt_interface has only

426: -- and not returning any rows in their trace file
427: -- Looks like the vendor_site cursor is not going to return any
428: -- rows since tprt.tpartner_loc_pk and lvendor.trade_partner_fk
429: -- are not going to match because of the way there are constructed
430: -- Also, the duns interface table poa_tprt_interface has only
431: -- supplier site level records
432:
433: -- Update Trading Partner Vendors (Higher levels)
434: edw_log.put_line('Update Trading Partner Vendors (Higher levels)');

Line 441: POA_TPRT_INTERFACE dnb

437: DECLARE
438: CURSOR c_vendor_site IS
439: select Trade_Partner_FK, Global_Ult_Duns
440: from EDW_TPRT_TPARTNER_LOC_LTC TPRT,
441: POA_TPRT_INTERFACE dnb
442: where ((TPRT.TPartner_Loc_PK = lvendor.Trade_Partner_FK) and
443: (dnb.Trading_Partner_PK = TPRT.Trade_Partner_FK));
444: BEGIN
445: For lvsite in c_vendor_site loop

Line 454: POA_TPRT_INTERFACE dnb

450: DNB_Update_Date = sysdate
451: where Trading_Partner_PK IN
452: (select Trade_Partner_FK
453: from EDW_TPRT_TPARTNER_LOC_LTC TPRT,
454: POA_TPRT_INTERFACE dnb
455: where ((poa.TRADING_PARTNER_PK = lvendor.Trade_Partner_FK) and
456: (poa.DUNS <> lvsite.Global_Ult_Duns)));
457:
458: edw_log.put_line('Update of Trading Partner Vendor complete');

Line 491: sysdate from POA_TPRT_INTERFACE dnb

487: SIC_Description,
488: DNB_Update_Date) =
489: (select distinct SIC_CODE_1,
490: SIC_1_DESCRIPTION,
491: sysdate from POA_TPRT_INTERFACE dnb
492: where (poa.SIC_Code = dnb.SIC_CODE_1))
493: where SIC_Code IN
494: (select SIC_CODE_1
495: from POA_TPRT_INTERFACE dnb

Line 495: from POA_TPRT_INTERFACE dnb

491: sysdate from POA_TPRT_INTERFACE dnb
492: where (poa.SIC_Code = dnb.SIC_CODE_1))
493: where SIC_Code IN
494: (select SIC_CODE_1
495: from POA_TPRT_INTERFACE dnb
496: where ((poa.SIC_Code = dnb.SIC_CODE_1) and
497: (poa.SIC_Description <> dnb.SIC_1_DESCRIPTION)));
498:
499: edw_log.put_line('Inserting SIC Code');

Line 506: sysdate from POA_TPRT_INTERFACE dnb

502: SIC_Description,
503: DNB_Update_Date)
504: (select distinct SIC_CODE_1,
505: SIC_1_DESCRIPTION,
506: sysdate from POA_TPRT_INTERFACE dnb
507: where NOT EXISTS
508: (select 'X'
509: from POA_DNB_SIC_CODE pdsc
510: where ltrim(rtrim(SIC_Code)) IS NOT NULL

Line 801: from POA_TPRT_INTERFACE dnb,

797: NULL,
798: sysdate,
799: 'READY',
800: decode(greatest(poa.dnb_update_date,g_start_time), poa.dnb_update_date, decode(greatest(poa.dnb_update_date, sysdate), sysdate, 'Y', 'N'), 'N')
801: from POA_TPRT_INTERFACE dnb,
802: POA_DNB_TRD_PRTNR poa
803: where (dnb.TRADING_PARTNER_PK = poa.TRADING_PARTNER_PK);
804:
805: l_rows_inserted := sql%rowcount;

Line 862: from POA_TPRT_INTERFACE dnb

858: NVL(ltrim(rtrim(GLOBAL_ULT_DUNS)), 'NA_EDW'),
859: NULL,
860: sysdate,
861: 'READY'
862: from POA_TPRT_INTERFACE dnb
863: where EXISTS (select 'X'
864: from POA_TPRT_INTERFACE pti
865: where ltrim(rtrim(PARENT_DUNS)) IS NOT NULL
866: and dnb.PARENT_DUNS = pti.PARENT_DUNS);

Line 864: from POA_TPRT_INTERFACE pti

860: sysdate,
861: 'READY'
862: from POA_TPRT_INTERFACE dnb
863: where EXISTS (select 'X'
864: from POA_TPRT_INTERFACE pti
865: where ltrim(rtrim(PARENT_DUNS)) IS NOT NULL
866: and dnb.PARENT_DUNS = pti.PARENT_DUNS);
867:
868: l_rows_inserted := sql%rowcount;

Line 902: from POA_TPRT_INTERFACE dnb

898: NVL(ltrim(rtrim(GLOBAL_ULT_DUNS)), 'NA_EDW'),
899: NULL,
900: sysdate,
901: 'READY'
902: from POA_TPRT_INTERFACE dnb
903: where (ltrim(rtrim(PARENT_DUNS)) IS NULL);
904:
905: l_rows_inserted := l_rows_inserted + sql%rowcount;
906: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;

Line 958: from POA_TPRT_INTERFACE dnb

954: NVL(ltrim(rtrim(GLOBAL_ULT_DUNS)), 'NA_EDW'),
955: NULL,
956: sysdate,
957: 'READY'
958: from POA_TPRT_INTERFACE dnb
959: where EXISTS (select 'X'
960: from POA_TPRT_INTERFACE pti
961: where ltrim(rtrim(DOMESTIC_ULT_DUNS)) IS NOT NULL
962: and dnb.DOMESTIC_ULT_DUNS = pti.DOMESTIC_ULT_DUNS);

Line 960: from POA_TPRT_INTERFACE pti

956: sysdate,
957: 'READY'
958: from POA_TPRT_INTERFACE dnb
959: where EXISTS (select 'X'
960: from POA_TPRT_INTERFACE pti
961: where ltrim(rtrim(DOMESTIC_ULT_DUNS)) IS NOT NULL
962: and dnb.DOMESTIC_ULT_DUNS = pti.DOMESTIC_ULT_DUNS);
963:
964: l_rows_inserted := sql%rowcount;

Line 997: from POA_TPRT_INTERFACE dnb

993: NVL(ltrim(rtrim(GLOBAL_ULT_DUNS)), 'NA_EDW'),
994: NULL,
995: sysdate,
996: 'READY'
997: from POA_TPRT_INTERFACE dnb
998: where (ltrim(rtrim(DOMESTIC_ULT_DUNS)) IS NULL);
999:
1000: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1001: edw_log.put_line('Commiting records for EDW_DUNS_DOMESTIC_LSTG');

Line 1052: from POA_TPRT_INTERFACE dnb;

1048: 'ALL',
1049: NULL,
1050: sysdate,
1051: 'READY'
1052: from POA_TPRT_INTERFACE dnb;
1053:
1054: l_rows_inserted := sql%rowcount;
1055: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1056: edw_log.put_line('Commiting records for EDW_DUNS_GLOBAL_LSTG');

Line 1090: from POA_TPRT_INTERFACE dnb

1086: NVL(ltrim(rtrim(GLOBAL_ULT_DUNS)), 'NA_EDW'),
1087: NULL,
1088: sysdate,
1089: 'READY'
1090: from POA_TPRT_INTERFACE dnb
1091: where (NOT EXISTS (select 'X'
1092: from POA_TPRT_INTERFACE pti
1093: where ltrim(rtrim(DOMESTIC_ULT_DUNS)) IS NOT NULL
1094: and dnb.GLOBAL_ULT_DUNS = pti.DOMESTIC_ULT_DUNS

Line 1092: from POA_TPRT_INTERFACE pti

1088: sysdate,
1089: 'READY'
1090: from POA_TPRT_INTERFACE dnb
1091: where (NOT EXISTS (select 'X'
1092: from POA_TPRT_INTERFACE pti
1093: where ltrim(rtrim(DOMESTIC_ULT_DUNS)) IS NOT NULL
1094: and dnb.GLOBAL_ULT_DUNS = pti.DOMESTIC_ULT_DUNS
1095: UNION ALL
1096: select 'X'

Line 1097: from POA_TPRT_INTERFACE pti

1093: where ltrim(rtrim(DOMESTIC_ULT_DUNS)) IS NOT NULL
1094: and dnb.GLOBAL_ULT_DUNS = pti.DOMESTIC_ULT_DUNS
1095: UNION ALL
1096: select 'X'
1097: from POA_TPRT_INTERFACE pti
1098: where ltrim(rtrim(DUNS)) IS NOT NULL
1099: and dnb.GLOBAL_ULT_DUNS = pti.DUNS));
1100:
1101: l_rows_inserted := sql%rowcount;

Line 1136: from POA_TPRT_INTERFACE dnb

1132: NVL(ltrim(rtrim(GLOBAL_ULT_DUNS)), 'NA_EDW'),
1133: NULL,
1134: sysdate,
1135: 'READY'
1136: from POA_TPRT_INTERFACE dnb
1137: where (NOT EXISTS (select 'X'
1138: from POA_TPRT_INTERFACE pti
1139: where (ltrim(rtrim(HQ_DUNS)) IS NOT NULL)
1140: and dnb.GLOBAL_ULT_DUNS = pti.HQ_DUNS

Line 1138: from POA_TPRT_INTERFACE pti

1134: sysdate,
1135: 'READY'
1136: from POA_TPRT_INTERFACE dnb
1137: where (NOT EXISTS (select 'X'
1138: from POA_TPRT_INTERFACE pti
1139: where (ltrim(rtrim(HQ_DUNS)) IS NOT NULL)
1140: and dnb.GLOBAL_ULT_DUNS = pti.HQ_DUNS
1141: UNION ALL
1142: select 'X'

Line 1143: from POA_TPRT_INTERFACE pti

1139: where (ltrim(rtrim(HQ_DUNS)) IS NOT NULL)
1140: and dnb.GLOBAL_ULT_DUNS = pti.HQ_DUNS
1141: UNION ALL
1142: select 'X'
1143: from POA_TPRT_INTERFACE pti
1144: where (ltrim(rtrim(DUNS)) IS NOT NULL)
1145: and dnb.GLOBAL_ULT_DUNS = pti.DUNS));
1146:
1147: l_rows_inserted := sql%rowcount;

Line 1182: from POA_TPRT_INTERFACE dnb

1178: NVL(ltrim(rtrim(GLOBAL_ULT_DUNS)), 'NA_EDW'),
1179: NULL,
1180: sysdate,
1181: 'READY'
1182: from POA_TPRT_INTERFACE dnb
1183: where (NOT EXISTS (select 'X'
1184: from POA_TPRT_INTERFACE pti
1185: where (ltrim(rtrim(PARENT_DUNS)) IS NOT NULL)
1186: and dnb.GLOBAL_ULT_DUNS = pti.PARENT_DUNS

Line 1184: from POA_TPRT_INTERFACE pti

1180: sysdate,
1181: 'READY'
1182: from POA_TPRT_INTERFACE dnb
1183: where (NOT EXISTS (select 'X'
1184: from POA_TPRT_INTERFACE pti
1185: where (ltrim(rtrim(PARENT_DUNS)) IS NOT NULL)
1186: and dnb.GLOBAL_ULT_DUNS = pti.PARENT_DUNS
1187: UNION ALL
1188: select 'X'

Line 1189: from POA_TPRT_INTERFACE pti

1185: where (ltrim(rtrim(PARENT_DUNS)) IS NOT NULL)
1186: and dnb.GLOBAL_ULT_DUNS = pti.PARENT_DUNS
1187: UNION ALL
1188: select 'X'
1189: from POA_TPRT_INTERFACE pti
1190: where (ltrim(rtrim(DUNS)) IS NOT NULL)
1191: and dnb.GLOBAL_ULT_DUNS = pti.DUNS));
1192:
1193: l_rows_inserted := sql%rowcount;

Line 1300: from POA_TPRT_INTERFACE dnb,

1296: NULL,
1297: sysdate,
1298: 'READY',
1299: 'N'
1300: from POA_TPRT_INTERFACE dnb,
1301: POA_DNB_TRD_PRTNR poa
1302: where ((dnb.TRADING_PARTNER_PK = poa.TRADING_PARTNER_PK) and
1303: (NOT EXISTS (select 'X'
1304: from POA_TPRT_INTERFACE pti

Line 1304: from POA_TPRT_INTERFACE pti

1300: from POA_TPRT_INTERFACE dnb,
1301: POA_DNB_TRD_PRTNR poa
1302: where ((dnb.TRADING_PARTNER_PK = poa.TRADING_PARTNER_PK) and
1303: (NOT EXISTS (select 'X'
1304: from POA_TPRT_INTERFACE pti
1305: where (ltrim(rtrim(DUNS)) IS NOT NULL)
1306: and dnb.GLOBAL_ULT_DUNS = pti.DUNS)));
1307:
1308: l_rows_inserted := sql%rowcount;

Line 1361: from POA_TPRT_INTERFACE dnb

1357: NVL(ltrim(rtrim(GLOBAL_ULT_DUNS)), 'NA_EDW'),
1358: NULL,
1359: sysdate,
1360: 'READY'
1361: from POA_TPRT_INTERFACE dnb
1362: where EXISTS (select 'X'
1363: from POA_TPRT_INTERFACE pti
1364: where (ltrim(rtrim(HQ_DUNS)) IS NOT NULL)
1365: and dnb.HQ_DUNS = pti.HQ_DUNS);

Line 1363: from POA_TPRT_INTERFACE pti

1359: sysdate,
1360: 'READY'
1361: from POA_TPRT_INTERFACE dnb
1362: where EXISTS (select 'X'
1363: from POA_TPRT_INTERFACE pti
1364: where (ltrim(rtrim(HQ_DUNS)) IS NOT NULL)
1365: and dnb.HQ_DUNS = pti.HQ_DUNS);
1366:
1367: l_rows_inserted := sql%rowcount;

Line 1400: from POA_TPRT_INTERFACE dnb

1396: NVL(ltrim(rtrim(GLOBAL_ULT_DUNS)), 'NA_EDW'),
1397: NULL,
1398: sysdate,
1399: 'READY'
1400: from POA_TPRT_INTERFACE dnb
1401: where (ltrim(rtrim(HQ_DUNS)) IS NULL);
1402:
1403: EDW_DUNS_M_C.g_row_count := EDW_DUNS_M_C.g_row_count + l_rows_inserted ;
1404: edw_log.put_line('Commiting records for EDW_DUNS_HEADQTR_LSTG');