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.POP_CMERGE_REQ dependencies on PO_LOCATION_ASSOCIATIONS

Line 18: from po_location_associations

14: SELECT NULL
15: FROM PO_REQUISITION_LINES
16: WHERE source_type_code = 'INVENTORY'
17: and deliver_to_location_id in (select location_id
18: from po_location_associations
19: where customer_id in (select racm.duplicate_id
20: from ra_customer_merges racm
21: where racm.process_flag = 'N'
22: and racm.request_id = req_id

Line 28: from po_location_associations)))

24: and racm.customer_id
25: <> racm.duplicate_id
26: and racm.customer_id in
27: (select distinct customer_id
28: from po_location_associations)))
29: FOR UPDATE NOWAIT;
30:
31: /* Bug 2447478 START */
32:

Line 53: po_location_associations pla

49: SELECT m.CUSTOMER_MERGE_HEADER_ID,
50: yt.REQUISITION_LINE_ID
51: FROM PO_REQUISITION_LINES yt,
52: ra_customer_merges m,
53: po_location_associations pla
54: WHERE yt.source_type_code = 'INVENTORY'
55: AND yt.deliver_to_location_id = pla.location_id
56: AND pla.site_use_id = m.duplicate_site_id
57: AND m.process_flag = 'N'

Line 61: FROM po_location_associations pla1

57: AND m.process_flag = 'N'
58: AND m.request_id = req_id
59: AND m.set_number = set_num
60: AND EXISTS (SELECT null
61: FROM po_location_associations pla1
62: WHERE m.customer_site_id = pla1.site_use_id);
63: */
64:
65: CURSOR merged_records IS

Line 72: po_location_associations pla1,po_location_associations pla2

68: pla1.location_id, --new
69: pla2.location_id --old
70:
71: FROM PO_REQUISITION_LINES yt, ra_customer_merges m,
72: po_location_associations pla1,po_location_associations pla2
73: WHERE yt.source_type_code = 'INVENTORY'
74: and yt.deliver_to_location_id = pla2.location_id
75: and pla2.site_use_id = m.duplicate_site_id
76: and m.customer_site_id = pla1.site_use_id

Line 146: from po_location_associations pla1,

