[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT flv.lookup_code
FROM fnd_lookup_values_vl flv
WHERE flv.lookup_type = p_lookup_type
AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (flv.start_date_active
, SYSDATE))
AND TRUNC (NVL (flv.end_date_active
, SYSDATE))
AND flv.enabled_flag = 'Y'
AND flv.meaning = p_lookup_meaning;
SELECT flv.lookup_code
FROM fnd_lookup_values_vl flv
WHERE flv.lookup_type = p_lookup_type
AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (flv.start_date_active
, SYSDATE))
AND TRUNC (NVL (flv.end_date_active
, SYSDATE))
AND flv.enabled_flag = 'Y'
AND flv.lookup_code = x_lookup_type_code;
SELECT NAME
FROM pn_leases_all
WHERE NAME = x_lease_name
AND org_id = fnd_global.org_id;
SELECT user_id
FROM fnd_user
WHERE TRUNC (SYSDATE) BETWEEN TRUNC (NVL (start_date, SYSDATE))
AND TRUNC (NVL (end_date, SYSDATE))
AND user_name = p_user_name;
SELECT user_id
FROM fnd_user
WHERE TRUNC (SYSDATE) BETWEEN TRUNC (NVL (start_date, SYSDATE))
AND TRUNC (NVL (end_date, SYSDATE))
AND user_id = x_user_id;
SELECT loc.location_code
, DECODE (loc.location_type_lookup_code
, 'BUILDING', loc.building
, 'LAND', loc.building
, 'FLOOR', loc.FLOOR
, 'PARCEL', loc.FLOOR
, 'OFFICE', loc.office
, 'SECTION', loc.office
) location_name
, lkp.meaning
, loc.location_type_lookup_code
, loc.location_id
FROM pn_locations_all loc
, fnd_lookups lkp
WHERE loc.status = 'A'
--AND loc.org_id = g_org_id
AND loc.org_id = fnd_global.org_id
AND loc.location_type_lookup_code = lkp.lookup_code
AND loc.location_code = p_location_code
AND lkp.lookup_type = 'PN_LOCATION_TYPE'
AND ( ( p_lease_class_code <> 'DIRECT'
AND NVL (loc.assignable_cust, 'Y') = 'Y'
)
OR (p_lease_class_code = 'DIRECT')
)
AND loc.active_end_date >= p_lease_comm_date
AND loc.active_start_date <= p_lease_term_date
AND ( (p_lease_class_code IN ('THIRD_PARTY', 'DIRECT'))
OR ( p_lease_class_code = 'SUB_LEASE'
AND loc.location_id IN (
SELECT loc2.location_id
FROM pn_locations_all loc2
START WITH loc2.location_id IN (
SELECT location_id
FROM pn_tenancies_all
WHERE lease_id =
p_parent_lease_id
AND status = 'A')
CONNECT BY PRIOR loc2.location_id =
loc2.parent_location_id)
)
)
GROUP BY loc.location_code
, DECODE (loc.location_type_lookup_code
, 'BUILDING', loc.building
, 'LAND', loc.building
, 'FLOOR', loc.FLOOR
, 'PARCEL', loc.FLOOR
, 'OFFICE', loc.office
, 'SECTION', loc.office
)
, lkp.meaning
, loc.location_type_lookup_code
, loc.location_id;
SELECT loc.location_code
, DECODE (loc.location_type_lookup_code
, 'BUILDING', loc.building
, 'LAND', loc.building
, 'FLOOR', loc.FLOOR
, 'PARCEL', loc.FLOOR
, 'OFFICE', loc.office
, 'SECTION', loc.office
) location_name
, lkp.meaning
, loc.location_type_lookup_code
, loc.location_id
FROM pn_locations_all loc
, fnd_lookups lkp
WHERE loc.status = 'A'
AND loc.org_id = p_org_id
AND loc.location_type_lookup_code = lkp.lookup_code
AND loc.location_id = x_location_id
AND lkp.lookup_type = 'PN_LOCATION_TYPE'
AND ( ( p_lease_class_code <> 'DIRECT'
AND NVL (loc.assignable_cust, 'Y') = 'Y'
)
OR (p_lease_class_code = 'DIRECT')
)
AND loc.active_end_date >= p_lease_comm_date
AND loc.active_start_date <= p_lease_term_date
AND ( (p_lease_class_code IN ('THIRD_PARTY', 'DIRECT'))
OR ( p_lease_class_code = 'SUB_LEASE'
AND loc.location_id IN (
SELECT loc2.location_id
FROM pn_locations_all loc2
START WITH loc2.location_id IN (
SELECT location_id
FROM pn_tenancies_all
WHERE lease_id =
p_parent_lease_id
AND status = 'A')
CONNECT BY PRIOR loc2.location_id =
loc2.parent_location_id)
)
)
GROUP BY loc.location_code
, DECODE (loc.location_type_lookup_code
, 'BUILDING', loc.building
, 'LAND', loc.building
, 'FLOOR', loc.FLOOR
, 'PARCEL', loc.FLOOR
, 'OFFICE', loc.office
, 'SECTION', loc.office
)
, lkp.meaning
, loc.location_type_lookup_code
, loc.location_id;
SELECT lease_id
FROM pn_leases_all
WHERE status = 'F'
AND lease_class_code = 'DIRECT'
AND ( (p_lease_id IS NULL)
OR (lease_id <> p_lease_id))
AND org_id = p_org_id
AND NAME = p_master_lease;
SELECT lease_id
FROM pn_leases_all
WHERE status = 'F'
AND lease_class_code = 'DIRECT'
AND ( (p_lease_id IS NULL)
OR (lease_id <> p_lease_id))
AND org_id = p_org_id
AND lease_id = x_master_lease_id;
SELECT term_template_id
FROM pn_term_templates_all
WHERE active = 'Y'
--AND set_of_books_id = 1001
AND org_id = p_org_id
AND ( (term_template_type = p_termtemp_type)
OR
( term_template_type ='NEUTRAL')
)
AND NAME = p_termtemp_name;
SELECT term_template_id
FROM pn_term_templates_all
WHERE active = 'Y'
--AND set_of_books_id = 1001
AND org_id = p_org_id
AND ( (term_template_type = p_termtemp_type)
OR
( term_template_type ='NEUTRAL')
)
AND term_template_id = x_termtemp_id;
SELECT grouping_rule_id
FROM pn_pay_group_rules
WHERE name=p_grouping_rule;
SELECT grouping_rule_id
FROM pn_pay_group_rules
WHERE grouping_rule_id=x_grouping_rule_id;
SELECT chart_of_accounts_id
FROM gl_sets_of_books
WHERE set_of_books_id = fnd_profile.VALUE ('GL_SET_OF_BKS_ID');
SELECT code_combination_id
FROM gl_code_combinations
WHERE code_combination_id = p_account_id
AND chart_of_accounts_id = p_chart_of_acct_id
AND enabled_flag = 'Y';
SELECT comp.company_id company_id
FROM pn_companies_all comp
WHERE EXISTS (
SELECT 1
FROM pn_company_sites_all csite
WHERE csite.lease_role_type = p_lease_role_type
AND comp.company_id = csite.company_id)
AND comp.company_id = x_company_id
--AND comp.org_id = g_org_id;
SELECT comp.company_id company_id
FROM pn_companies_all comp
WHERE EXISTS (
SELECT 1
FROM pn_company_sites_all csite
WHERE csite.lease_role_type = p_lease_role_type
AND comp.company_id = csite.company_id)
AND comp.NAME = p_company_name
-- AND comp.org_id = g_org_id;
SELECT company_site_id
FROM pn_company_sites_all
WHERE company_id = p_company_id
AND company_site_id = x_company_site_id
--AND org_id = g_org_id;
SELECT company_site_id
FROM pn_company_sites_all
WHERE company_id = p_company_id
AND NAME = p_company_site_name
--AND org_id = g_org_id;
SELECT hca.cust_account_id
FROM hz_parties hp, hz_cust_accounts hca
WHERE hp.party_id = hca.party_id
AND hca.status = 'A'
AND hp.party_name = p_customer_name;
SELECT hca.cust_account_id
FROM hz_parties hp, hz_cust_accounts hca
WHERE hp.party_id = hca.party_id
AND hca.status = 'A'
AND hca.cust_account_id = x_customer_id;
SELECT hcsu.site_use_id customer_billtosite_use_id
FROM fnd_lookups flo,
hz_cust_site_uses_all hcsu,
hz_cust_acct_sites_all hcas,
hz_party_sites hps,
hz_locations hlc,
fnd_territories_tl ter
WHERE hcas.cust_account_id = x_customer_id
AND hcas.org_id = p_org_id
AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
AND hcsu.org_id = hcas.org_id
AND hcsu.status = 'A'
AND flo.lookup_type = 'YES_NO'
AND flo.lookup_code = hcsu.primary_flag
AND hcsu.site_use_code = 'BILL_TO'
AND hcas.party_site_id = hps.party_site_id
AND hlc.location_id = hps.location_id
AND hlc.country = ter.territory_code(+)
AND ter.language(+) = USERENV('LANG')
AND flo.meaning='Yes'
ORDER BY hcsu.location;
SELECT hca.cust_account_id
FROM hz_parties hp
, hz_cust_accounts hca
WHERE hp.party_id = hca.party_id
AND hca.status = 'A'
AND party_name = p_customer_name;
SELECT hca.cust_account_id
FROM hz_parties hp
, hz_cust_accounts hca
WHERE hp.party_id = hca.party_id
AND hca.status = 'A'
AND hca.cust_account_id = x_customer_id;
SELECT to_date(l_dd_part || '-' || l_mm_part || '-' || '2007', 'DD-MM-YYYY')
INTO l_cal_start
FROM DUAL;
select company_id into x_company_id from PN_COMPANIES_ALL where upper(name) = upper(p_company_name) or company_id = x_company_id;
SELECT change_type_lookup_code
INTO l_lease_context
FROM pn_lease_changes_all plc1
WHERE lease_change_id = (select max(lease_change_id) from pn_lease_changes_all plc2 where lease_id = p_lease_id and org_id = p_org_id);
SELECT max(lease_change_id)
INTO l_lease_change_id
FROM pn_lease_changes_all
WHERE lease_id = p_lease_id
AND org_id = p_org_id;
SELECT vendor_id
FROM po_vendors
WHERE enabled_flag = 'Y'
AND TRUNC (SYSDATE) <= NVL (end_date_active, SYSDATE)
AND vendor_name = p_vendor_name;
SELECT vendor_id
FROM po_vendors
WHERE enabled_flag = 'Y'
AND TRUNC (SYSDATE) <= NVL (end_date_active, SYSDATE)
AND vendor_id = x_vendor_id;
SELECT vendor_site_id
FROM po_vendor_sites_all
WHERE vendor_id = p_vendor_id
AND pay_site_flag = 'Y'
AND TRUNC (SYSDATE) <= NVL (inactive_date, SYSDATE)
AND org_id = p_org_id
AND vendor_site_code = p_vendor_site;
SELECT vendor_site_id
FROM po_vendor_sites_all
WHERE vendor_id = p_vendor_id
AND pay_site_flag = 'Y'
AND TRUNC (SYSDATE) <= NVL (inactive_date, SYSDATE)
AND org_id = p_org_id
AND vendor_site_id = x_vendor_site_id;
SELECT hca.cust_account_id
FROM hz_parties hp, hz_cust_accounts hca
WHERE hp.party_id = hca.party_id
AND hca.status = 'A'
AND hp.party_name = p_customer_name;
SELECT hca.cust_account_id
FROM hz_parties hp, hz_cust_accounts hca
WHERE hp.party_id = hca.party_id
AND hca.status = 'A'
AND hca.cust_account_id = x_customer_id;
SELECT hcsu.site_use_id
FROM fnd_lookups flo, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, hz_party_sites hps, hz_locations hlc, fnd_territories_tl ter
WHERE hcas.cust_account_id = p_customer_id
AND hcas.org_id = p_org_id
AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
AND hcsu.org_id = hcas.org_id
AND hcsu.status = 'A'
AND flo.lookup_type = 'YES_NO'
AND flo.lookup_code = hcsu.primary_flag
AND hcsu.site_use_code = 'BILL_TO'
AND hcas.party_site_id = hps.party_site_id
AND hlc.location_id = hps.location_id
AND hlc.country = ter.territory_code(+)
AND ter.LANGUAGE(+) = USERENV ('LANG')
AND hcsu.LOCATION = p_customer_site;
SELECT hcsu.site_use_id
FROM fnd_lookups flo, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, hz_party_sites hps, hz_locations hlc, fnd_territories_tl ter
WHERE hcas.cust_account_id = p_customer_id
AND hcas.org_id = p_org_id
AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
AND hcsu.org_id = hcas.org_id
AND hcsu.status = 'A'
AND flo.lookup_type = 'YES_NO'
AND flo.lookup_code = hcsu.primary_flag
AND hcsu.site_use_code = 'BILL_TO'
AND hcas.party_site_id = hps.party_site_id
AND hlc.location_id = hps.location_id
AND hlc.country = ter.territory_code(+)
AND ter.LANGUAGE(+) = USERENV ('LANG')
AND hcsu.site_use_id = x_customer_site_id;