APPS.POP_CMERGE_REQ dependencies on RA_CUSTOMER_MERGES

Line 20: from ra_customer_merges racm

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
23: and racm.set_number = set_num
24: and racm.customer_id

Line 52: ra_customer_merges m,

48: CURSOR merged_records IS
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

Line 71: FROM PO_REQUISITION_LINES yt, ra_customer_merges m,

67: yt.REQUISITION_LINE_ID,
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

Line 148: ra_customer_merges racm,

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
152: and racm.customer_site_id = pla1.site_use_id

Line 297: from ra_customer_merges racm

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
300: and racm.set_number = set_num)
301: FOR UPDATE NOWAIT;

Line 499: ra_customer_merges m

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'
503: AND m.request_id = req_id

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 546: l_customer_id ra_customer_merges.customer_id%TYPE;

542: and m.request_id = req_id
543: and m.set_number = set_num;
544: /* END Bug 4009128 */
545:
546: l_customer_id ra_customer_merges.customer_id%TYPE;
547: l_site_use_id ra_customer_merges.customer_site_id%TYPE;
548: l_profile_val VARCHAR2(30);
549: l_last_fetch BOOLEAN := FALSE;
550: /* Bug 2447478 END */

Line 547: l_site_use_id ra_customer_merges.customer_site_id%TYPE;

543: and m.set_number = set_num;
544: /* END Bug 4009128 */
545:
546: l_customer_id ra_customer_merges.customer_id%TYPE;
547: l_site_use_id ra_customer_merges.customer_site_id%TYPE;
548: l_profile_val VARCHAR2(30);
549: l_last_fetch BOOLEAN := FALSE;
550: /* Bug 2447478 END */
551:

Line 764: from ra_customer_merges racm,

760: select distinct racm.customer_id,
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'