DBA Data[Home] [Help]

APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_LOCATIONS

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