[Home] [Help]
216: || ' *decode(IP.amount, 0, decode(ip2.ip_count, null, 1, 0), IP.amount)),0)),2),' -- Bug 5768112
217: || l_org_id -- Bug 4946930
218: || ' FROM ap_income_tax_regions ITR, '
219: || 'ap_reporting_entity_lines_all REL, '
220: || 'po_vendors P, '
221: || 'ce_bank_accounts ABA, ' --for bug 6275528 - replaced ap_bank_accounts_all with ce_bank_Accounts
222: --as ap_bank_accounts_All is obsolete in R12.
223: || 'ce_bank_acct_uses_all BAU, ' -- Bug 6604204. Included table to join AP_CHECKS and
224: -- CE_BANK_ACCOUNTS table.
658: || ' INV_NET_AMT.netamount ))'
659: || ' *decode(IP.amount, 0, decode(ip2.ip_count, null, 1, 0), IP.amount)),0)),2)' -- Bug 5768112
660: || ' FROM ap_income_tax_regions ITR, '
661: || 'ap_reporting_entity_lines_all REL, '
662: || 'po_vendors P, '
663: || 'ce_bank_accounts ABA, ' --for bug 6275528 - replaced ap_bank_accounts_all with ce_bank_Accounts
664: --as ap_bank_accounts_All is obsolete in R12.
665: || 'ce_bank_acct_uses_all BAU, ' -- Bug 6604204. Included table to join AP_CHECKS and
666: -- CE_BANK_ACCOUNTS table.
902: pvs.state STATE,
903: pvs.city CITY,
904: pvs.zip ZIP,
905: pvs.COUNTRY COUNTRY
906: FROM po_vendors P,
907: po_vendor_sites pvs
908: WHERE pvs.vendor_id = P.vendor_id
909: AND nvl(p.vendor_type_lookup_code, 'DUMMY') <> 'EMPLOYEE' /*Bug 9247826*/
910: AND (NVL(pvs.tax_reporting_site_flag,'N') = 'Y' OR
1061: (SELECT MAX(DECODE(papf2.effective_end_date,'',sysdate+9000,papf2.effective_end_date))
1062: FROM PER_ALL_PEOPLE_F papf2
1063: WHERE papf1.person_id=papf2.person_id)) papf,
1064: PO_VENDOR_SITES pvs,
1065: PO_VENDORS pv
1066: WHERE pv.employee_id = papf.person_id
1067: AND nvl(pv.vendor_type_lookup_code, 'DUMMY') = 'EMPLOYEE' /*Bug 9247826*/
1068: AND pv.vendor_id = pvs.vendor_id
1069: AND pv.employee_id = per_addr.person_id(+)