142: /*
143: BEGIN
144: select distinct pla1.location_id
145: into l_deliver_to_location_id
146: from po_location_associations pla1,
147: po_location_associations pla2,
148: ra_customer_merges racm,
149: po_requisition_lines yt
150: where yt.deliver_to_location_id = pla2.location_id

Line 147: po_location_associations pla2,

143: BEGIN
144: select distinct pla1.location_id
145: into l_deliver_to_location_id
146: from po_location_associations pla1,
147: po_location_associations pla2,
148: ra_customer_merges racm,
149: po_requisition_lines yt
150: where yt.deliver_to_location_id = pla2.location_id
151: and pla2.site_use_id = racm.duplicate_site_id

Line 289: /------------------------ PO_LOCATION_ASSOCIATIONS ------------------------/

285:
286: END;
287:
288:
289: /*------------------------ PO_LOCATION_ASSOCIATIONS ------------------------*/
290:
291: PROCEDURE PO_LA (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
292:
293: CURSOR C1 IS

Line 295: FROM PO_LOCATION_ASSOCIATIONS

291: PROCEDURE PO_LA (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
292:
293: CURSOR C1 IS
294: SELECT NULL
295: FROM PO_LOCATION_ASSOCIATIONS
296: WHERE site_use_id in (select racm.duplicate_site_id
297: from ra_customer_merges racm
298: where racm.process_flag = 'N'
299: and racm.request_id = req_id

Line 310: PO_LOCATION_ASSOCIATIONS.LOCATION_ID%TYPE

306: INDEX BY BINARY_INTEGER;
307: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
308:
309: TYPE LOCATION_ID_LIST_TYPE IS TABLE OF
310: PO_LOCATION_ASSOCIATIONS.LOCATION_ID%TYPE
311: INDEX BY BINARY_INTEGER;
312: PRIMARY_KEY_ID_LIST LOCATION_ID_LIST_TYPE;
313:
314: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 315: PO_LOCATION_ASSOCIATIONS.CUSTOMER_ID%TYPE

311: INDEX BY BINARY_INTEGER;
312: PRIMARY_KEY_ID_LIST LOCATION_ID_LIST_TYPE;
313:
314: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
315: PO_LOCATION_ASSOCIATIONS.CUSTOMER_ID%TYPE
316: INDEX BY BINARY_INTEGER;
317: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
318: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
319:

Line 321: PO_LOCATION_ASSOCIATIONS.SITE_USE_ID%TYPE

317: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
318: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
319:
320: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF
321: PO_LOCATION_ASSOCIATIONS.SITE_USE_ID%TYPE
322: INDEX BY BINARY_INTEGER;
323: NUM_COL2_ORIG_LIST SITE_USE_ID_LIST_TYPE;
324: NUM_COL2_NEW_LIST SITE_USE_ID_LIST_TYPE;
325:

Line 327: PO_LOCATION_ASSOCIATIONS.ADDRESS_ID%TYPE

323: NUM_COL2_ORIG_LIST SITE_USE_ID_LIST_TYPE;
324: NUM_COL2_NEW_LIST SITE_USE_ID_LIST_TYPE;
325:
326: TYPE ADDRESS_ID_LIST_TYPE IS TABLE OF
327: PO_LOCATION_ASSOCIATIONS.ADDRESS_ID%TYPE
328: INDEX BY BINARY_INTEGER;
329: NUM_COL3_ORIG_LIST ADDRESS_ID_LIST_TYPE;
330: NUM_COL3_NEW_LIST ADDRESS_ID_LIST_TYPE;
331:

Line 333: PO_LOCATION_ASSOCIATIONS.ORGANIZATION_ID%TYPE

329: NUM_COL3_ORIG_LIST ADDRESS_ID_LIST_TYPE;
330: NUM_COL3_NEW_LIST ADDRESS_ID_LIST_TYPE;
331:
332: TYPE ORGANIZATION_ID_LIST_TYPE IS TABLE OF
333: PO_LOCATION_ASSOCIATIONS.ORGANIZATION_ID%TYPE
334: INDEX BY BINARY_INTEGER;
335: NUM_COL4_ORIG_LIST ORGANIZATION_ID_LIST_TYPE;
336: NUM_COL4_NEW_LIST ORGANIZATION_ID_LIST_TYPE;
337:

Line 339: PO_LOCATION_ASSOCIATIONS.ORG_ID%TYPE

335: NUM_COL4_ORIG_LIST ORGANIZATION_ID_LIST_TYPE;
336: NUM_COL4_NEW_LIST ORGANIZATION_ID_LIST_TYPE;
337:
338: TYPE ORG_ID_LIST_TYPE IS TABLE OF
339: PO_LOCATION_ASSOCIATIONS.ORG_ID%TYPE
340: INDEX BY BINARY_INTEGER;
341: NUM_COL5_ORIG_LIST ORG_ID_LIST_TYPE;
342: NUM_COL5_NEW_LIST ORG_ID_LIST_TYPE;
343:

Line 345: PO_LOCATION_ASSOCIATIONS.VENDOR_ID%TYPE

341: NUM_COL5_ORIG_LIST ORG_ID_LIST_TYPE;
342: NUM_COL5_NEW_LIST ORG_ID_LIST_TYPE;
343:
344: TYPE VENDOR_ID_LIST_TYPE IS TABLE OF
345: PO_LOCATION_ASSOCIATIONS.VENDOR_ID%TYPE
346: INDEX BY BINARY_INTEGER;
347: NUM_COL6_ORIG_LIST VENDOR_ID_LIST_TYPE;
348: NUM_COL6_NEW_LIST VENDOR_ID_LIST_TYPE;
349:

Line 351: PO_LOCATION_ASSOCIATIONS.VENDOR_SITE_ID%TYPE

347: NUM_COL6_ORIG_LIST VENDOR_ID_LIST_TYPE;
348: NUM_COL6_NEW_LIST VENDOR_ID_LIST_TYPE;
349:
350: TYPE VENDOR_SITE_ID_LIST_TYPE IS TABLE OF
351: PO_LOCATION_ASSOCIATIONS.VENDOR_SITE_ID%TYPE
352: INDEX BY BINARY_INTEGER;
353: NUM_COL7_ORIG_LIST VENDOR_SITE_ID_LIST_TYPE;
354: NUM_COL7_NEW_LIST VENDOR_SITE_ID_LIST_TYPE;
355:

Line 357: PO_LOCATION_ASSOCIATIONS.SUBINVENTORY%TYPE

353: NUM_COL7_ORIG_LIST VENDOR_SITE_ID_LIST_TYPE;
354: NUM_COL7_NEW_LIST VENDOR_SITE_ID_LIST_TYPE;
355:
356: TYPE SUBINVENTORY_LIST_TYPE IS TABLE OF
357: PO_LOCATION_ASSOCIATIONS.SUBINVENTORY%TYPE
358: INDEX BY BINARY_INTEGER;
359: VCHAR_COL1_ORIG_LIST SUBINVENTORY_LIST_TYPE;
360: VCHAR_COL1_NEW_LIST SUBINVENTORY_LIST_TYPE;
361:

Line 363: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE_CATEGORY%TYPE

359: VCHAR_COL1_ORIG_LIST SUBINVENTORY_LIST_TYPE;
360: VCHAR_COL1_NEW_LIST SUBINVENTORY_LIST_TYPE;
361:
362: TYPE ATTRIBUTE_CATEGORY_LIST_TYPE IS TABLE OF
363: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE_CATEGORY%TYPE
364: INDEX BY BINARY_INTEGER;
365: VCHAR_COL2_ORIG_LIST ATTRIBUTE_CATEGORY_LIST_TYPE;
366: VCHAR_COL2_NEW_LIST ATTRIBUTE_CATEGORY_LIST_TYPE;
367:

Line 369: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE1%TYPE

365: VCHAR_COL2_ORIG_LIST ATTRIBUTE_CATEGORY_LIST_TYPE;
366: VCHAR_COL2_NEW_LIST ATTRIBUTE_CATEGORY_LIST_TYPE;
367:
368: TYPE ATTRIBUTE1_LIST_TYPE IS TABLE OF
369: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE1%TYPE
370: INDEX BY BINARY_INTEGER;
371: VCHAR_COL3_ORIG_LIST ATTRIBUTE1_LIST_TYPE;
372: VCHAR_COL3_NEW_LIST ATTRIBUTE1_LIST_TYPE;
373:

Line 375: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE2%TYPE

371: VCHAR_COL3_ORIG_LIST ATTRIBUTE1_LIST_TYPE;
372: VCHAR_COL3_NEW_LIST ATTRIBUTE1_LIST_TYPE;
373:
374: TYPE ATTRIBUTE2_LIST_TYPE IS TABLE OF
375: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE2%TYPE
376: INDEX BY BINARY_INTEGER;
377: VCHAR_COL4_ORIG_LIST ATTRIBUTE2_LIST_TYPE;
378: VCHAR_COL4_NEW_LIST ATTRIBUTE2_LIST_TYPE;
379:

Line 381: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE3%TYPE

377: VCHAR_COL4_ORIG_LIST ATTRIBUTE2_LIST_TYPE;
378: VCHAR_COL4_NEW_LIST ATTRIBUTE2_LIST_TYPE;
379:
380: TYPE ATTRIBUTE3_LIST_TYPE IS TABLE OF
381: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE3%TYPE
382: INDEX BY BINARY_INTEGER;
383: VCHAR_COL5_ORIG_LIST ATTRIBUTE3_LIST_TYPE;
384: VCHAR_COL5_NEW_LIST ATTRIBUTE3_LIST_TYPE;
385:

Line 387: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE4%TYPE

383: VCHAR_COL5_ORIG_LIST ATTRIBUTE3_LIST_TYPE;
384: VCHAR_COL5_NEW_LIST ATTRIBUTE3_LIST_TYPE;
385:
386: TYPE ATTRIBUTE4_LIST_TYPE IS TABLE OF
387: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE4%TYPE
388: INDEX BY BINARY_INTEGER;
389: VCHAR_COL6_ORIG_LIST ATTRIBUTE4_LIST_TYPE;
390: VCHAR_COL6_NEW_LIST ATTRIBUTE4_LIST_TYPE;
391:

Line 393: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE5%TYPE

389: VCHAR_COL6_ORIG_LIST ATTRIBUTE4_LIST_TYPE;
390: VCHAR_COL6_NEW_LIST ATTRIBUTE4_LIST_TYPE;
391:
392: TYPE ATTRIBUTE5_LIST_TYPE IS TABLE OF
393: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE5%TYPE
394: INDEX BY BINARY_INTEGER;
395: VCHAR_COL7_ORIG_LIST ATTRIBUTE5_LIST_TYPE;
396: VCHAR_COL7_NEW_LIST ATTRIBUTE5_LIST_TYPE;
397:

Line 399: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE6%TYPE

395: VCHAR_COL7_ORIG_LIST ATTRIBUTE5_LIST_TYPE;
396: VCHAR_COL7_NEW_LIST ATTRIBUTE5_LIST_TYPE;
397:
398: TYPE ATTRIBUTE6_LIST_TYPE IS TABLE OF
399: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE6%TYPE
400: INDEX BY BINARY_INTEGER;
401: VCHAR_COL8_ORIG_LIST ATTRIBUTE6_LIST_TYPE;
402: VCHAR_COL8_NEW_LIST ATTRIBUTE6_LIST_TYPE;
403:

Line 405: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE7%TYPE

401: VCHAR_COL8_ORIG_LIST ATTRIBUTE6_LIST_TYPE;
402: VCHAR_COL8_NEW_LIST ATTRIBUTE6_LIST_TYPE;
403:
404: TYPE ATTRIBUTE7_LIST_TYPE IS TABLE OF
405: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE7%TYPE
406: INDEX BY BINARY_INTEGER;
407: VCHAR_COL9_ORIG_LIST ATTRIBUTE7_LIST_TYPE;
408: VCHAR_COL9_NEW_LIST ATTRIBUTE7_LIST_TYPE;
409:

Line 411: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE8%TYPE

407: VCHAR_COL9_ORIG_LIST ATTRIBUTE7_LIST_TYPE;
408: VCHAR_COL9_NEW_LIST ATTRIBUTE7_LIST_TYPE;
409:
410: TYPE ATTRIBUTE8_LIST_TYPE IS TABLE OF
411: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE8%TYPE
412: INDEX BY BINARY_INTEGER;
413: VCHAR_COL10_ORIG_LIST ATTRIBUTE8_LIST_TYPE;
414: VCHAR_COL10_NEW_LIST ATTRIBUTE8_LIST_TYPE;
415:

Line 417: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE9%TYPE

413: VCHAR_COL10_ORIG_LIST ATTRIBUTE8_LIST_TYPE;
414: VCHAR_COL10_NEW_LIST ATTRIBUTE8_LIST_TYPE;
415:
416: TYPE ATTRIBUTE9_LIST_TYPE IS TABLE OF
417: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE9%TYPE
418: INDEX BY BINARY_INTEGER;
419: VCHAR_COL11_ORIG_LIST ATTRIBUTE9_LIST_TYPE;
420: VCHAR_COL11_NEW_LIST ATTRIBUTE9_LIST_TYPE;
421:

Line 423: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE10%TYPE

419: VCHAR_COL11_ORIG_LIST ATTRIBUTE9_LIST_TYPE;
420: VCHAR_COL11_NEW_LIST ATTRIBUTE9_LIST_TYPE;
421:
422: TYPE ATTRIBUTE10_LIST_TYPE IS TABLE OF
423: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE10%TYPE
424: INDEX BY BINARY_INTEGER;
425: VCHAR_COL12_ORIG_LIST ATTRIBUTE10_LIST_TYPE;
426: VCHAR_COL12_NEW_LIST ATTRIBUTE10_LIST_TYPE;
427:

Line 429: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE11%TYPE

425: VCHAR_COL12_ORIG_LIST ATTRIBUTE10_LIST_TYPE;
426: VCHAR_COL12_NEW_LIST ATTRIBUTE10_LIST_TYPE;
427:
428: TYPE ATTRIBUTE11_LIST_TYPE IS TABLE OF
429: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE11%TYPE
430: INDEX BY BINARY_INTEGER;
431: VCHAR_COL13_ORIG_LIST ATTRIBUTE11_LIST_TYPE;
432: VCHAR_COL13_NEW_LIST ATTRIBUTE11_LIST_TYPE;
433:

Line 435: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE12%TYPE

431: VCHAR_COL13_ORIG_LIST ATTRIBUTE11_LIST_TYPE;
432: VCHAR_COL13_NEW_LIST ATTRIBUTE11_LIST_TYPE;
433:
434: TYPE ATTRIBUTE12_LIST_TYPE IS TABLE OF
435: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE12%TYPE
436: INDEX BY BINARY_INTEGER;
437: VCHAR_COL14_ORIG_LIST ATTRIBUTE12_LIST_TYPE;
438: VCHAR_COL14_NEW_LIST ATTRIBUTE12_LIST_TYPE;
439:

Line 441: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE13%TYPE

437: VCHAR_COL14_ORIG_LIST ATTRIBUTE12_LIST_TYPE;
438: VCHAR_COL14_NEW_LIST ATTRIBUTE12_LIST_TYPE;
439:
440: TYPE ATTRIBUTE13_LIST_TYPE IS TABLE OF
441: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE13%TYPE
442: INDEX BY BINARY_INTEGER;
443: VCHAR_COL15_ORIG_LIST ATTRIBUTE13_LIST_TYPE;
444: VCHAR_COL15_NEW_LIST ATTRIBUTE13_LIST_TYPE;
445:

Line 447: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE14%TYPE

443: VCHAR_COL15_ORIG_LIST ATTRIBUTE13_LIST_TYPE;
444: VCHAR_COL15_NEW_LIST ATTRIBUTE13_LIST_TYPE;
445:
446: TYPE ATTRIBUTE14_LIST_TYPE IS TABLE OF
447: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE14%TYPE
448: INDEX BY BINARY_INTEGER;
449: VCHAR_COL16_ORIG_LIST ATTRIBUTE14_LIST_TYPE;
450: VCHAR_COL16_NEW_LIST ATTRIBUTE14_LIST_TYPE;
451:

Line 453: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE15%TYPE

449: VCHAR_COL16_ORIG_LIST ATTRIBUTE14_LIST_TYPE;
450: VCHAR_COL16_NEW_LIST ATTRIBUTE14_LIST_TYPE;
451:
452: TYPE ATTRIBUTE15_LIST_TYPE IS TABLE OF
453: PO_LOCATION_ASSOCIATIONS.ATTRIBUTE15%TYPE
454: INDEX BY BINARY_INTEGER;
455: VCHAR_COL17_ORIG_LIST ATTRIBUTE15_LIST_TYPE;
456: VCHAR_COL17_NEW_LIST ATTRIBUTE15_LIST_TYPE;
457:

Line 498: FROM PO_LOCATION_ASSOCIATIONS yt,

494: yt.ATTRIBUTE12,
495: yt.ATTRIBUTE13,
496: yt.ATTRIBUTE14,
497: yt.ATTRIBUTE15
498: FROM PO_LOCATION_ASSOCIATIONS yt,
499: ra_customer_merges m
500: WHERE yt.site_use_id = m.duplicate_site_id -- get the records that
501: -- need to be merged from
502: AND m.process_flag = 'N'

Line 506: FROM po_location_associations lc

502: AND m.process_flag = 'N'
503: AND m.request_id = req_id
504: AND m.set_number = set_num
505: AND EXISTS (SELECT null
506: FROM po_location_associations lc
507: WHERE lc.site_use_id = m.customer_site_id);
508:
509: /* Start Bug 4009128 - replaced the below cursor statement */
510:

Line 526: FROM PO_LOCATION_ASSOCIATIONS yt, ra_customer_merges m

522: /*
523: CURSOR merged_records IS
524: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID,
525: yt.LOCATION_ID
526: FROM PO_LOCATION_ASSOCIATIONS yt, ra_customer_merges m
527: WHERE yt.site_use_id = m.duplicate_site_id
528: AND m.process_flag = 'N'
529: AND m.request_id = req_id
530: AND m.set_number = set_num;

Line 538: FROM PO_LOCATION_ASSOCIATIONS yt, ra_customer_merges m

534: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID,
535: yt.LOCATION_ID,
536: m.customer_id,
537: m.customer_site_id
538: FROM PO_LOCATION_ASSOCIATIONS yt, ra_customer_merges m
539: where yt.customer_id = m.duplicate_id
540: and yt.site_use_id = m.duplicate_site_id
541: and m.process_flag = 'N'
542: and m.request_id = req_id

Line 557: | PO_LOCATION_ASSOCIATIONS |

553:
554: arp_message.set_line( 'POP_CMERGE_REQ.PO_LA()+' );
555:
556: /*-----------------------------+
557: | PO_LOCATION_ASSOCIATIONS |
558: +-----------------------------*/
559:
560: IF (process_mode = 'LOCK') then
561:

Line 565: arp_message.set_token( 'TABLE_NAME', 'PO_LOCATION_ASSOCIATIONS', FALSE );

561:
562: /* try to lock the table first */
563:
564: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
565: arp_message.set_token( 'TABLE_NAME', 'PO_LOCATION_ASSOCIATIONS', FALSE );
566: arp_message.flush;
567:
568: OPEN C1;
569: CLOSE C1;

Line 576: arp_message.set_token('TABLE_NAME', 'PO_LOCATION_ASSOCIATIONS', FALSE);

572:
573: /* for merged customers/sites */
574:
575: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
576: arp_message.set_token('TABLE_NAME', 'PO_LOCATION_ASSOCIATIONS', FALSE);
577: arp_message.set_line('Deleting merged customers/sites.');
578:
579: /* Bug 2447478 START */
580: g_count := 0;

Line 686: 'PO_LOCATION_ASSOCIATIONS',

682: LAST_UPDATE_DATE,
683: LAST_UPDATED_BY)
684: VALUES(
685: HZ_CUSTOMER_MERGE_LOG_s.nextval,
686: 'PO_LOCATION_ASSOCIATIONS',
687: MERGE_HEADER_ID_LIST(I),
688: PRIMARY_KEY_ID_LIST(I),
689: NUM_COL1_ORIG_LIST(I),
690: NUM_COL2_ORIG_LIST(I),

Line 727: DELETE FROM PO_LOCATION_ASSOCIATIONS yt

723: Delete all old or redundant records from the affected
724: Requisitions due to merged/changed accounts
725: */
726: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
727: DELETE FROM PO_LOCATION_ASSOCIATIONS yt
728: WHERE LOCATION_ID = PRIMARY_KEY_ID_LIST(I);
729:
730: g_count := g_count + SQL%ROWCOUNT;
731:

Line 750: arp_message.set_token('TABLE_NAME', 'PO_LOCATION_ASSOCIATIONS', FALSE);

746:
747: /* for changed customers */
748:
749: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
750: arp_message.set_token('TABLE_NAME', 'PO_LOCATION_ASSOCIATIONS', FALSE);
751: arp_message.set_line('Updating changed customers.');
752:
753: /* Bug 2447478 START */
754: g_count := 0;

Line 765: PO_LOCATION_ASSOCIATIONS yt

761: racm.customer_site_id
762: into l_customer_id,
763: l_site_use_id
764: from ra_customer_merges racm,
765: PO_LOCATION_ASSOCIATIONS yt
766: where yt.customer_id = racm.duplicate_id
767: and yt.site_use_id = racm.duplicate_site_id
768: and racm.process_flag = 'N'
769: and racm.request_id = req_id

Line 847: 'PO_LOCATION_ASSOCIATIONS',

843: LAST_UPDATE_DATE,
844: LAST_UPDATED_BY)
845: VALUES(
846: HZ_CUSTOMER_MERGE_LOG_s.nextval,
847: 'PO_LOCATION_ASSOCIATIONS',
848: MERGE_HEADER_ID_LIST(I),
849: PRIMARY_KEY_ID_LIST(I),
850: NUM_COL1_ORIG_LIST(I),
851: NUM_COL1_NEW_LIST(I),

Line 868: UPDATE PO_LOCATION_ASSOCIATIONS yt

864: Update all corresponding customer_id and site_use_id
865: due to merged/changed accounts
866: */
867: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
868: UPDATE PO_LOCATION_ASSOCIATIONS yt
869: SET CUSTOMER_ID=NEW_CUST_ID_LIST(I), --Bug 4009128
870: SITE_USE_ID=NEW_CUST_SITE_ID_LIST(I), --Bug 4009128
871: LAST_UPDATE_DATE = SYSDATE,
872: last_updated_by = arp_standard.profile.user_id,