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

VIEW: APPS.PO_VENDORS_ACTIVE_AP_V

Object Details
Object Name: PO_VENDORS_ACTIVE_AP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.PO_VENDORS_ACTIVE_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 Comments
VENDOR_NAME VARCHAR2 (240)
Supplier name
VENDOR_ID NUMBER
Yes Supplier unique identifier
VENDOR_NUMBER VARCHAR2 (30) Yes Supplier number
VENDOR_TYPE_LOOKUP_CODE VARCHAR2 (30)
Supplier type
TYPE_1099 VARCHAR2 (10)
EMPLOYEE_ID NUMBER

NUM_1099 VARCHAR2 (20)
VAT_REGISTRATION_NUM VARCHAR2 (20)
AWT_GROUP_ID NUMBER (15)
ALLOW_AWT_FLAG VARCHAR2 (1)
HOLD_ALL_PAYMENTS_FLAG VARCHAR2 (1)
PARTY_ID NUMBER

Query Text

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


SELECT VENDOR_NAME
,      VENDOR_ID
,      VENDOR_NUMBER
,      VENDOR_TYPE_LOOKUP_CODE
,      TYPE_1099
,      EMPLOYEE_ID
,      NUM_1099
,      VAT_REGISTRATION_NUM
,      AWT_GROUP_ID
,      ALLOW_AWT_FLAG
,      HOLD_ALL_PAYMENTS_FLAG
,      PARTY_ID
FROM APPS.PO_VENDORS_ACTIVE_AP_V;

Dependencies

[top of page]

APPS.PO_VENDORS_ACTIVE_AP_V references the following:

SchemaAPPS
ViewPO_VENDORS

APPS.PO_VENDORS_ACTIVE_AP_V is not referenced by any database object