APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_DQM_STAGE_GT

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

778: l_st:= l_st+SQL%ROWCOUNT+1;
779: END;
780: END LOOP;
781: FORALL I in H_P_PARTY_ID.FIRST..H_P_PARTY_ID.LAST
782: INSERT INTO HZ_DQM_STAGE_GT ( PARTY_ID, OWNER_ID, PARTY_INDEX) VALUES (
783: H_P_PARTY_ID(I),H_P_PARTY_ID(I),H_PARTY_INDEX(I));
784: insert_stage_contacts;
785: insert_stage_party_sites;
786: insert_stage_contact_pts;

Line 1421: FROM HZ_DQM_STAGE_GT g, HZ_RELATIONSHIPS r,

1417: oc.ORG_CONTACT_ID , r.OBJECT_ID, r.PARTY_ID, g.PARTY_INDEX, r.STATUS
1418: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
1419: ,oc.CONTACT_NUMBER
1420: ,oc.JOB_TITLE
1421: FROM HZ_DQM_STAGE_GT g, HZ_RELATIONSHIPS r,
1422: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
1423: WHERE oc.party_relationship_id = r.relationship_id
1424: AND r.object_id = g.party_id
1425: AND r.subject_id = pp.party_id

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

1517: l_st:= l_st+SQL%ROWCOUNT+1;
1518: END;
1519: END LOOP;
1520: FORALL I in H_C_PARTY_ID.FIRST..H_C_PARTY_ID.LAST
1521: INSERT INTO HZ_DQM_STAGE_GT(PARTY_ID,OWNER_ID,ORG_CONTACT_ID,PARTY_INDEX)
1522: SELECT H_C_PARTY_ID(I), H_R_PARTY_ID(I), H_ORG_CONTACT_ID(I), H_PARTY_INDEX(I)
1523: FROM DUAL WHERE H_R_PARTY_ID(I) IS NOT NULL;
1524: IF l_last_fetch THEN
1525: EXIT;

Line 1825: FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp

1821: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
1822: ,cp.PHONE_LINE_TYPE
1823: ,cp.STATUS
1824: ,cp.CONTACT_POINT_PURPOSE
1825: FROM HZ_DQM_STAGE_GT g,HZ_CONTACT_POINTS cp
1826: WHERE cp.owner_table_id = g.owner_id
1827: AND cp.OWNER_TABLE_NAME = nvl(g.owner_table,'HZ_PARTIES')
1828: AND (cp.status is null OR cp.status = 'A' or cp.status = 'I');
1829:

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

2376: ,l.COUNTRY
2377: ,ps.IDENTIFYING_ADDRESS_FLAG
2378: ,ps.STATUS
2379: ,l.ADDRESS1
2380: FROM HZ_DQM_STAGE_GT g, HZ_PARTY_SITES ps, HZ_LOCATIONS l
2381: WHERE ps.PARTY_ID = g.owner_id
2382: AND (ps.status is null OR ps.status = 'A' OR ps.status = 'I')
2383: AND ps.location_id = l.location_id;
2384: BEGIN

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

2529: l_st:= l_st+SQL%ROWCOUNT+1;
2530: END;
2531: END LOOP;
2532: FORALL I in H_PS_PARTY_ID.FIRST..H_PS_PARTY_ID.LAST
2533: INSERT INTO HZ_DQM_STAGE_GT (PARTY_ID, OWNER_ID, OWNER_TABLE, PARTY_SITE_ID,
2534: ORG_CONTACT_ID,PARTY_INDEX) VALUES (
2535: H_PS_PARTY_ID(I),H_PARTY_SITE_ID(I),'HZ_PARTY_SITES',H_PARTY_SITE_ID(I),
2536: H_PS_ORG_CONTACT_ID(I),H_PARTY_INDEX(I));
2537: IF l_last_fetch THEN