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.ARP_CMERGE_ARCUS dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 350: FROM hz_cust_acct_relate_all rel --SSUptake

346: and merge.set_number = set_num
347: and merge.org_id = site.org_id --SSUptake
348: UNION
349: SELECT related_cust_account_id
350: FROM hz_cust_acct_relate_all rel --SSUptake
351: WHERE rel.org_id = l_org_id --SSUptake
352: AND rel.cust_account_id in (
353: select unique(customer_id)
354: from ra_customer_merges merge

Line 1416: FROM hz_cust_acct_relate_all yt, ra_customer_merges m --SSUptake

1412:
1413: --cursor c1 is for from cust account
1414: CURSOR c1 IS
1415: SELECT yt.cust_account_id
1416: FROM hz_cust_acct_relate_all yt, ra_customer_merges m --SSUptake
1417: WHERE
1418: --NOT EXISTS (
1419: -- SELECT 'active accounts exist'
1420: -- FROM hz_cust_accounts acct

Line 1433: FROM hz_cust_acct_relate_all yt, ra_customer_merges m --SSUptake

1429:
1430: --cursor c2 is for to cust account
1431: CURSOR c2 IS
1432: SELECT yt.related_cust_account_id
1433: FROM hz_cust_acct_relate_all yt, ra_customer_merges m --SSUptake
1434: WHERE
1435: --NOT EXISTS (
1436: -- SELECT 'active accounts exist'
1437: -- FROM hz_cust_accounts acct

Line 1453: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm

1449: CURSOR c_from_rel_cust_id IS
1450: SELECT unique yt.cust_acct_relate_id,cm.customer_id,yt.cust_account_id,yt.related_cust_account_id,
1451: yt.customer_reciprocal_flag,nvl(yt.bill_to_flag,'N') bill_to_flag,
1452: nvl(yt.ship_to_flag,'N') ship_to_flag,yt.rowid,yt.org_id
1453: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm
1454: WHERE cm.request_id = req_id
1455: AND cm.process_flag = 'N'
1456: AND cm.set_number = set_num
1457: AND cm.duplicate_id <> cm.customer_id --merging sites for same customer

Line 1466: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm

1462: CURSOR c_from_cust_rel_id IS
1463: SELECT unique yt.cust_acct_relate_id,cm.customer_id,yt.cust_account_id,yt.related_cust_account_id,
1464: yt.customer_reciprocal_flag,nvl(yt.bill_to_flag,'N') bill_to_flag,
1465: nvl(yt.ship_to_flag,'N') ship_to_flag,yt.rowid,yt.org_id
1466: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm
1467: WHERE cm.request_id = req_id
1468: AND cm.process_flag = 'N'
1469: AND cm.set_number = set_num
1470: AND cm.duplicate_id <> cm.customer_id --merging sites for same customer

Line 1478: FROM hz_cust_acct_relate_all yt

1474: AND cm.org_id = yt.org_id;
1475: CURSOR c_to_rel_cust_id(p_cust_account_id NUMBER,p_related_cust_account_id NUMBER,p_org_id NUMBER) IS
1476: SELECT cust_account_id,related_cust_account_id,customer_reciprocal_flag,
1477: nvl(bill_to_flag,'N') bill_to_flag,nvl(ship_to_flag,'N') ship_to_flag
1478: FROM hz_cust_acct_relate_all yt
1479: WHERE yt.cust_account_id = p_cust_account_id
1480: AND yt.related_cust_account_id = p_related_cust_account_id
1481: AND yt.status = 'A'
1482: AND yt.org_id = p_org_id

Line 1559: UPDATE hz_cust_acct_relate_all SET bill_to_flag = l_to_bill_to_flag,ship_to_flag=l_to_ship_to_flag

1555: l_to_ship_to_flag := from_rec.ship_to_flag;
1556: l_update_flag := true;
1557: END IF;
1558: IF(l_update_flag) THEN
1559: UPDATE hz_cust_acct_relate_all SET bill_to_flag = l_to_bill_to_flag,ship_to_flag=l_to_ship_to_flag
1560: WHERE cust_account_id = l_to_cust_account_id
1561: AND related_cust_account_id = l_to_related_cust_account_id
1562: AND org_id = from_rec.org_id
1563: AND STATUS = 'A';

Line 1567: UPDATE hz_cust_acct_relate_all yt SET

1563: AND STATUS = 'A';
1564: END IF;
1565: END IF;
1566: --Inactivate the from account relationship
1567: UPDATE hz_cust_acct_relate_all yt SET
1568: status = 'I',
1569: last_update_date = sysdate,
1570: last_updated_by = hz_utility_v2pub.user_id,
1571: last_update_login = hz_utility_v2pub.last_update_login,

Line 1621: UPDATE hz_cust_acct_relate_all SET bill_to_flag = l_to_bill_to_flag,ship_to_flag=l_to_ship_to_flag

1617: l_to_ship_to_flag := from_rec.ship_to_flag;
1618: l_update_flag := true;
1619: END IF;
1620: IF(l_update_flag) THEN
1621: UPDATE hz_cust_acct_relate_all SET bill_to_flag = l_to_bill_to_flag,ship_to_flag=l_to_ship_to_flag
1622: WHERE cust_account_id = l_to_cust_account_id
1623: AND related_cust_account_id = l_to_related_cust_account_id
1624: AND org_id = from_rec.org_id
1625: AND STATUS = 'A';

Line 1629: UPDATE hz_cust_acct_relate_all yt SET

1625: AND STATUS = 'A';
1626: END IF;
1627: END IF;
1628: --Inactivate the from account relationships
1629: UPDATE hz_cust_acct_relate_all yt SET
1630: status = 'I',
1631: last_update_date = sysdate,
1632: last_updated_by =hz_utility_v2pub.user_id,
1633: last_update_login = hz_utility_v2pub.last_update_login,

Line 1653: /*UPDATE HZ_CUST_ACCT_RELATE_ALL yt

1649: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
1650: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_ACCT_RELATE', FALSE );
1651:
1652: --Start bug 7192302
1653: /*UPDATE HZ_CUST_ACCT_RELATE_ALL yt
1654: SET status = 'I',
1655: last_update_date = sysdate,
1656: last_updated_by = arp_standard.profile.user_id,
1657: last_update_login = arp_standard.profile.last_update_login,

Line 1683: UPDATE HZ_CUST_ACCT_RELATE_ALL YT

1679: AND m.set_number = set_num
1680: AND m.org_id = yt.org_id
1681: AND m.delete_duplicate_flag = 'N' );*/
1682:
1683: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1684: SET STATUS = 'I',
1685: LAST_UPDATE_DATE = SYSDATE,
1686: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,
1687: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,

Line 1704: UPDATE HZ_CUST_ACCT_RELATE_ALL YT

1700: AND M.DELETE_DUPLICATE_FLAG = 'N' );
1701:
1702: g_count := sql%rowcount;
1703:
1704: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1705: SET STATUS = 'I',
1706: LAST_UPDATE_DATE = SYSDATE,
1707: LAST_UPDATED_BY = hz_utility_v2pub.user_id ,
1708: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login ,

Line 1743: UPDATE HZ_CUST_ACCT_RELATE_ALL yt --SSUptake

1739: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_ACCT_RELATE', FALSE );
1740:
1741: /************** from account update ************/
1742:
1743: UPDATE HZ_CUST_ACCT_RELATE_ALL yt --SSUptake
1744: SET status = 'D'
1745: WHERE
1746: --NOT EXISTS (
1747: -- SELECT 'accounts exist'

Line 1762: FROM HZ_CUST_ACCT_RELATE_ALL r, --SSUptake

1758: AND m.delete_duplicate_flag = 'Y'
1759: AND m.org_id = yt.org_id ) --SSUptake
1760: AND ( EXISTS (
1761: SELECT 'relationship already exists, cannot update'
1762: FROM HZ_CUST_ACCT_RELATE_ALL r, --SSUptake
1763: ra_customer_merges m
1764: WHERE m.customer_id = r.cust_account_id
1765: AND m.duplicate_id = yt.cust_account_id
1766: AND r.related_cust_account_id = yt.related_cust_account_id

Line 1804: UPDATE HZ_CUST_ACCT_RELATE_ALL yt

1800:
1801: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
1802: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_ACCT_RELATE', FALSE );
1803:
1804: UPDATE HZ_CUST_ACCT_RELATE_ALL yt
1805: SET status = 'D'
1806: WHERE
1807: --NOT EXISTS (
1808: -- SELECT 'accounts exist'

Line 1823: FROM HZ_CUST_ACCT_RELATE_ALL r,

1819: AND m.set_number = set_num
1820: AND m.delete_duplicate_flag = 'Y')
1821: AND ( EXISTS (
1822: SELECT 'relationship already exists, cannot update'
1823: FROM HZ_CUST_ACCT_RELATE_ALL r,
1824: ra_customer_merges m
1825: WHERE m.customer_id = r.related_cust_account_id
1826: AND m.duplicate_id = yt.related_cust_account_id
1827: AND r.cust_account_id = yt.cust_account_id

Line 4670: FROM HZ_CUST_ACCT_RELATE_ALL rel, ra_customer_merges m --SSUptake

4666: FOR UPDATE NOWAIT;
4667:
4668: CURSOR cust_rel1 IS
4669: SELECT rel.cust_account_id
4670: FROM HZ_CUST_ACCT_RELATE_ALL rel, ra_customer_merges m --SSUptake
4671: WHERE cust_account_id = m.duplicate_id
4672: AND m.org_id = rel.org_id --SSUptake
4673: AND m.process_flag = 'N'
4674: AND m.request_id = req_id

Line 4682: FROM HZ_CUST_ACCT_RELATE_ALL rel, ra_customer_merges m --SSUptake

4678: FOR UPDATE NOWAIT;
4679:
4680: CURSOR cust_rel2 IS
4681: SELECT rel.related_cust_account_id
4682: FROM HZ_CUST_ACCT_RELATE_ALL rel, ra_customer_merges m --SSUptake
4683: WHERE related_cust_account_id = m.duplicate_id
4684: AND m.org_id = rel.org_id --SSUptake
4685: AND m.process_flag = 'N'
4686: AND m.request_id = req_id

Line 4888: DELETE FROM HZ_CUST_ACCT_RELATE_ALL rel --SSUptake

4884: --lock rows
4885: OPEN cust_rel1;
4886: CLOSE cust_rel1;
4887:
4888: DELETE FROM HZ_CUST_ACCT_RELATE_ALL rel --SSUptake
4889: WHERE EXISTS (
4890: SELECT 'Y'
4891: FROM ra_customer_merges m
4892: WHERE m.duplicate_id = rel.cust_account_id

Line 4913: DELETE FROM HZ_CUST_ACCT_RELATE_ALL rel --SSUptake

4909: --lock rows
4910: OPEN cust_rel2;
4911: CLOSE cust_rel2;
4912:
4913: DELETE FROM HZ_CUST_ACCT_RELATE_ALL rel --SSUptake
4914: WHERE EXISTS (
4915: SELECT 'Y'
4916: FROM ra_customer_merges m
4917: WHERE m.duplicate_id = rel.related_cust_account_id

Line 8208: ---------Insert into hz_cust_acct_relate_all_m--------------

8204: AND su.org_id = m.org_id; --SSUptake
8205:
8206: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');
8207:
8208: ---------Insert into hz_cust_acct_relate_all_m--------------
8209: INSERT INTO hz_cust_acct_relate_all_m(
8210: customer_merge_header_id,
8211: cust_account_id ,
8212: related_cust_account_id ,

Line 8209: INSERT INTO hz_cust_acct_relate_all_m(

8205:
8206: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');
8207:
8208: ---------Insert into hz_cust_acct_relate_all_m--------------
8209: INSERT INTO hz_cust_acct_relate_all_m(
8210: customer_merge_header_id,
8211: cust_account_id ,
8212: related_cust_account_id ,
8213: last_update_date ,

Line 8297: and cm.duplicate_id <> cm.customer_id) m,hz_cust_acct_relate_all yt --SSUptake

8293: from ra_customer_merges cm
8294: where cm.process_flag = 'N'
8295: and cm.request_id = req_id
8296: and cm.set_number = set_num
8297: and cm.duplicate_id <> cm.customer_id) m,hz_cust_acct_relate_all yt --SSUptake
8298: WHERE ( yt.cust_account_id = duplicate_id OR
8299: yt.related_cust_account_id = duplicate_id )
8300: AND m.org_id = yt.org_id ; --SSUptake
8301:

Line 8302: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_RELATE_ALL_M');

8298: WHERE ( yt.cust_account_id = duplicate_id OR
8299: yt.related_cust_account_id = duplicate_id )
8300: AND m.org_id = yt.org_id ; --SSUptake
8301:
8302: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_RELATE_ALL_M');
8303:
8304:
8305: ---After storing the merge data sucessfully initialize the status to 0
8306: status := 0;

Line 8332: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE_ALL.CUST_ACCT_RELATE_ID%TYPE;

8328: p_cust_acct_relate_rec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCT_RELATE_REC_TYPE;
8329: x_return_status VARCHAR2(1);
8330: x_msg_count NUMBER;
8331: x_msg_data varchar2(2000);
8332: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE_ALL.CUST_ACCT_RELATE_ID%TYPE;
8333: BEGIN
8334: HZ_CUST_ACCOUNT_V2PUB.get_cust_acct_relate_rec (
8335: FND_API.G_FALSE,
8336: p_cust_account_id,