APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_PARTY_SITES

Line 2140: IF l_ot_table = 'HZ_PARTY_SITES' THEN

2136: SELECT owner_table_name,owner_table_id INTO l_ot_table, l_ot_id
2137: FROM hz_contact_points
2138: WHERE contact_point_id = p_contact_point_id;
2139:
2140: IF l_ot_table = 'HZ_PARTY_SITES' THEN
2141: SELECT p.party_id, ps.party_site_id, party_type
2142: INTO l_party_id1, l_party_site_id, l_party_type
2143: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
2144: WHERE party_site_id = l_ot_id

Line 2143: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

2139:
2140: IF l_ot_table = 'HZ_PARTY_SITES' THEN
2141: SELECT p.party_id, ps.party_site_id, party_type
2142: INTO l_party_id1, l_party_site_id, l_party_type
2143: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
2144: WHERE party_site_id = l_ot_id
2145: AND p.party_id = ps.party_id;
2146:
2147: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

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 2535: H_PS_PARTY_ID(I),H_PARTY_SITE_ID(I),'HZ_PARTY_SITES',H_PARTY_SITE_ID(I),

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
2538: EXIT;
2539: END IF;

Line 2577: FROM HZ_PARTY_SITES ps, HZ_DQM_SYNC_INTERFACE d, HZ_LOCATIONS l

2573: , H_TX22(1)
2574: , H_TX24(1)
2575: , H_TX25(1)
2576: , H_TX28(1)
2577: FROM HZ_PARTY_SITES ps, HZ_DQM_SYNC_INTERFACE d, HZ_LOCATIONS l
2578: WHERE d.ENTITY='PARTY_SITES'
2579: AND ps.party_site_id = p_party_site_id
2580: AND d.record_id = ps.party_site_id
2581: AND ps.location_id = l.location_id

Line 2748: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

2744: l_org_contact_id := -1;
2745:
2746: BEGIN
2747: SELECT ps.party_id,p.party_type INTO l_party_id1, l_party_type
2748: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
2749: WHERE party_site_id = p_party_site_id
2750: AND p.PARTY_ID = ps.PARTY_ID;
2751: -- take care of invalid party ids
2752: EXCEPTION

Line 2804: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l

2800: ,H_TX22(1)
2801: ,H_TX24(1)
2802: ,H_TX25(1)
2803: ,H_TX28(1)
2804: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l
2805: WHERE
2806: ps.party_site_id = p_party_site_id
2807: AND ps.location_id = l.location_id
2808: AND (ps.status is null OR ps.status = 'A' OR ps.status = 'I')

Line 3403: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_PARTY_SITES ps, HZ_LOCATIONS l

3399: ,l.COUNTRY
3400: ,ps.IDENTIFYING_ADDRESS_FLAG
3401: ,ps.STATUS
3402: ,l.ADDRESS1
3403: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_PARTY_SITES ps, HZ_LOCATIONS l
3404: WHERE dsi.record_id = ps.party_site_id
3405: AND dsi.entity = 'PARTY_SITES'
3406: AND dsi.operation = p_operation
3407: AND dsi.staged_flag = 'N'

Line 4443: FROM hz_locations l, hz_party_sites ps,

4439: ,l.COUNTRY
4440: ,ps.IDENTIFYING_ADDRESS_FLAG
4441: ,ps.STATUS
4442: ,l.ADDRESS1
4443: FROM hz_locations l, hz_party_sites ps,
4444: hz_imp_addresses_sg addr_sg, hz_imp_batch_details bd
4445: WHERE l.request_id = bd.main_conc_req_id
4446: AND bd.batch_id = addr_sg.batch_id
4447: AND l.location_id = ps.location_id

Line 4545: ,decode (cp.owner_table_name, 'HZ_PARTY_SITES', cp.owner_table_id, NULL) party_site_id

4541: SELECT
4542: /*+ ORDERED USE_NL(cp) */
4543: cp.CONTACT_POINT_ID
4544: ,cps.party_id
4545: ,decode (cp.owner_table_name, 'HZ_PARTY_SITES', cp.owner_table_id, NULL) party_site_id
4546: ,NULL
4547: ,cp.CONTACT_POINT_TYPE
4548: ,cp.STATUS
4549: ,cp.ROWID