APPS.EDW_DUNS_M_C dependencies on POA_DNB_TRD_PRTNR

Line 377: Update POA_DNB_TRD_PRTNR poa

373: edw_log.put_line('Update Trading Partner Vendor Sites (Lowest Level)');
374:
375: g_start_time := sysdate;
376:
377: Update POA_DNB_TRD_PRTNR poa
378: set (TRADING_PARTNER_PK,
379: TRADING_PARTNER_NAME,
380: DUNS,
381: SIC_CODE,

Line 400: insert into POA_DNB_TRD_PRTNR poa (

396: (poa.SIC_CODE <> dnb.SIC_CODE_1))));
397:
398: edw_log.put_line('Update of Trading Partner Vendor Sites complete');
399: edw_log.put_line('Insert Trading Partner Vendor Sites (Lowest Level)');
400: insert into POA_DNB_TRD_PRTNR poa (
401: TRADING_PARTNER_PK,
402: TRADING_PARTNER_NAME,
403: DUNS,
404: SIC_CODE,

Line 417: POA_DNB_TRD_PRTNR pdtp

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
419: and dnb.TRADING_PARTNER_PK = pdtp.TRADING_PARTNER_PK);
420:
421: edw_log.put_line('Insert of Trading Partner Vendor Sites complete');

Line 446: Update POA_DNB_TRD_PRTNR poa

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
446: Update POA_DNB_TRD_PRTNR poa
447: set TRADING_PARTNER_PK = lvendor.Trade_Partner_FK,
448: TRADING_PARTNER_NAME = lvendor.Name,
449: DUNS = lvsite.Global_Ult_Duns,
450: DNB_Update_Date = sysdate

Line 461: Insert into POA_DNB_TRD_PRTNR poa (

457:
458: edw_log.put_line('Update of Trading Partner Vendor complete');
459: edw_log.put_line('Insert Trading Partner Vendors (Higher levels)');
460:
461: Insert into POA_DNB_TRD_PRTNR poa (
462: TRADING_PARTNER_PK,
463: TRADING_PARTNER_NAME,
464: DUNS,
465: DNB_Update_Date)

Line 470: from POA_DNB_TRD_PRTNR

466: select lvendor.Trade_Partner_FK,
467: lvendor.Name,
468: lvsite.Global_Ult_Duns,
469: sysdate
470: from POA_DNB_TRD_PRTNR
471: where NOT EXISTS
472: (select 'X'
473: from POA_DNB_TRD_PRTNR pdtp
474: where ltrim(rtrim(Trading_Partner_PK)) IS NOT NULL

Line 473: from POA_DNB_TRD_PRTNR pdtp

469: sysdate
470: from POA_DNB_TRD_PRTNR
471: where NOT EXISTS
472: (select 'X'
473: from POA_DNB_TRD_PRTNR pdtp
474: where ltrim(rtrim(Trading_Partner_PK)) IS NOT NULL
475: and pdtp.Trading_Partner_PK = lvendor.Trade_Partner_FK);
476: edw_log.put_line('Insert of Trading Partner Vendor complete');
477: exit;

Line 802: POA_DNB_TRD_PRTNR poa

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;
806:

Line 1301: POA_DNB_TRD_PRTNR poa

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
1305: where (ltrim(rtrim(DUNS)) IS NOT NULL)