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_VENDORS_AP_V

Object Details

Object Name:	PO_VENDORS_AP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.PO_VENDORS_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
VENDOR_NAME	VARCHAR2	(360)
VENDOR_NUMBER	VARCHAR2	(30)
NUM_1099	VARCHAR2	(30)
VAT_REGISTRATION_NUM	VARCHAR2	(50)
VENDOR_ID	NUMBER
HOLD_ALL_PAYMENTS_FLAG	VARCHAR2	(1)
ENABLED_FLAG	VARCHAR2	(1)
VENDOR_TYPE_LOOKUP_CODE	VARCHAR2	(30)
TYPE_1099	VARCHAR2	(10)
EMPLOYEE_ID	NUMBER
AWT_GROUP_ID	NUMBER
ALLOW_AWT_FLAG	VARCHAR2	(1)
AUTO_CALCULATE_INTEREST_FLAG	VARCHAR2	(1)
ACTIVE_FLAG	VARCHAR2	(1)
NUM_ACTIVE_PAY_SITES	NUMBER
NUM_INACTIVE_PAY_SITES	NUMBER
TOTAL_PREPAYS	NUMBER
AVAILABLE_PREPAYS	NUMBER
ORG_ID	NUMBER
PARTY_ID	NUMBER
PAYMENT_FUNCTION	VARCHAR2	(30)
EXCLUSIVE_PAYMENT_FLAG	VARCHAR2	(1)
SETTLEMENT_PRIORITY	VARCHAR2	(30)
BANK_CHARGE_BEARER	VARCHAR2	(30)

Query Text

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


SELECT VENDOR_NAME
,      VENDOR_NUMBER
,      NUM_1099
,      VAT_REGISTRATION_NUM
,      VENDOR_ID
,      HOLD_ALL_PAYMENTS_FLAG
,      ENABLED_FLAG
,      VENDOR_TYPE_LOOKUP_CODE
,      TYPE_1099
,      EMPLOYEE_ID
,      AWT_GROUP_ID
,      ALLOW_AWT_FLAG
,      AUTO_CALCULATE_INTEREST_FLAG
,      ACTIVE_FLAG
,      NUM_ACTIVE_PAY_SITES
,      NUM_INACTIVE_PAY_SITES
,      TOTAL_PREPAYS
,      AVAILABLE_PREPAYS
,      ORG_ID
,      PARTY_ID
,      PAYMENT_FUNCTION
,      EXCLUSIVE_PAYMENT_FLAG
,      SETTLEMENT_PRIORITY
,      BANK_CHARGE_BEARER
FROM APPS.PO_VENDORS_AP_V;

Dependencies

[top of page]

APPS.PO_VENDORS_AP_V references the following:

APPS: AP_INVOICES_PKG - show dependent code; AP_SUPPLIERS; HR_OPERATING_UNITS; HZ_PARTIES; IBY_EXTERNAL_PAYEES_ALL; MO_GLOBAL - show dependent code; PO_VENDORS_AP_PKG - show dependent code

APPS.PO_VENDORS_AP_V is referenced by following:

APPS: PATC - show dependent code; PA_ADJUSTMENTS - show dependent code