VIEW: APPS.FV_TPP_ASSIGNMENTS_V

Source

View Text - Preformatted

SELECT ftaa.original_supplier_id beneficiary_supplier_id, asup.party_id beneficiary_party_id, ftaa.original_supplier_site_id beneficiary_supplier_site_id, assa.party_site_id beneficiary_party_site_id, iepa.ext_payee_id ext_payee_id, iepa.payee_party_id payee_party_id, iepa.party_site_id payee_party_site_id, assa2.vendor_id payee_supplier_id, iepa.supplier_site_id payee_supplier_site_id, iepa.org_type payee_org_type, iepa.payment_function payee_payment_function, fv_ccr_grp.select_bank_account( ftaa.ext_bank_account_id, iepa.supplier_site_id) payee_ext_bank_acct_id, NVL(fv_ccr_grp.select_third_party( iepa.supplier_site_id), 'Y') fv_tpp_pay_flag from fv_tpp_assignments_all ftaa, ap_suppliers asup, ap_supplier_sites_all assa, ap_supplier_sites_all assa2, iby_external_payees_all iepa WHERE fv_install.enabled_yn = 'Y' and fnd_profile.value('FV_THIRD_PARTY_PAYMENT') = 'Y' and sysdate >= ftaa.start_date and sysdate <= nvl(ftaa.end_date, sysdate) and ftaa.original_supplier_id = asup.vendor_id and ftaa.original_supplier_site_id = assa.vendor_site_id and ftaa.ext_payee_id = iepa.ext_payee_id and iepa.supplier_site_id = assa2.vendor_site_id(+)

View Text - HTML Formatted

SELECT FTAA.ORIGINAL_SUPPLIER_ID BENEFICIARY_SUPPLIER_ID
, ASUP.PARTY_ID BENEFICIARY_PARTY_ID
, FTAA.ORIGINAL_SUPPLIER_SITE_ID BENEFICIARY_SUPPLIER_SITE_ID
, ASSA.PARTY_SITE_ID BENEFICIARY_PARTY_SITE_ID
, IEPA.EXT_PAYEE_ID EXT_PAYEE_ID
, IEPA.PAYEE_PARTY_ID PAYEE_PARTY_ID
, IEPA.PARTY_SITE_ID PAYEE_PARTY_SITE_ID
, ASSA2.VENDOR_ID PAYEE_SUPPLIER_ID
, IEPA.SUPPLIER_SITE_ID PAYEE_SUPPLIER_SITE_ID
, IEPA.ORG_TYPE PAYEE_ORG_TYPE
, IEPA.PAYMENT_FUNCTION PAYEE_PAYMENT_FUNCTION
, FV_CCR_GRP.SELECT_BANK_ACCOUNT( FTAA.EXT_BANK_ACCOUNT_ID
, IEPA.SUPPLIER_SITE_ID) PAYEE_EXT_BANK_ACCT_ID
, NVL(FV_CCR_GRP.SELECT_THIRD_PARTY( IEPA.SUPPLIER_SITE_ID)
, 'Y') FV_TPP_PAY_FLAG
FROM FV_TPP_ASSIGNMENTS_ALL FTAA
, AP_SUPPLIERS ASUP
, AP_SUPPLIER_SITES_ALL ASSA
, AP_SUPPLIER_SITES_ALL ASSA2
, IBY_EXTERNAL_PAYEES_ALL IEPA
WHERE FV_INSTALL.ENABLED_YN = 'Y'
AND FND_PROFILE.VALUE('FV_THIRD_PARTY_PAYMENT') = 'Y'
AND SYSDATE >= FTAA.START_DATE
AND SYSDATE <= NVL(FTAA.END_DATE
, SYSDATE)
AND FTAA.ORIGINAL_SUPPLIER_ID = ASUP.VENDOR_ID
AND FTAA.ORIGINAL_SUPPLIER_SITE_ID = ASSA.VENDOR_SITE_ID
AND FTAA.EXT_PAYEE_ID = IEPA.EXT_PAYEE_ID
AND IEPA.SUPPLIER_SITE_ID = ASSA2.VENDOR_SITE_ID(+)