[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT TERR_ID
, TERR_GROUP_ID
FROM jtf_terr_all
WHERE CATCH_ALL_FLAG = 'Y';
select -- Leads
AAA.ACCESS_ID
, ATA.TERRITORY_ID
,upper(PARTY.party_name) party_name
, LOC.state state
, LOC.postal_code postal_code
, PARTY.party_id party_id
from HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, HZ_PARTIES PARTY
, as_accesses_all AAA
, as_territory_accesses ATA
, AS_SALES_LEADS SL
where SITE.party_id = PARTY.party_id
and LOC.location_id = SITE.location_id
and SL.customer_id = PARTY.party_id
and SL.address_id = SITE.party_site_id
and AAA.ACCESS_ID = ATA.ACCESS_ID
and ATA.TERRITORY_ID = l_terr_id
and AAA.CUSTOMER_ID = SL.CUSTOMER_ID
AND AAA.LEAD_ID IS NULL
AND AAA.SALES_LEAD_ID IS NOT NULL
UNION ALL
select -- Opportunities
AAA.ACCESS_ID
, ATA.TERRITORY_ID
, upper(PARTY.party_name) party_name
, LOC.state state
, LOC.postal_code postal_code
, PARTY.party_id party_id
from HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, HZ_PARTIES PARTY
, AS_LEADS_ALL LEAD
, as_accesses_all AAA
, as_territory_accesses ATA
where SITE.party_id = PARTY.party_id
and LOC.location_id = SITE.location_id
and LEAD.customer_id = PARTY.party_id
and LEAD.address_id = SITE.party_site_id
AND AAA.ACCESS_ID = ATA.ACCESS_ID
AND ATA.TERRITORY_ID = l_terr_id
AND AAA.CUSTOMER_ID = LEAD.CUSTOMER_ID
AND AAA.LEAD_ID IS NOT NULL
AND AAA.SALES_LEAD_ID IS NULL
UNION ALL
select -- Account
AAA.ACCESS_ID
, ATA.TERRITORY_ID
, upper(PARTY.party_name) party_name
, LOC.state state
, LOC.postal_code postal_code
, PARTY.party_id party_id
from HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, HZ_PARTIES PARTY
, as_accesses_all AAA
, as_territory_accesses ATA
where SITE.party_id = PARTY.party_id
and LOC.location_id = SITE.location_id
AND AAA.ACCESS_ID = ATA.ACCESS_ID
AND ATA.TERRITORY_ID = l_terr_id
AND AAA.CUSTOMER_ID = PARTY.PARTY_ID
AND AAA.LEAD_ID IS NULL
AND AAA.SALES_LEAD_ID IS NULL
AND AAA.CUSTOMER_ID IS NOT NULL;
select WORKFLOW_ITEM_TYPE
, WORKFLOW_PROCESS_NAME
INTO x_WORKFLOW_ITEM_TYPE
, x_WORKFLOW_PROCESS_NAME
FROM jtf_tty_terr_groups
where TERR_GROUP_ID = p_TERR_GROUP_ID;
SELECT jtf_tty_workflow_s.nextval
INTO l_wf_item_key
FROM dual;