APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_LOCATIONS

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 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 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