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 727: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 728: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 738: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

734: SELECT r.object_id INTO l_party_id
735: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
736: WHERE oc.org_contact_id = p_org_contact_id
737: AND oc.party_relationship_id = r.relationship_id
738: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
739: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
740: AND subject_type ='PERSON'
741: AND DIRECTIONAL_FLAG= 'F';
742: END IF;

Line 739: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

735: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
736: WHERE oc.org_contact_id = p_org_contact_id
737: AND oc.party_relationship_id = r.relationship_id
738: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
739: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
740: AND subject_type ='PERSON'
741: AND DIRECTIONAL_FLAG= 'F';
742: END IF;
743:

Line 797: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

793:
794: IF l_ot_table = 'HZ_PARTY_SITES' THEN
795: SELECT p.party_id, ps.party_site_id, party_type
796: INTO l_party_id1, l_party_site_id, l_party_type
797: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
798: WHERE party_site_id = l_ot_id
799: AND p.party_id = ps.party_id;
800:
801: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

Line 808: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

804: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
805: WHERE r.party_id = l_party_id1
806: AND r.relationship_id = oc.party_relationship_id
807: AND r.directional_flag='F'
808: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
809: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
810: EXCEPTION
811: WHEN NO_DATA_FOUND THEN
812: RETURN;

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

805: WHERE r.party_id = l_party_id1
806: AND r.relationship_id = oc.party_relationship_id
807: AND r.directional_flag='F'
808: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
809: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
810: EXCEPTION
811: WHEN NO_DATA_FOUND THEN
812: RETURN;
813: END;

Line 818: ELSIF l_ot_table = 'HZ_PARTIES' THEN

814: ELSE
815: l_party_id:=l_party_id1;
816: l_org_contact_id:=NULL;
817: END IF;
818: ELSIF l_ot_table = 'HZ_PARTIES' THEN
819: l_party_site_id := NULL;
820: SELECT party_type INTO l_party_type
821: FROM hz_parties
822: WHERE party_id = l_ot_id;

Line 821: FROM hz_parties

817: END IF;
818: ELSIF l_ot_table = 'HZ_PARTIES' THEN
819: l_party_site_id := NULL;
820: SELECT party_type INTO l_party_type
821: FROM hz_parties
822: WHERE party_id = l_ot_id;
823:
824: IF l_party_type <> 'PARTY_RELATIONSHIP' THEN
825: l_party_id := l_ot_id;

Line 834: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

830: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
831: WHERE r.party_id = l_ot_id
832: AND r.relationship_id = oc.party_relationship_id
833: AND r.directional_flag='F'
834: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
835: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
836: EXCEPTION
837: WHEN NO_DATA_FOUND THEN
838: RETURN;

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

831: WHERE r.party_id = l_ot_id
832: AND r.relationship_id = oc.party_relationship_id
833: AND r.directional_flag='F'
834: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
835: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES';
836: EXCEPTION
837: WHEN NO_DATA_FOUND THEN
838: RETURN;
839: END;

Line 948: FROM HZ_CUST_ACCOUNTS c, HZ_PARTIES p

944: ) IS
945:
946: CURSOR c_cust_party IS
947: SELECT c.PARTY_ID, p.PARTY_TYPE
948: FROM HZ_CUST_ACCOUNTS c, HZ_PARTIES p
949: WHERE c.cust_account_id = p_cust_acct_id
950: AND p.party_id = c.party_id
951: AND NOT EXISTS (
952: SELECT d.PARTY_ID

Line 1387: FROM HZ_PARTIES

1383: x_return_status := FND_API.G_RET_STS_SUCCESS;
1384: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1385:
1386: SELECT party_type INTO l_party_type
1387: FROM HZ_PARTIES
1388: WHERE party_id = p_from_id;
1389:
1390: --Bug 9249643
1391: IF l_party_type='ORGANIZATION' THEN

Line 1515: WHERE owner_table_name = 'HZ_PARTIES'

1511:
1512: CURSOR c_cp_org_contact (cp_id NUMBER) IS
1513: SELECT oc.org_contact_id
1514: FROM HZ_CONTACT_POINTS cp, HZ_RELATIONSHIPS rl, HZ_ORG_CONTACTS oc
1515: WHERE owner_table_name = 'HZ_PARTIES'
1516: AND contact_point_id = cp_id
1517: AND rl.PARTY_ID = cp.owner_table_id
1518: AND oc.party_relationship_id = rl.relationship_id
1519: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 1519: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1515: WHERE owner_table_name = 'HZ_PARTIES'
1516: AND contact_point_id = cp_id
1517: AND rl.PARTY_ID = cp.owner_table_id
1518: AND oc.party_relationship_id = rl.relationship_id
1519: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1520: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1521: AND rl.DIRECTIONAL_FLAG = 'F';
1522:
1523: CURSOR c_ps_org_contact (ps_id NUMBER) IS

Line 1520: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1516: AND contact_point_id = cp_id
1517: AND rl.PARTY_ID = cp.owner_table_id
1518: AND oc.party_relationship_id = rl.relationship_id
1519: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1520: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1521: AND rl.DIRECTIONAL_FLAG = 'F';
1522:
1523: CURSOR c_ps_org_contact (ps_id NUMBER) IS
1524: SELECT oc.org_contact_id

Line 1529: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1525: FROM HZ_PARTY_SITES ps, HZ_RELATIONSHIPS rl, HZ_ORG_CONTACTS oc
1526: WHERE ps.party_site_id = ps_id
1527: AND rl.PARTY_ID = ps.party_id
1528: AND oc.party_relationship_id = rl.relationship_id
1529: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1530: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1531: AND rl.DIRECTIONAL_FLAG = 'F';
1532:
1533: l_cp_party_site_id NUMBER;

Line 1530: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1526: WHERE ps.party_site_id = ps_id
1527: AND rl.PARTY_ID = ps.party_id
1528: AND oc.party_relationship_id = rl.relationship_id
1529: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1530: AND rl.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1531: AND rl.DIRECTIONAL_FLAG = 'F';
1532:
1533: l_cp_party_site_id NUMBER;
1534: l_cp_org_contact_id NUMBER;

Line 1575: ELSIF l_ot_table = 'HZ_PARTIES' THEN

1571: SELECT party_id INTO l_party_id
1572: FROM HZ_PARTY_SITES
1573: WHERE party_site_id = l_ot_id;
1574:
1575: ELSIF l_ot_table = 'HZ_PARTIES' THEN
1576: SELECT party_type INTO l_party_type
1577: FROM hz_parties
1578: WHERE party_id = l_ot_id;
1579:

Line 1577: FROM hz_parties

1573: WHERE party_site_id = l_ot_id;
1574:
1575: ELSIF l_ot_table = 'HZ_PARTIES' THEN
1576: SELECT party_type INTO l_party_type
1577: FROM hz_parties
1578: WHERE party_id = l_ot_id;
1579:
1580: IF l_party_type = 'ORGANIZATION' OR l_party_type = 'PERSON' THEN
1581: l_party_id := l_ot_id;

Line 1586: AND subject_table_name = 'HZ_PARTIES'

1582: ELSIF l_party_type = 'PARTY_RELATIONSHIP' THEN
1583: SELECT relationship_id, object_id INTO l_pr_id, l_party_id
1584: FROM hz_relationships --bug 4500011 replaced hz_party_relationships with hz_relationships
1585: WHERE party_id = l_ot_id
1586: AND subject_table_name = 'HZ_PARTIES'
1587: AND object_table_name = 'HZ_PARTIES'
1588: AND directional_flag = 'F';
1589:
1590: SELECT count(1) INTO l_num_ocs

Line 1587: AND object_table_name = 'HZ_PARTIES'

1583: SELECT relationship_id, object_id INTO l_pr_id, l_party_id
1584: FROM hz_relationships --bug 4500011 replaced hz_party_relationships with hz_relationships
1585: WHERE party_id = l_ot_id
1586: AND subject_table_name = 'HZ_PARTIES'
1587: AND object_table_name = 'HZ_PARTIES'
1588: AND directional_flag = 'F';
1589:
1590: SELECT count(1) INTO l_num_ocs
1591: FROM HZ_ORG_CONTACTS

Line 1668: AND pr.subject_table_name = 'HZ_PARTIES'

1664: SELECT pr.party_id, pr.object_id INTO l_rel_party_id, l_party_id
1665: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc --bug 4500011 replaced hz_party_relationships with hz_relationships
1666: WHERE oc.org_contact_id = l_org_contact_id
1667: AND pr.relationship_id = oc.party_relationship_id
1668: AND pr.subject_table_name = 'HZ_PARTIES'
1669: AND pr.object_table_name = 'HZ_PARTIES'
1670: AND pr.directional_flag = 'F';
1671:
1672: SAVEPOINT contact_sync;

Line 1669: AND pr.object_table_name = 'HZ_PARTIES'

1665: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc --bug 4500011 replaced hz_party_relationships with hz_relationships
1666: WHERE oc.org_contact_id = l_org_contact_id
1667: AND pr.relationship_id = oc.party_relationship_id
1668: AND pr.subject_table_name = 'HZ_PARTIES'
1669: AND pr.object_table_name = 'HZ_PARTIES'
1670: AND pr.directional_flag = 'F';
1671:
1672: SAVEPOINT contact_sync;
1673: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN

Line 1690: WHERE owner_table_name = 'HZ_PARTIES'

1686: SET party_id = l_party_id
1687: WHERE contact_point_id in (
1688: SELECT contact_point_id
1689: FROM HZ_CONTACT_POINTS
1690: WHERE owner_table_name = 'HZ_PARTIES'
1691: AND owner_table_id = l_rel_party_id
1692: AND (nvl(STATUS,'A') = 'A' OR nvl(STATUS,'A')='I'));
1693:
1694:

Line 1712: WHERE owner_table_name = 'HZ_PARTIES'

1708: END LOOP;
1709:
1710: FOR I IN (SELECT contact_point_id
1711: FROM HZ_CONTACT_POINTS
1712: WHERE owner_table_name = 'HZ_PARTIES'
1713: AND owner_table_id = l_rel_party_id
1714: AND (nvl(STATUS,'A') = 'A' OR nvl(STATUS,'A')='I'))
1715: LOOP
1716: sync_contact_point (I.contact_point_id, 'U');

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

1784:
1785: FOR i in 1..l_party_id.COUNT LOOP
1786: BEGIN
1787: IF (l_entity(i) = 'PARTY') THEN
1788: select party_type into l_party_type from hz_parties where party_id = l_party_id(i);
1789: hz_trans_pkg.set_party_type(l_party_type);
1790: HZ_STAGE_MAP_TRANSFORM.sync_single_party(l_party_id(i), l_party_type, l_operation(i));
1791: i_party := true;
1792: ELSIF (l_entity(i) = 'PARTY_SITES') THEN