APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_PARTY_SITES

Line 2114: IF l_ot_table = 'HZ_PARTY_SITES' THEN

2110: SELECT owner_table_name,owner_table_id INTO l_ot_table, l_ot_id
2111: FROM hz_contact_points
2112: WHERE contact_point_id = p_contact_point_id;
2113:
2114: IF l_ot_table = 'HZ_PARTY_SITES' THEN
2115: SELECT p.party_id, ps.party_site_id, party_type
2116: INTO l_party_id1, l_party_site_id, l_party_type
2117: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
2118: WHERE party_site_id = l_ot_id

Line 2117: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

2113:
2114: IF l_ot_table = 'HZ_PARTY_SITES' THEN
2115: SELECT p.party_id, ps.party_site_id, party_type
2116: INTO l_party_id1, l_party_site_id, l_party_type
2117: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
2118: WHERE party_site_id = l_ot_id
2119: AND p.party_id = ps.party_id;
2120:
2121: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

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

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
2512: EXIT;
2513: END IF;

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

2547: , H_TX22(1)
2548: , H_TX24(1)
2549: , H_TX25(1)
2550: , H_TX28(1)
2551: FROM HZ_PARTY_SITES ps, HZ_DQM_SYNC_INTERFACE d, HZ_LOCATIONS l
2552: WHERE d.ENTITY='PARTY_SITES'
2553: AND ps.party_site_id = p_party_site_id
2554: AND d.record_id = ps.party_site_id
2555: AND ps.location_id = l.location_id

Line 2722: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

2718: l_org_contact_id := -1;
2719:
2720: BEGIN
2721: SELECT ps.party_id,p.party_type INTO l_party_id1, l_party_type
2722: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
2723: WHERE party_site_id = p_party_site_id
2724: AND p.PARTY_ID = ps.PARTY_ID;
2725: -- take care of invalid party ids
2726: EXCEPTION

Line 2778: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l

2774: ,H_TX22(1)
2775: ,H_TX24(1)
2776: ,H_TX25(1)
2777: ,H_TX28(1)
2778: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l
2779: WHERE
2780: ps.party_site_id = p_party_site_id
2781: AND ps.location_id = l.location_id
2782: AND (ps.status is null OR ps.status = 'A' OR ps.status = 'I')

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

3373: ,l.COUNTRY
3374: ,ps.IDENTIFYING_ADDRESS_FLAG
3375: ,ps.STATUS
3376: ,l.ADDRESS1
3377: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_PARTY_SITES ps, HZ_LOCATIONS l
3378: WHERE dsi.record_id = ps.party_site_id
3379: AND dsi.entity = 'PARTY_SITES'
3380: AND dsi.operation = p_operation
3381: AND dsi.staged_flag = 'N'

Line 4417: FROM hz_locations l, hz_party_sites ps,

4413: ,l.COUNTRY
4414: ,ps.IDENTIFYING_ADDRESS_FLAG
4415: ,ps.STATUS
4416: ,l.ADDRESS1
4417: FROM hz_locations l, hz_party_sites ps,
4418: hz_imp_addresses_sg addr_sg, hz_imp_batch_details bd
4419: WHERE l.request_id = bd.main_conc_req_id
4420: AND bd.batch_id = addr_sg.batch_id
4421: AND l.location_id = ps.location_id

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

4515: SELECT
4516: /*+ ORDERED USE_NL(cp) */
4517: cp.CONTACT_POINT_ID
4518: ,cps.party_id
4519: ,decode (cp.owner_table_name, 'HZ_PARTY_SITES', cp.owner_table_id, NULL) party_site_id
4520: ,NULL
4521: ,cp.CONTACT_POINT_TYPE
4522: ,cp.STATUS
4523: ,cp.ROWID