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.HZ_DQM_SYNC dependencies on HZ_PARTIES

Line 595: AND pr.subject_table_name = 'HZ_PARTIES'

591: SELECT oc.org_contact_id
592: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc
593: WHERE pr.relationship_id = oc.party_relationship_id
594: AND pr.subject_id = p_party_id
595: AND pr.subject_table_name = 'HZ_PARTIES'
596: AND pr.object_table_name = 'HZ_PARTIES'
597: AND pr.directional_flag = 'F';
598: BEGIN
599: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');

Line 596: AND pr.object_table_name = 'HZ_PARTIES'

592: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc
593: WHERE pr.relationship_id = oc.party_relationship_id
594: AND pr.subject_id = p_party_id
595: AND pr.subject_table_name = 'HZ_PARTIES'
596: AND pr.object_table_name = 'HZ_PARTIES'
597: AND pr.directional_flag = 'F';
598: BEGIN
599: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
600: IF (L_REALTIME_SYNC_VALUE = 'Y') THEN

Line 661: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

657: END IF;
658: ELSIF (L_REALTIME_SYNC_VALUE = 'N') THEN
659: BEGIN
660: SELECT ps.party_id,p.party_type INTO l_party_id, l_party_type
661: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
662: WHERE party_site_id = p_party_site_id
663: AND p.PARTY_ID = ps.PARTY_ID;
664: EXCEPTION
665: /* Bug No: 2707873. Added this exception because the above sql

Line 677: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

673: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
674: WHERE r.party_id = l_party_id
675: AND r.relationship_id = oc.party_relationship_id
676: AND r.directional_flag='F'
677: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
678: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
679: EXCEPTION
680: WHEN NO_DATA_FOUND THEN
681: RETURN;

Line 678: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';

674: WHERE r.party_id = l_party_id
675: AND r.relationship_id = oc.party_relationship_id
676: AND r.directional_flag='F'
677: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
678: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
679: EXCEPTION
680: WHEN NO_DATA_FOUND THEN
681: RETURN;
682: END;

Line 726: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

722: SELECT r.object_id INTO l_party_id
723: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
724: WHERE oc.org_contact_id = p_org_contact_id
725: AND oc.party_relationship_id = r.relationship_id
726: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
727: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
728: AND subject_type ='PERSON'
729: AND DIRECTIONAL_FLAG= 'F'
730: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')

Line 727: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

723: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
724: WHERE oc.org_contact_id = p_org_contact_id
725: AND oc.party_relationship_id = r.relationship_id
726: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
727: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
728: AND subject_type ='PERSON'
729: AND DIRECTIONAL_FLAG= 'F'
730: AND (oc.status is null OR oc.status = 'A' or oc.status = 'I')
731: AND (r.status is null OR r.status = 'A' or r.status = 'I') ;

Line 786: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

782:
783: IF l_ot_table = 'HZ_PARTY_SITES' THEN
784: SELECT p.party_id, ps.party_site_id, party_type
785: INTO l_party_id1, l_party_site_id, l_party_type
786: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
787: WHERE party_site_id = l_ot_id
788: AND p.party_id = ps.party_id;
789:
790: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

Line 797: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

793: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
794: WHERE r.party_id = l_party_id1
795: AND r.relationship_id = oc.party_relationship_id
796: AND r.directional_flag='F'
797: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
798: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
799: EXCEPTION
800: WHEN NO_DATA_FOUND THEN
801: RETURN;

Line 798: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';

794: WHERE r.party_id = l_party_id1
795: AND r.relationship_id = oc.party_relationship_id
796: AND r.directional_flag='F'
797: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
798: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
799: EXCEPTION
800: WHEN NO_DATA_FOUND THEN
801: RETURN;
802: END;

Line 807: ELSIF l_ot_table = 'HZ_PARTIES' THEN

803: ELSE
804: l_party_id:=l_party_id1;
805: l_org_contact_id:=NULL;
806: END IF;
807: ELSIF l_ot_table = 'HZ_PARTIES' THEN
808: l_party_site_id := NULL;
809: SELECT party_type INTO l_party_type
810: FROM hz_parties
811: WHERE party_id = l_ot_id;

Line 810: FROM hz_parties

806: END IF;
807: ELSIF l_ot_table = 'HZ_PARTIES' THEN
808: l_party_site_id := NULL;
809: SELECT party_type INTO l_party_type
810: FROM hz_parties
811: WHERE party_id = l_ot_id;
812:
813: IF l_party_type <> 'PARTY_RELATIONSHIP' THEN
814: l_party_id := l_ot_id;

Line 823: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

819: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
820: WHERE r.party_id = l_ot_id
821: AND r.relationship_id = oc.party_relationship_id
822: AND r.directional_flag='F'
823: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
824: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN
827: RETURN;

Line 824: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';

820: WHERE r.party_id = l_ot_id
821: AND r.relationship_id = oc.party_relationship_id
822: AND r.directional_flag='F'
823: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
824: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN
827: RETURN;
828: END;

Line 937: FROM HZ_CUST_ACCOUNTS c, HZ_PARTIES p

933: ) IS
934:
935: CURSOR c_cust_party IS
936: SELECT c.PARTY_ID, p.PARTY_TYPE
937: FROM HZ_CUST_ACCOUNTS c, HZ_PARTIES p
938: WHERE c.cust_account_id = p_cust_acct_id
939: AND p.party_id = c.party_id
940: AND NOT EXISTS (
941: SELECT d.PARTY_ID

Line 1336: FROM HZ_PARTIES

1332:
1333: x_return_status := FND_API.G_RET_STS_SUCCESS;
1334:
1335: SELECT party_type INTO l_party_type
1336: FROM HZ_PARTIES
1337: WHERE party_id = p_from_id;
1338:
1339: IF l_party_type <> 'PARTY_RELATIONSHIP' THEN
1340: BEGIN

Line 1444: WHERE owner_table_name = 'HZ_PARTIES'

1440:
1441: CURSOR c_cp_org_contact (cp_id NUMBER) IS
1442: SELECT oc.org_contact_id
1443: FROM HZ_CONTACT_POINTS cp, HZ_RELATIONSHIPS rl, HZ_ORG_CONTACTS oc
1444: WHERE owner_table_name = 'HZ_PARTIES'
1445: AND contact_point_id = cp_id
1446: AND rl.PARTY_ID = cp.owner_table_id
1447: AND oc.party_relationship_id = rl.relationship_id
1448: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 1448: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1444: WHERE owner_table_name = 'HZ_PARTIES'
1445: AND contact_point_id = cp_id
1446: AND rl.PARTY_ID = cp.owner_table_id
1447: AND oc.party_relationship_id = rl.relationship_id
1448: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1449: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1450: AND rl.DIRECTIONAL_FLAG = 'F';
1451:
1452: CURSOR c_ps_org_contact (ps_id NUMBER) IS

Line 1449: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1445: AND contact_point_id = cp_id
1446: AND rl.PARTY_ID = cp.owner_table_id
1447: AND oc.party_relationship_id = rl.relationship_id
1448: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1449: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1450: AND rl.DIRECTIONAL_FLAG = 'F';
1451:
1452: CURSOR c_ps_org_contact (ps_id NUMBER) IS
1453: SELECT oc.org_contact_id

Line 1458: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1454: FROM HZ_PARTY_SITES ps, HZ_RELATIONSHIPS rl, HZ_ORG_CONTACTS oc
1455: WHERE ps.party_site_id = ps_id
1456: AND rl.PARTY_ID = ps.party_id
1457: AND oc.party_relationship_id = rl.relationship_id
1458: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1459: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1460: AND rl.DIRECTIONAL_FLAG = 'F';
1461:
1462: l_cp_party_site_id NUMBER;

Line 1459: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1455: WHERE ps.party_site_id = ps_id
1456: AND rl.PARTY_ID = ps.party_id
1457: AND oc.party_relationship_id = rl.relationship_id
1458: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1459: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1460: AND rl.DIRECTIONAL_FLAG = 'F';
1461:
1462: l_cp_party_site_id NUMBER;
1463: l_cp_org_contact_id NUMBER;

Line 1491: ELSIF l_ot_table = 'HZ_PARTIES' THEN

1487: SELECT party_id INTO l_party_id
1488: FROM HZ_PARTY_SITES
1489: WHERE party_site_id = l_ot_id;
1490:
1491: ELSIF l_ot_table = 'HZ_PARTIES' THEN
1492: SELECT party_type INTO l_party_type
1493: FROM hz_parties
1494: WHERE party_id = l_ot_id;
1495:

Line 1493: FROM hz_parties

1489: WHERE party_site_id = l_ot_id;
1490:
1491: ELSIF l_ot_table = 'HZ_PARTIES' THEN
1492: SELECT party_type INTO l_party_type
1493: FROM hz_parties
1494: WHERE party_id = l_ot_id;
1495:
1496: IF l_party_type = 'ORGANIZATION' OR l_party_type = 'PERSON' THEN
1497: l_party_id := l_ot_id;

Line 1502: AND subject_table_name = 'HZ_PARTIES'

1498: ELSIF l_party_type = 'PARTY_RELATIONSHIP' THEN
1499: SELECT relationship_id, object_id INTO l_pr_id, l_party_id
1500: FROM hz_relationships --bug 4500011 replaced hz_party_relationships with hz_relationships
1501: WHERE party_id = l_ot_id
1502: AND subject_table_name = 'HZ_PARTIES'
1503: AND object_table_name = 'HZ_PARTIES'
1504: AND directional_flag = 'F';
1505:
1506: SELECT count(1) INTO l_num_ocs

Line 1503: AND object_table_name = 'HZ_PARTIES'

1499: SELECT relationship_id, object_id INTO l_pr_id, l_party_id
1500: FROM hz_relationships --bug 4500011 replaced hz_party_relationships with hz_relationships
1501: WHERE party_id = l_ot_id
1502: AND subject_table_name = 'HZ_PARTIES'
1503: AND object_table_name = 'HZ_PARTIES'
1504: AND directional_flag = 'F';
1505:
1506: SELECT count(1) INTO l_num_ocs
1507: FROM HZ_ORG_CONTACTS

Line 1578: AND pr.subject_table_name = 'HZ_PARTIES'

1574: SELECT pr.party_id, pr.object_id INTO l_rel_party_id, l_party_id
1575: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc --bug 4500011 replaced hz_party_relationships with hz_relationships
1576: WHERE oc.org_contact_id = l_org_contact_id
1577: AND pr.relationship_id = oc.party_relationship_id
1578: AND pr.subject_table_name = 'HZ_PARTIES'
1579: AND pr.object_table_name = 'HZ_PARTIES'
1580: AND pr.directional_flag = 'F';
1581:
1582: SAVEPOINT contact_sync;

Line 1579: AND pr.object_table_name = 'HZ_PARTIES'

1575: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc --bug 4500011 replaced hz_party_relationships with hz_relationships
1576: WHERE oc.org_contact_id = l_org_contact_id
1577: AND pr.relationship_id = oc.party_relationship_id
1578: AND pr.subject_table_name = 'HZ_PARTIES'
1579: AND pr.object_table_name = 'HZ_PARTIES'
1580: AND pr.directional_flag = 'F';
1581:
1582: SAVEPOINT contact_sync;
1583: BEGIN

Line 1599: WHERE owner_table_name = 'HZ_PARTIES'

1595: SET party_id = l_party_id
1596: WHERE contact_point_id in (
1597: SELECT contact_point_id
1598: FROM HZ_CONTACT_POINTS
1599: WHERE owner_table_name = 'HZ_PARTIES'
1600: AND owner_table_id = l_rel_party_id
1601: AND (nvl(STATUS,'A') = 'A' OR nvl(STATUS,'A')='I'));
1602:
1603:

Line 1669: select party_type into l_party_type from hz_parties where party_id = l_party_id(i);

1665:
1666: FOR i in 1..l_party_id.COUNT LOOP
1667: BEGIN
1668: IF (l_entity(i) = 'PARTY') THEN
1669: select party_type into l_party_type from hz_parties where party_id = l_party_id(i);
1670: hz_trans_pkg.set_party_type(l_party_type);
1671: HZ_STAGE_MAP_TRANSFORM.sync_single_party(l_party_id(i), l_party_type, l_operation(i));
1672: i_party := true;
1673: ELSIF (l_entity(i) = 'PARTY_SITES') THEN