eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PO_VENDOR_SITES_PAY_AP_V

Object Details

Object Name:	PO_VENDOR_SITES_PAY_AP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.PO_VENDOR_SITES_PAY_AP_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
VENDOR_SITE_CODE	VARCHAR2	(15)	Yes
VENDOR_SITE_ID	NUMBER		Yes
VENDOR_ID	NUMBER		Yes
ADDRESS_LINE1	VARCHAR2	(240)
ADDRESS_LINE2	VARCHAR2	(240)
ADDRESS_LINE3	VARCHAR2	(240)
ADDRESS_LINE4	VARCHAR2	(240)
ADDRESS_STYLE	VARCHAR2	(30)
CITY	VARCHAR2	(60)
COUNTY	VARCHAR2	(150)
STATE	VARCHAR2	(150)
PROVINCE	VARCHAR2	(150)
ZIP	VARCHAR2	(60)
COUNTRY	VARCHAR2	(60)
INVOICE_CURRENCY_CODE	VARCHAR2	(15)
TERMS_ID	NUMBER
TERMS_NAME	VARCHAR2	(50)
PAY_GROUP_LOOKUP_CODE	VARCHAR2	(25)
TERMS_DATE_BASIS	VARCHAR2	(25)
TERMS_DATE_BASIS_DISP	VARCHAR2	(80)
ACCTS_PAY_CODE_COMBINATION_ID	NUMBER
INVOICE_AMOUNT_LIMIT	NUMBER
DISTRIBUTION_SET_ID	NUMBER
DISTRIBUTION_SET_NAME	VARCHAR2	(50)
PAYMENT_PRIORITY	NUMBER
PAY_DATE_BASIS_LOOKUP_CODE	VARCHAR2	(25)
HOLD_FUTURE_PAYMENTS_FLAG	VARCHAR2	(1)
EXCLUDE_FREIGHT_FROM_DISCOUNT	VARCHAR2	(1)
ALLOW_AWT_FLAG	VARCHAR2	(1)
AWT_GROUP_ID	NUMBER	(15)
AWT_GROUP_NAME	VARCHAR2	(25)
TERRITORY_SHORT_NAME	VARCHAR2	(80)
ACTIVE_FLAG	VARCHAR2	(1)
HOLD_ALL_PAYMENTS_FLAG	VARCHAR2	(1)
ALWAYS_TAKE_DISC_FLAG	VARCHAR2	(1)
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)
ORG_ID	NUMBER
PARTY_SITE_ID	NUMBER	(15)
PAYEE_PARTY_ID	NUMBER	(15)
PAYMENT_FUNCTION	VARCHAR2	(30)
BANK_CHARGE_BEARER	VARCHAR2	(30)
SETTLEMENT_PRIORITY	VARCHAR2	(30)
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	(1)
PREPAY_CCID	NUMBER
PAY_AWT_GROUP_ID	NUMBER	(15)
PAY_AWT_GROUP_NAME	VARCHAR2	(25)

Query Text

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


SELECT VENDOR_SITE_CODE
,      VENDOR_SITE_ID
,      VENDOR_ID
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      ADDRESS_STYLE
,      CITY
,      COUNTY
,      STATE
,      PROVINCE
,      ZIP
,      COUNTRY
,      INVOICE_CURRENCY_CODE
,      TERMS_ID
,      TERMS_NAME
,      PAY_GROUP_LOOKUP_CODE
,      TERMS_DATE_BASIS
,      TERMS_DATE_BASIS_DISP
,      ACCTS_PAY_CODE_COMBINATION_ID
,      INVOICE_AMOUNT_LIMIT
,      DISTRIBUTION_SET_ID
,      DISTRIBUTION_SET_NAME
,      PAYMENT_PRIORITY
,      PAY_DATE_BASIS_LOOKUP_CODE
,      HOLD_FUTURE_PAYMENTS_FLAG
,      EXCLUDE_FREIGHT_FROM_DISCOUNT
,      ALLOW_AWT_FLAG
,      AWT_GROUP_ID
,      AWT_GROUP_NAME
,      TERRITORY_SHORT_NAME
,      ACTIVE_FLAG
,      HOLD_ALL_PAYMENTS_FLAG
,      ALWAYS_TAKE_DISC_FLAG
,      PAYMENT_CURRENCY_CODE
,      ORG_ID
,      PARTY_SITE_ID
,      PAYEE_PARTY_ID
,      PAYMENT_FUNCTION
,      BANK_CHARGE_BEARER
,      SETTLEMENT_PRIORITY
,      EXCLUSIVE_PAYMENT_FLAG
,      PREPAY_CCID
,      PAY_AWT_GROUP_ID
,      PAY_AWT_GROUP_NAME
FROM APPS.PO_VENDOR_SITES_PAY_AP_V;

Dependencies

[top of page]

APPS.PO_VENDOR_SITES_PAY_AP_V references the following:

APPS: AP_AWT_GROUPS; AP_DISTRIBUTION_SETS_ALL; AP_LOOKUP_CODES; AP_SUPPLIERS; AP_SUPPLIER_SITES; AP_TERMS; FND_GLOBAL - show dependent code; FND_TERRITORIES_VL; IBY_EXTERNAL_PAYEES_ALL

APPS.PO_VENDOR_SITES_PAY_AP_V is not referenced by any database object