[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT flv.meaning
FROM fnd_lookup_values flv, fnd_lookup_types flt
WHERE flv.lookup_type = flt.lookup_type
AND flv.lookup_code = c_lookup_code
AND flt.lookup_type = c_lookup_type
AND flv.language = USERENV('LANG')
AND nvl(flv.start_date_active,sysdate)<=sysdate
AND nvl(flv.end_date_active,sysdate)>=sysdate
AND flv.enabled_flag = 'Y';
SELECT HOU.NAME ORGANIZATION_NAME
FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP
WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1 = 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND ( HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
AND HOU.ORGANIZATION_ID = c_object_value_num;
select hp.party_name
from hz_parties hp ,
hz_cust_accounts hcas
where hcas.cust_account_id = c_object_value_num
and hcas.party_id = hp.party_id;
select hp.party_name
from hz_parties hp , wsh_carriers wc
where wc.carrier_id = c_object_value_num
and wc.carrier_id = hp.party_id;
select hp.party_name
from hz_parties hp,
po_vendors po,
hz_relationships rel
where hp.party_id = c_object_value_num
AND rel.relationship_type = 'POS_VENDOR_PARTY'
and rel.object_id = hp.party_id
and rel.object_table_name = 'HZ_PARTIES'
and rel.object_type = 'ORGANIZATION'
and rel.subject_table_name = 'PO_VENDORS'
and rel.subject_id = po.vendor_id
and rel.subject_type = 'POS_VENDOR';
SELECT wl.wsh_location_id facility_id,
haou.organization_id company_id,
haou.name company_name,
'ORGANIZATION' company_type,
nvl(nvl(flp.facility_code,wl.location_code),to_char(wl.wsh_location_id)) facility_code,
nvl(flp.description,wl.ui_location_code) description
FROM HR_ORGANIZATION_UNITS HAOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP,
wsh_locations wl, fte_location_parameters flp
WHERE haou.location_id = wl.source_location_id
AND wl.location_source_code = 'HR'
AND HAOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1 = 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND ( HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
AND wl.wsh_location_id = flp.location_id (+)
AND wl.wsh_location_id = c_location_id
union
SELECT wl.wsh_location_id facility_id,
hcas.cust_account_id company_id,
hp.party_name company_name,
'CUSTOMER' company_type,
nvl(nvl(flp.facility_code,wl.location_code),to_char(wl.wsh_location_id)) facility_code,
nvl(flp.description,wl.ui_location_code) description
from hz_parties hp , hz_party_sites hps,
hz_cust_acct_sites_all hcas,
wsh_locations wl,
fte_location_parameters flp
where hcas.party_site_id = hps.party_site_id
and hps.party_id = hp.party_id
AND hps.location_id = wl.source_location_id
and wl.location_source_code = 'HZ'
and hp.status='A'
AND wl.wsh_location_id = flp.location_id (+)
AND wl.wsh_location_id = c_location_id
union
SELECT wl.wsh_location_id facility_id,
wc.carrier_id company_id,
wc.carrier_name company_name,
'CARRIER' company_type,
nvl(nvl(flp.facility_code,wl.location_code),to_char(wl.wsh_location_id)) facility_code,
nvl(flp.description,wl.ui_location_code) description
from hz_party_sites hps,
wsh_carriers_v wc,
wsh_locations wl,
fte_location_parameters flp
where hps.party_id = wc.carrier_id
AND hps.location_id = wl.source_location_id
and wl.location_source_code = 'HZ'
and wc.active='A'
AND wl.wsh_location_id = c_location_id
AND wl.wsh_location_id = flp.location_id (+)
union
SELECT wl.wsh_location_id facility_id,
hp.party_id company_id,
hp.party_name company_name,
'SUPPLIER' company_type,
nvl(nvl(flp.facility_code,wl.location_code),to_char(wl.wsh_location_id)) facility_code,
nvl(flp.description,wl.ui_location_code) description
FROM hz_parties hp ,
po_vendors po,
hz_relationships rel,
hz_party_sites hps,
wsh_locations wl,
fte_location_parameters flp
WHERE hps.party_id = hp.party_id
AND rel.relationship_type = 'POS_VENDOR_PARTY'
and rel.object_id = hp.party_id
and rel.object_table_name = 'HZ_PARTIES'
and rel.object_type = 'ORGANIZATION'
and rel.subject_table_name = 'PO_VENDORS'
and rel.subject_id = po.vendor_id
and rel.subject_type = 'POS_VENDOR'
AND hps.location_id = wl.source_location_id
AND wl.location_source_code = 'HZ'
AND hp.status='A'
AND wl.wsh_location_id = c_location_id
AND wl.wsh_location_id = flp.location_id (+);
SELECT m.concatenated_segments
FROM mtl_system_items_vl m
WHERE m.inventory_item_id = c_item_id
AND m.organization_id in ( select p.master_organization_id
from mtl_parameters p)
AND rownum = 1;
SELECT inventory_item_id,
organization_id,
vehicle_class_code
FROM fte_vehicle_types
WHERE vehicle_type_id = c_veh_type_id;
SELECT country,
state,
city,
postal_code_from,
postal_code_to
FROM wsh_regions_v
WHERE region_id = c_region_id;
SELECT zone
FROM wsh_regions_v
WHERE region_id = c_zone_id;
select hou.organization_id company_id, hou.name company_name,
hou.name site, 'ORGANIZATION' company_type
FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP,
wsh_locations wl
WHERE hou.location_id = wl.source_location_id
AND wl.location_source_code = 'HR'
AND HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1 = 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND ( HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
AND wl.source_location_id=p_locid;
select wc.carrier_id company_id, wc.carrier_name company_name,
wc.carrier_name||'/'||nvl(hps.party_site_name,hps.party_site_number)
site, 'CARRIER' company_type
from wsh_locations wl, hz_party_sites hps, wsh_carriers_v wc
where wl.source_location_id=hps.location_id
and hps.party_id=wc.carrier_id
and wl.location_source_code='HZ'
and wc.active='A'
and wl.source_location_id=p_locid
union all
select hcas.cust_account_id company_id, hp.party_name company_name,
hp.party_name||'/'||nvl(hps.party_site_name,hps.party_site_number)
site, 'CUSTOMER' company_type
from wsh_locations wl, hz_party_sites hps, hz_parties hp,
hz_cust_acct_sites_all hcas
where wl.source_location_id=hps.location_id
and hps.party_id=hp.party_id
and wl.location_source_code='HZ'
and hcas.party_site_id=hps.party_site_id
and hp.status='A'
and wl.source_location_id=p_locid
union all
select hp.party_id company_id, hp.party_name company_name,
hp.party_name||'/'||nvl(hps.party_site_name,hps.party_site_number)
site, 'SUPPLIER' company_type
FROM hz_parties hp ,
po_vendors po,
hz_relationships rel,
hz_party_sites hps,
wsh_locations wl
where wl.source_location_id=hps.location_id
and hps.party_id=hp.party_id
AND rel.relationship_type = 'POS_VENDOR_PARTY'
and rel.object_id = hp.party_id
and rel.object_table_name = 'HZ_PARTIES'
and rel.object_type = 'ORGANIZATION'
and rel.subject_table_name = 'PO_VENDORS'
and rel.subject_id = po.vendor_id
and rel.subject_type = 'POS_VENDOR'
and wl.location_source_code='HZ'
and hp.status='A'
and wl.source_location_id=p_locid;