APPS.IBE_MERGE_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 420: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b, RA_CUSTOMER_MERGES RACM

416:
417: --cursor to get account and party IDs, quote name and quote_header_id
418: Cursor C_ACTIVE_QUOTE_FROM is
419: Select a.quote_header_id, a.cust_account_id, a.party_id, b.quote_name, racm.customer_merge_id
420: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b, RA_CUSTOMER_MERGES RACM
421: Where a.quote_header_id = b.quote_header_id (+)
422: and a.party_id = b.party_id (+)
423: and a.cust_account_id = b.cust_account_id (+)
424: and a.cust_account_id = racm.duplicate_id

Line 449: update ASO_QUOTE_HEADERS_ALL

445: EXIT When C_ACTIVE_QUOTE_FROM%NOTFOUND;
446: Begin
447: --2967340
448: --if has an unnamed cart, update it to be default
449: update ASO_QUOTE_HEADERS_ALL
450: set QUOTE_NAME = 'IBE_PRMT_SC_DEFAULTNAMED'
451: where quote_header_id = l_from_quote_id
452: AND quote_name = 'IBE_PRMT_SC_UNNAMED';
453: --check profile, log when it's ON

Line 460: HZ_CUSTOMER_MERGE_LOG_s.nextval,'ASO_QUOTE_HEADERS_ALL',

456: MERGE_LOG_ID,TABLE_NAME,MERGE_HEADER_ID,PRIMARY_KEY_ID,
457: VCHAR_COL1_ORIG,VCHAR_COL1_NEW,ACTION_FLAG,REQUEST_ID,CREATED_BY,
458: CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY
459: ) VALUES (
460: HZ_CUSTOMER_MERGE_LOG_s.nextval,'ASO_QUOTE_HEADERS_ALL',
461: l_customer_merge_id,l_from_quote_id,'IBE_PRMT_SC_UNNAMED','IBE_PRMT_SC_DEFAULTNAMED',
462: 'U',req_id,hz_utility_pub.CREATED_BY,
463: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,
464: hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY

Line 1628: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b

1624: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1625:
1626: Cursor MERGE_FROM_ACTIVE is
1627: Select a.quote_header_id, a.cust_account_id, b.quote_name
1628: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b
1629: Where a.quote_header_id = b.quote_header_id (+) and a.party_id = b.party_id (+)
1630: and a.cust_account_id=b.cust_account_id (+) and a.party_id=P_from_fk_id
1631: for update nowait;
1632:

Line 1658: update ASO_QUOTE_HEADERS_ALL

1654: Fetch merge_from_active into l_quote_header_id, l_cust_account_id, l_quote_name;
1655: EXIT When merge_from_active%NOTFOUND;
1656: Begin
1657: --2967430
1658: update ASO_QUOTE_HEADERS_ALL
1659: set QUOTE_NAME = 'IBE_PRMT_SC_DEFAULTNAMED'
1660: where quote_header_id = l_quote_header_id
1661: AND quote_name = 'IBE_PRMT_SC_UNNAMED';
1662: