APPS.HZ_DQM_SYNC dependencies on HZ_PARTY_SITES

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 794: IF l_ot_table = 'HZ_PARTY_SITES' THEN

790: SELECT owner_table_name,owner_table_id INTO l_ot_table, l_ot_id
791: FROM hz_contact_points
792: WHERE contact_point_id = p_contact_point_id;
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

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 909: FROM hz_party_Sites

905: ) IS
906:
907: CURSOR party_sites IS
908: SELECT party_site_id
909: FROM hz_party_Sites
910: WHERE location_id = p_location_id
911: AND (status = 'A' or status = 'I') ;
912:
913: l_party_site_id NUMBER;

Line 1459: FROM HZ_PARTY_SITES

1455: END IF;
1456:
1457: IF p_from_fk_id = p_to_fk_id THEN--Not Sure this will ever occur as Merge always deletes and creates a new PS for Merge/Transfer Case.
1458: SELECT party_id INTO l_party_id
1459: FROM HZ_PARTY_SITES
1460: WHERE party_site_id = p_from_id;
1461:
1462: l_party_site_id := p_from_id;
1463:

Line 1509: WHERE owner_table_name = 'HZ_PARTY_SITES'

1505:
1506: CURSOR c_cp_party_site (cp_id NUMBER) IS
1507: SELECT owner_table_id
1508: FROM HZ_CONTACT_POINTS
1509: WHERE owner_table_name = 'HZ_PARTY_SITES'
1510: AND contact_point_id = cp_id;
1511:
1512: CURSOR c_cp_org_contact (cp_id NUMBER) IS
1513: SELECT oc.org_contact_id

Line 1525: FROM HZ_PARTY_SITES ps, HZ_RELATIONSHIPS rl, HZ_ORG_CONTACTS oc

1521: AND rl.DIRECTIONAL_FLAG = 'F';
1522:
1523: CURSOR c_ps_org_contact (ps_id NUMBER) IS
1524: SELECT oc.org_contact_id
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'

Line 1570: IF l_ot_table = 'HZ_PARTY_SITES' THEN

1566: SELECT owner_table_name,owner_table_id INTO l_ot_table, l_ot_id
1567: FROM hz_contact_points
1568: WHERE contact_point_id = l_contact_point_id;
1569:
1570: IF l_ot_table = 'HZ_PARTY_SITES' THEN
1571: SELECT party_id INTO l_party_id
1572: FROM HZ_PARTY_SITES
1573: WHERE party_site_id = l_ot_id;
1574:

Line 1572: FROM HZ_PARTY_SITES

1568: WHERE contact_point_id = l_contact_point_id;
1569:
1570: IF l_ot_table = 'HZ_PARTY_SITES' 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

Line 1681: FROM HZ_PARTY_SITES

1677: UPDATE HZ_STAGED_PARTY_SITES
1678: SET party_id = l_party_id
1679: WHERE party_site_id in (
1680: SELECT party_site_id
1681: FROM HZ_PARTY_SITES
1682: WHERE party_id = l_rel_party_id
1683: AND (nvl(STATUS,'A') = 'A' OR nvl(STATUS,'A')='I'));
1684:
1685: UPDATE HZ_STAGED_CONTACT_POINTS

Line 1703: FROM HZ_PARTY_SITES

1699: END;
1700: ELSIF ( L_REALTIME_SYNC_VALUE = 'N') THEN----Bug 13810656 Deferring the update of relationships for Merge flow
1701: BEGIN
1702: FOR I IN (SELECT party_site_id
1703: FROM HZ_PARTY_SITES
1704: WHERE party_id = l_rel_party_id
1705: AND (nvl(STATUS,'A') = 'A' OR nvl(STATUS,'A')='I'))
1706: LOOP
1707: sync_party_site (I.party_site_id, 'U');