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 1281: FROM hz_cust_acct_relate_all yt, ra_customer_merges m --SSUptake

1277:
1278: --cursor c1 is for from cust account
1279: CURSOR c1 IS
1280: SELECT yt.cust_account_id
1281: FROM hz_cust_acct_relate_all yt, ra_customer_merges m --SSUptake
1282: WHERE
1283: --NOT EXISTS (
1284: -- SELECT 'active accounts exist'
1285: -- FROM hz_cust_accounts acct

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

1294:
1295: --cursor c2 is for to cust account
1296: CURSOR c2 IS
1297: SELECT yt.related_cust_account_id
1298: FROM hz_cust_acct_relate_all yt, ra_customer_merges m --SSUptake
1299: WHERE
1300: --NOT EXISTS (
1301: -- SELECT 'active accounts exist'
1302: -- FROM hz_cust_accounts acct

Line 1318: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm

1314: CURSOR c_from_rel_cust_id IS
1315: SELECT unique yt.cust_acct_relate_id,cm.customer_id,yt.cust_account_id,yt.related_cust_account_id,
1316: yt.customer_reciprocal_flag,nvl(yt.bill_to_flag,'N') bill_to_flag,
1317: nvl(yt.ship_to_flag,'N') ship_to_flag,yt.rowid,yt.org_id
1318: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm
1319: WHERE cm.request_id = req_id
1320: AND cm.process_flag = 'N'
1321: AND cm.set_number = set_num
1322: AND cm.duplicate_id <> cm.customer_id --merging sites for same customer

Line 1331: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm

1327: CURSOR c_from_cust_rel_id IS
1328: SELECT unique yt.cust_acct_relate_id,cm.customer_id,yt.cust_account_id,yt.related_cust_account_id,
1329: yt.customer_reciprocal_flag,nvl(yt.bill_to_flag,'N') bill_to_flag,
1330: nvl(yt.ship_to_flag,'N') ship_to_flag,yt.rowid,yt.org_id
1331: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm
1332: WHERE cm.request_id = req_id
1333: AND cm.process_flag = 'N'
1334: AND cm.set_number = set_num
1335: AND cm.duplicate_id <> cm.customer_id --merging sites for same customer

Line 1343: FROM hz_cust_acct_relate_all yt

1339: AND cm.org_id = yt.org_id;
1340: CURSOR c_to_rel_cust_id(p_cust_account_id NUMBER,p_related_cust_account_id NUMBER,p_org_id NUMBER) IS
1341: SELECT cust_account_id,related_cust_account_id,customer_reciprocal_flag,
1342: nvl(bill_to_flag,'N') bill_to_flag,nvl(ship_to_flag,'N') ship_to_flag
1343: FROM hz_cust_acct_relate_all yt
1344: WHERE yt.cust_account_id = p_cust_account_id
1345: AND yt.related_cust_account_id = p_related_cust_account_id
1346: AND yt.status = 'A'
1347: AND yt.org_id = p_org_id

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

1420: l_to_ship_to_flag := from_rec.ship_to_flag;
1421: l_update_flag := true;
1422: END IF;
1423: IF(l_update_flag) THEN
1424: UPDATE hz_cust_acct_relate_all SET bill_to_flag = l_to_bill_to_flag,ship_to_flag=l_to_ship_to_flag
1425: WHERE cust_account_id = l_to_cust_account_id
1426: AND related_cust_account_id = l_to_related_cust_account_id
1427: AND org_id = from_rec.org_id
1428: AND STATUS = 'A';

Line 1432: UPDATE hz_cust_acct_relate_all yt SET

1428: AND STATUS = 'A';
1429: END IF;
1430: END IF;
1431: --Inactivate the from account relationship
1432: UPDATE hz_cust_acct_relate_all yt SET
1433: status = 'I',
1434: last_update_date = sysdate,
1435: last_updated_by = arp_standard.profile.user_id,
1436: last_update_login = arp_standard.profile.last_update_login,

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

1482: l_to_ship_to_flag := from_rec.ship_to_flag;
1483: l_update_flag := true;
1484: END IF;
1485: IF(l_update_flag) THEN
1486: UPDATE hz_cust_acct_relate_all SET bill_to_flag = l_to_bill_to_flag,ship_to_flag=l_to_ship_to_flag
1487: WHERE cust_account_id = l_to_cust_account_id
1488: AND related_cust_account_id = l_to_related_cust_account_id
1489: AND org_id = from_rec.org_id
1490: AND STATUS = 'A';

Line 1494: UPDATE hz_cust_acct_relate_all yt SET

1490: AND STATUS = 'A';
1491: END IF;
1492: END IF;
1493: --Inactivate the from account relationships
1494: UPDATE hz_cust_acct_relate_all yt SET
1495: status = 'I',
1496: last_update_date = sysdate,
1497: last_updated_by = arp_standard.profile.user_id,
1498: last_update_login = arp_standard.profile.last_update_login,

Line 1518: /*UPDATE HZ_CUST_ACCT_RELATE_ALL yt

1514: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
1515: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_ACCT_RELATE', FALSE );
1516:
1517: --Start bug 7192302
1518: /*UPDATE HZ_CUST_ACCT_RELATE_ALL yt
1519: SET status = 'I',
1520: last_update_date = sysdate,
1521: last_updated_by = arp_standard.profile.user_id,
1522: last_update_login = arp_standard.profile.last_update_login,

Line 1548: UPDATE HZ_CUST_ACCT_RELATE_ALL YT

1544: AND m.set_number = set_num
1545: AND m.org_id = yt.org_id
1546: AND m.delete_duplicate_flag = 'N' );*/
1547:
1548: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1549: SET STATUS = 'I',
1550: LAST_UPDATE_DATE = SYSDATE,
1551: LAST_UPDATED_BY = arp_standard.profile.user_id ,
1552: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,

Line 1569: UPDATE HZ_CUST_ACCT_RELATE_ALL YT

1565: AND M.DELETE_DUPLICATE_FLAG = 'N' );
1566:
1567: g_count := sql%rowcount;
1568:
1569: UPDATE HZ_CUST_ACCT_RELATE_ALL YT
1570: SET STATUS = 'I',
1571: LAST_UPDATE_DATE = SYSDATE,
1572: LAST_UPDATED_BY = arp_standard.profile.user_id ,
1573: LAST_UPDATE_LOGIN = arp_standard.profile.last_update_login ,

Line 1608: UPDATE HZ_CUST_ACCT_RELATE_ALL yt --SSUptake

1604: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_ACCT_RELATE', FALSE );
1605:
1606: /************** from account update ************/
1607:
1608: UPDATE HZ_CUST_ACCT_RELATE_ALL yt --SSUptake
1609: SET status = 'D'
1610: WHERE
1611: --NOT EXISTS (
1612: -- SELECT 'accounts exist'

Line 1627: FROM HZ_CUST_ACCT_RELATE_ALL r, --SSUptake

1623: AND m.delete_duplicate_flag = 'Y'
1624: AND m.org_id = yt.org_id ) --SSUptake
1625: AND ( EXISTS (
1626: SELECT 'relationship already exists, cannot update'
1627: FROM HZ_CUST_ACCT_RELATE_ALL r, --SSUptake
1628: ra_customer_merges m
1629: WHERE m.customer_id = r.cust_account_id
1630: AND m.duplicate_id = yt.cust_account_id
1631: AND r.related_cust_account_id = yt.related_cust_account_id

Line 1669: UPDATE HZ_CUST_ACCT_RELATE_ALL yt

1665:
1666: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
1667: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_ACCT_RELATE', FALSE );
1668:
1669: UPDATE HZ_CUST_ACCT_RELATE_ALL yt
1670: SET status = 'D'
1671: WHERE
1672: --NOT EXISTS (
1673: -- SELECT 'accounts exist'

Line 1688: FROM HZ_CUST_ACCT_RELATE_ALL r,

1684: AND m.set_number = set_num
1685: AND m.delete_duplicate_flag = 'Y')
1686: AND ( EXISTS (
1687: SELECT 'relationship already exists, cannot update'
1688: FROM HZ_CUST_ACCT_RELATE_ALL r,
1689: ra_customer_merges m
1690: WHERE m.customer_id = r.related_cust_account_id
1691: AND m.duplicate_id = yt.related_cust_account_id
1692: AND r.cust_account_id = yt.cust_account_id

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

4356: FOR UPDATE NOWAIT;
4357:
4358: CURSOR cust_rel1 IS
4359: SELECT rel.cust_account_id
4360: FROM HZ_CUST_ACCT_RELATE_ALL rel, ra_customer_merges m --SSUptake
4361: WHERE cust_account_id = m.duplicate_id
4362: AND m.org_id = rel.org_id --SSUptake
4363: AND m.process_flag = 'N'
4364: AND m.request_id = req_id

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

4368: FOR UPDATE NOWAIT;
4369:
4370: CURSOR cust_rel2 IS
4371: SELECT rel.related_cust_account_id
4372: FROM HZ_CUST_ACCT_RELATE_ALL rel, ra_customer_merges m --SSUptake
4373: WHERE related_cust_account_id = m.duplicate_id
4374: AND m.org_id = rel.org_id --SSUptake
4375: AND m.process_flag = 'N'
4376: AND m.request_id = req_id

Line 4578: DELETE FROM HZ_CUST_ACCT_RELATE_ALL rel --SSUptake

4574: --lock rows
4575: OPEN cust_rel1;
4576: CLOSE cust_rel1;
4577:
4578: DELETE FROM HZ_CUST_ACCT_RELATE_ALL rel --SSUptake
4579: WHERE EXISTS (
4580: SELECT 'Y'
4581: FROM ra_customer_merges m
4582: WHERE m.duplicate_id = rel.cust_account_id

Line 4603: DELETE FROM HZ_CUST_ACCT_RELATE_ALL rel --SSUptake

4599: --lock rows
4600: OPEN cust_rel2;
4601: CLOSE cust_rel2;
4602:
4603: DELETE FROM HZ_CUST_ACCT_RELATE_ALL rel --SSUptake
4604: WHERE EXISTS (
4605: SELECT 'Y'
4606: FROM ra_customer_merges m
4607: WHERE m.duplicate_id = rel.related_cust_account_id

Line 7855: ---------Insert into hz_cust_acct_relate_all_m--------------

7851: AND su.org_id = m.org_id; --SSUptake
7852:
7853: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');
7854:
7855: ---------Insert into hz_cust_acct_relate_all_m--------------
7856: INSERT INTO hz_cust_acct_relate_all_m(
7857: customer_merge_header_id,
7858: cust_account_id ,
7859: related_cust_account_id ,

Line 7856: INSERT INTO hz_cust_acct_relate_all_m(

7852:
7853: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');
7854:
7855: ---------Insert into hz_cust_acct_relate_all_m--------------
7856: INSERT INTO hz_cust_acct_relate_all_m(
7857: customer_merge_header_id,
7858: cust_account_id ,
7859: related_cust_account_id ,
7860: last_update_date ,

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

7938: from ra_customer_merges cm
7939: where cm.process_flag = 'N'
7940: and cm.request_id = req_id
7941: and cm.set_number = set_num
7942: and cm.duplicate_id <> cm.customer_id) m,hz_cust_acct_relate_all yt --SSUptake
7943: WHERE ( yt.cust_account_id = duplicate_id OR
7944: yt.related_cust_account_id = duplicate_id )
7945: AND m.org_id = yt.org_id ; --SSUptake
7946:

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

7943: WHERE ( yt.cust_account_id = duplicate_id OR
7944: yt.related_cust_account_id = duplicate_id )
7945: AND m.org_id = yt.org_id ; --SSUptake
7946:
7947: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_RELATE_ALL_M');
7948:
7949:
7950: ---After storing the merge data sucessfully initialize the status to 0
7951: status := 0;

Line 7977: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE_ALL.CUST_ACCT_RELATE_ID%TYPE;

7973: p_cust_acct_relate_rec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCT_RELATE_REC_TYPE;
7974: x_return_status VARCHAR2(1);
7975: x_msg_count NUMBER;
7976: x_msg_data varchar2(2000);
7977: l_cust_acct_relate_id HZ_CUST_ACCT_RELATE_ALL.CUST_ACCT_RELATE_ID%TYPE;
7978: BEGIN
7979: HZ_CUST_ACCOUNT_V2PUB.get_cust_acct_relate_rec (
7980: FND_API.G_FALSE,
7981: p_cust_account_id,