[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT hzp.JGZZ_FISCAL_CODE
FROM hz_parties hzp, hz_cust_accounts hzc
WHERE hzp.JGZZ_FISCAL_CODE = p_taxpayer_id
AND hzc.party_id = hzp.party_id
AND hzc.CUST_ACCOUNT_ID <> nvl(p_record_id,0)
AND substrb(nvl(HZC.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
SELECT hzp.JGZZ_FISCAL_CODE
FROM hz_parties hzp, hz_cust_accounts hzc
WHERE hzp.JGZZ_FISCAL_CODE = p_taxpayer_id
AND hzc.party_id = hzp.party_id
AND hzc.CUST_ACCOUNT_ID <> nvl(p_record_id,0);
SELECT AP.NUM_1099 FROM ap_suppliers AP
WHERE AP.NUM_1099 = p_taxpayer_id
AND AP.VENDOR_ID<>nvl(p_record_id,0)
AND substrb(nvl(AP.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
SELECT decode(ap.vendor_type_lookup_code,'Contractor',
decode(ap.organization_type_lookup_code,'INDIVIDUAL',AP.INDIVIDUAL_1099,
'FOREIGN INDIVIDUAL',AP.INDIVIDUAL_1099,
'PARTNERSHIP',AP.INDIVIDUAL_1099,
'FOREIGN PARTNERSHIP',AP.INDIVIDUAL_1099,
AP.NUM_1099),
AP.NUM_1099) NUM_1099
FROM PO_VENDORS AP
WHERE decode(ap.vendor_type_lookup_code,'Contractor',
decode(ap.organization_type_lookup_code,'INDIVIDUAL',AP.INDIVIDUAL_1099,
'FOREIGN INDIVIDUAL',AP.INDIVIDUAL_1099,
'PARTNERSHIP',AP.INDIVIDUAL_1099,
'FOREIGN PARTNERSHIP',AP.INDIVIDUAL_1099,
AP.NUM_1099),
AP.NUM_1099) = p_taxpayer_id
AND AP.VENDOR_ID <> nvl(p_record_id,0)
AND substrb(nvl(AP.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
SELECT hzp.JGZZ_FISCAL_CODE
FROM hz_parties hzp, hz_cust_accounts hzc
WHERE hzp.JGZZ_FISCAL_CODE = p_taxpayer_id
AND hzc.CUST_ACCOUNT_ID <> nvl(p_record_id,0)
AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code
-- Modified for Countries w/o GDF
UNION
SELECT I.JGZZ_FISCAL_CODE -- RA_CUSTOMERS_INTERFACE
FROM RA_CUSTOMERS_INTERFACE I
WHERE ( I.CUSTOMER_NAME <> p_entity_name
OR I.ORIG_SYSTEM_CUSTOMER_REF <> p_orig_system_ref)
AND I.JGZZ_FISCAL_CODE = p_taxpayer_id
AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code
-- Modified for Countries w/o GDF
AND I.REQUEST_ID = p_request_id
AND NVL(I.VALIDATED_FLAG,'N') <> 'Y'
AND ROWNUM = 1;
SELECT AR.TAX_REFERENCE
FROM RA_CUSTOMERS AR
WHERE AR.TAX_REFERENCE = p_tax_reg_num
AND AR.CUSTOMER_ID <>nvl(p_record_id,0)
AND substrb(nvl(AR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
SELECT AP.VAT_REGISTRATION_NUM FROM PO_VENDORS AP
WHERE AP.VAT_REGISTRATION_NUM = p_tax_reg_num
AND AP.VENDOR_ID<>nvl(p_record_id,0)
AND substrb(nvl(AP.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
SELECT AR.TAX_REFERENCE
FROM RA_CUSTOMERS AR
WHERE AR.TAX_REFERENCE = p_tax_reg_num
AND AR.CUSTOMER_ID <> nvl(p_record_id,0)
AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code -- Modified for Countries w/o GDF
UNION
SELECT I.CUST_TAX_REFERENCE -- RA_CUSTOMERS_INTERFACE
FROM RA_CUSTOMERS_INTERFACE I
WHERE ( I.CUSTOMER_NAME <> p_entity_name
OR I.ORIG_SYSTEM_CUSTOMER_REF <> p_orig_system_ref)
AND I.CUST_TAX_REFERENCE = p_tax_reg_num
AND jg_zz_shared_pkg.get_country(fnd_profile.value('ORG_ID'), NULL) = p_country_code -- Modified for Countries w/o GDF
AND I.REQUEST_ID = p_request_id
AND NVL(I.VALIDATED_FLAG,'N') <> 'Y'
AND ROWNUM = 1;
SELECT AP.VENDOR_NAME, AP.NUM_1099,AP.GLOBAL_ATTRIBUTE9,
AP.GLOBAL_ATTRIBUTE10 FROM AP_SUPPLIERS AP
WHERE (AP.VENDOR_NAME=p_entity_name
OR AP.NUM_1099= p_taxpayer_id)
AND substrb(nvl(AP.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
SELECT AP.VENDOR_NAME,
decode(ap.vendor_type_lookup_code,'Contractor',
decode(ap.organization_type_lookup_code,'INDIVIDUAL',AP.INDIVIDUAL_1099,
'FOREIGN INDIVIDUAL',AP.INDIVIDUAL_1099,
'PARTNERSHIP',AP.INDIVIDUAL_1099,
'FOREIGN PARTNERSHIP',AP.INDIVIDUAL_1099,
AP.NUM_1099),
AP.NUM_1099) NUM_1099,
AP.GLOBAL_ATTRIBUTE9,
AP.GLOBAL_ATTRIBUTE10 FROM PO_VENDORS AP
WHERE (AP.VENDOR_NAME=p_entity_name
OR decode(ap.vendor_type_lookup_code,'Contractor',
decode(ap.organization_type_lookup_code,'INDIVIDUAL',AP.INDIVIDUAL_1099,
'FOREIGN INDIVIDUAL',AP.INDIVIDUAL_1099,
'PARTNERSHIP',AP.INDIVIDUAL_1099,
'FOREIGN PARTNERSHIP',AP.INDIVIDUAL_1099,
AP.NUM_1099),
AP.NUM_1099) = p_taxpayer_id)
AND substrb(nvl(AP.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
SELECT HZP.PARTY_NAME, HZP.JGZZ_FISCAL_CODE,
HZC.GLOBAL_ATTRIBUTE9, HZC.GLOBAL_ATTRIBUTE10
FROM HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HZC
WHERE (HZP.PARTY_NAME=p_entity_name
OR HZP.JGZZ_FISCAL_CODE=p_taxpayer_id)
AND substrb(nvl(HZC.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2)=p_country_code
AND HZP.PARTY_ID = HZC.PARTY_ID;
SELECT LEGAL_ENTITY_NAME, REGISTRATION_NUMBER
FROM XLE_REGISTRATIONS_V -- Coud use this view XLE_LE_FROM_REGISTRATIONS_V
WHERE (LEGAL_ENTITY_NAME = p_entity_name
OR REGISTRATION_NUMBER = p_taxpayer_id)
AND Legislative_Category = 'INCOME_TAX'
AND COUNTRY = p_country_code;