APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_DQM_STAGE_GT

Line 756: INSERT INTO HZ_DQM_STAGE_GT ( PARTY_ID, OWNER_ID, PARTY_INDEX) VALUES (

752: l_st:= l_st+SQL%ROWCOUNT+1;
753: END;
754: END LOOP;
755: FORALL I in H_P_PARTY_ID.FIRST..H_P_PARTY_ID.LAST
756: INSERT INTO HZ_DQM_STAGE_GT ( PARTY_ID, OWNER_ID, PARTY_INDEX) VALUES (
757: H_P_PARTY_ID(I),H_P_PARTY_ID(I),H_PARTY_INDEX(I));
758: insert_stage_contacts;
759: insert_stage_party_sites;
760: insert_stage_contact_pts;

Line 1395: FROM HZ_DQM_STAGE_GT g, HZ_RELATIONSHIPS r,

1391: oc.ORG_CONTACT_ID , r.OBJECT_ID, r.PARTY_ID, g.PARTY_INDEX, r.STATUS
1392: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
1393: ,oc.CONTACT_NUMBER
1394: ,oc.JOB_TITLE
1395: FROM HZ_DQM_STAGE_GT g, HZ_RELATIONSHIPS r,
1396: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
1397: WHERE oc.party_relationship_id = r.relationship_id
1398: AND r.object_id = g.party_id
1399: AND r.subject_id = pp.party_id

Line 1495: INSERT INTO HZ_DQM_STAGE_GT(PARTY_ID,OWNER_ID,ORG_CONTACT_ID,PARTY_INDEX)

1491: l_st:= l_st+SQL%ROWCOUNT+1;
1492: END;
1493: END LOOP;
1494: FORALL I in H_C_PARTY_ID.FIRST..H_C_PARTY_ID.LAST
1495: INSERT INTO HZ_DQM_STAGE_GT(PARTY_ID,OWNER_ID,ORG_CONTACT_ID,PARTY_INDEX)
1496: SELECT H_C_PARTY_ID(I), H_R_PARTY_ID(I), H_ORG_CONTACT_ID(I), H_PARTY_INDEX(I)
1497: FROM DUAL WHERE H_R_PARTY_ID(I) IS NOT NULL;
1498: IF l_last_fetch THEN
1499: EXIT;

Line 1799: FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp

1795: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
1796: ,cp.PHONE_LINE_TYPE
1797: ,cp.STATUS
1798: ,cp.CONTACT_POINT_PURPOSE
1799: FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp
1800: WHERE cp.owner_table_id = g.owner_id
1801: AND cp.OWNER_TABLE_NAME = nvl(g.owner_table,'HZ_PARTIES')
1802: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I');
1803:

Line 2354: FROM HZ_DQM_STAGE_GT g, HZ_PARTY_SITES ps, HZ_LOCATIONS l

2350: ,l.COUNTRY
2351: ,ps.IDENTIFYING_ADDRESS_FLAG
2352: ,ps.STATUS
2353: ,l.ADDRESS1
2354: FROM HZ_DQM_STAGE_GT g, HZ_PARTY_SITES ps, HZ_LOCATIONS l
2355: WHERE ps.PARTY_ID = g.owner_id
2356: AND (ps.status is null OR ps.status = 'A' OR ps.status = 'I')
2357: AND ps.location_id = l.location_id;
2358: BEGIN

Line 2507: INSERT INTO HZ_DQM_STAGE_GT (PARTY_ID, OWNER_ID, OWNER_TABLE, PARTY_SITE_ID,

2503: l_st:= l_st+SQL%ROWCOUNT+1;
2504: END;
2505: END LOOP;
2506: FORALL I in H_PS_PARTY_ID.FIRST..H_PS_PARTY_ID.LAST
2507: INSERT INTO HZ_DQM_STAGE_GT (PARTY_ID, OWNER_ID, OWNER_TABLE, PARTY_SITE_ID,
2508: ORG_CONTACT_ID,PARTY_INDEX) VALUES (
2509: H_PS_PARTY_ID(I),H_PARTY_SITE_ID(I),'HZ_PARTY_SITES',H_PARTY_SITE_ID(I),
2510: H_PS_ORG_CONTACT_ID(I),H_PARTY_INDEX(I));
2511: IF l_last_fetch THEN