[Home] [Help] [Dependency Information]

VIEW: APPS.FV_TPP_ASSIGNMENTS_V

Object Details

Object Name:	FV_TPP_ASSIGNMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FV.FV_TPP_ASSIGNMENTS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Payables(AP) will join with this view to provide third party information to Payments(IBY).

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT BENEFICIARY_SUPPLIER_ID
,      BENEFICIARY_PARTY_ID
,      BENEFICIARY_SUPPLIER_SITE_ID
,      BENEFICIARY_PARTY_SITE_ID
,      EXT_PAYEE_ID
,      PAYEE_PARTY_ID
,      PAYEE_PARTY_SITE_ID
,      PAYEE_SUPPLIER_ID
,      PAYEE_SUPPLIER_SITE_ID
,      PAYEE_ORG_TYPE
,      PAYEE_PAYMENT_FUNCTION
,      PAYEE_EXT_BANK_ACCT_ID
,      FV_TPP_PAY_FLAG
FROM APPS.FV_TPP_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS

AP_SUPPLIERS

AP_SUPPLIER_SITES_ALL

FND_PROFILE - show dependent code

FV_CCR_GRP - show dependent code

FV_INSTALL - show dependent code

FV_TPP_ASSIGNMENTS_ALL

IBY_EXTERNAL_PAYEES_ALL

APPS

AP_AUTOSELECT_PKG - show dependent code