DBA Data[Home] [Help]

APPS.OE_CUST_MERGE dependencies on OE_ORDER_HEADERS_ALL

Line 201: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADERS_ALL', FALSE );

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:

Line 344: 'OE_ORDER_HEADERS_ALL',

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)),

Line 375: arp_message.set_token( 'TABLE_NAME', 'oe_order_headers_all', FALSE );

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

Line 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)),

Line 559: OE_ORDER_HEADERS_ALL H

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(+)

Line 1334: from OE_HEADER_ACKS a, OE_ORDER_HEADERS_all h

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'

Line 7608: FROM OE_ORDER_LINES_ALL l, oe_order_headers_all h

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: