View: FV_TPP_ASSIGNMENTS_V

Product:	FV - Federal Financials
Description:	Payables(AP) will join with this view to provide third party information to Payments(IBY).
Implementation/DBA Data:	APPS.FV_TPP_ASSIGNMENTS_V

View Text

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
, FTAA.EXT_BANK_ACCOUNT_ID PAYEE_EXT_BANK_ACCT_ID
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(+)

Columns