[Home] [Help]
65: RA_CUSTOMER_MERGES M4,
66: RA_CUSTOMER_MERGES M5,
67: RA_CUSTOMER_MERGES M6,
68: RA_CUSTOMER_MERGES M7,
69: OE_ORDER_HEADERS H
70: WHERE ( H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
71: AND H.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)
72: AND H.SHIP_TO_ORG_ID = M3.DUPLICATE_SITE_ID(+)
73: AND H.SOLD_TO_SITE_USE_ID = M4.DUPLICATE_SITE_ID(+)
122: RA_CUSTOMER_MERGES M4,
123: RA_CUSTOMER_MERGES M5,
124: RA_CUSTOMER_MERGES M6,
125: RA_CUSTOMER_MERGES M7,
126: OE_ORDER_HEADERS H
127: WHERE ( H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
128: AND H.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)
129: AND H.SHIP_TO_ORG_ID = M3.DUPLICATE_SITE_ID(+)
130: AND H.SOLD_TO_SITE_USE_ID = M4.DUPLICATE_SITE_ID(+)
197: -- try to open table for update, if it fails the exception will
198: -- tell us that the merge was going to block
199:
200: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
201: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADERS_ALL', FALSE );
202:
203: open merge_headers;
204: close merge_headers;
205:
340: LAST_UPDATE_DATE,
341: LAST_UPDATED_BY
342: ) VALUES (
343: HZ_CUSTOMER_MERGE_LOG_s.nextval,
344: 'OE_ORDER_HEADERS_ALL',
345: MERGE_HEADER_ID_LIST(I),
346: hdr_header_id_tab(I),
347: old_hdr_sold_to_org_id_tab(I),
348: decode(hdr_sold_to_org_id_tab(I),NULL,old_hdr_sold_to_org_id_tab(I),hdr_sold_to_org_id_tab(i)),
371: end if;
372:
373:
374: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
375: arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
376: IF hdr_header_id_tab.COUNT <> 0 THEN
377:
378: FORALL i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST
379: UPDATE OE_ORDER_HEADERS_ALL H
375: arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );
376: IF hdr_header_id_tab.COUNT <> 0 THEN
377:
378: FORALL i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST
379: UPDATE OE_ORDER_HEADERS_ALL H
380: SET sold_to_org_id = decode(hdr_sold_to_org_id_tab(i),null,sold_to_org_id,hdr_sold_to_org_id_tab(i)),
381: invoice_to_org_id = decode(hdr_invoice_to_org_id_tab(i),null,invoice_to_org_id,hdr_invoice_to_org_id_tab(i)),
382: ship_to_org_id = decode(hdr_ship_to_org_id_tab(i),null,ship_to_org_id,hdr_ship_to_org_id_tab(i)),
383: deliver_to_org_id = decode(hdr_deliver_to_org_id_tab(i),null,deliver_to_org_id,hdr_deliver_to_org_id_tab(i)),
486: -- Changed by Srini for MOAC
487: -- This MOAC change has been reverted.
488: -- For more information please
489: -- see the bug #5050382
490: OE_ORDER_HEADERS H
491: WHERE
492: ( hist.sold_to_org_id = m1.duplicate_id(+)
493: and hist.invoice_to_org_id = m2.duplicate_site_id(+)
494: and hist.ship_to_org_id = m3.duplicate_site_id(+)
555: RA_CUSTOMER_MERGES M6,
556: RA_CUSTOMER_MERGES M7,
557: OE_ORDER_HEADER_HISTORY HIST,
558: --Changed for MOAC
559: OE_ORDER_HEADERS_ALL H
560: WHERE
561: ( hist.sold_to_org_id = m1.duplicate_id(+)
562: and hist.invoice_to_org_id = m2.duplicate_site_id(+)
563: and hist.ship_to_org_id = m3.duplicate_site_id(+)
1330:
1331: CURSOR c4 is
1332: --changed for bug 3196900
1333: select /* MOAC_SQL_CHANGE */ a.HEADER_ID
1334: from OE_HEADER_ACKS a, OE_ORDER_HEADERS_all h
1335: where a.sold_to_org_id in
1336: (select m.duplicate_id
1337: from ra_customer_merges m
1338: where m.process_flag = 'N'
1369:
1370: CURSOR c7 is
1371: --changed for bug 3196900
1372: select a.HEADER_ID
1373: from OE_HEADER_ACKS a,OE_ORDER_HEADERS h
1374: where a.end_customer_id in
1375: (select m.duplicate_id
1376: from ra_customer_merges m
1377: where m.process_flag = 'N'
1686: and m.request_id = req_id
1687: and m.set_number = set_num)
1688: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'
1689: --changed for bug 3196900
1690: and a.header_id in (select header_id from oe_order_headers);
1691:
1692: g_count := sql%rowcount;
1693:
1694: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
1906: and m.request_id = req_id
1907: and m.set_number = set_num)
1908: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'
1909: --changed for bug 3196900
1910: and a.header_id in (select header_id from oe_order_headers);
1911:
1912: g_count := sql%rowcount;
1913:
1914: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
5708: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
5709: m.customer_merge_id
5710: --changed for bug 3196900
5711: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
5712: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A,OE_PRICE_ADJUSTMENTS P,OE_ORDER_HEADERS H
5713: WHERE
5714: a.pricing_context = 'CUSTOMER'
5715: and ((a.pricing_attribute in ('QUALIFIER_ATTRIBUTE11',
5716: 'QUALIFIER_ATTRIBUTE5',
5736: m.customer_merge_id
5737: --changed for bug 3196900
5738: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
5739: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A , OE_PRICE_ADJUSTMENTS P,
5740: OE_ORDER_HEADERS H
5741: WHERE
5742: a.pricing_context = 'CUSTOMER'
5743: and ((a.pricing_attribute in ('QUALIFIER_ATTRIBUTE11',
5744: 'QUALIFIER_ATTRIBUTE5',
7604: ,l_set_of_books_id
7605: ,'XXX'
7606: ,dbi_header_update_date_tab(i)
7607:
7608: FROM OE_ORDER_LINES_ALL l, oe_order_headers_all h
7609: WHERE l.header_id = dbi_header_header_id_tab(i)
7610: AND h.header_id = l.header_id
7611: AND h.booked_flag = 'Y';
7612: