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

VIEW: APPS.POS_PO_VENDORS_V

Object Details
Object Name: POS_PO_VENDORS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_PO_VENDORS_V
Subobject Name:
Status: VALID

View Type

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


This View is used to display Vendor Information from PO_VENDORS


[View Source]

Columns
Name Datatype Length Mandatory Comments
VENDOR_ID NUMBER
Yes Vendor Identifier
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER
Yes Last Updated By
VENDOR_NAME VARCHAR2 (240)
Vendor Name
SEGMENT1 VARCHAR2 (30) Yes Segment 1
SUMMARY_FLAG VARCHAR2 (1) Yes Summary Flag
ENABLED_FLAG VARCHAR2 (1) Yes Enabled Flag
SEGMENT2 VARCHAR2 (30)
Segment 2
SEGMENT3 VARCHAR2 (30)
Segment 3
SEGMENT4 VARCHAR2 (30)
Segment 4
SEGMENT5 VARCHAR2 (30)
Segment 5
LAST_UPDATE_LOGIN NUMBER

Last Update Login
CREATION_DATE DATE
Yes Creation Date
CREATED_BY NUMBER
Yes Created By
EMPLOYEE_ID NUMBER

Employee Identifier
VENDOR_TYPE_LOOKUP_CODE VARCHAR2 (30)
Vendor Type Lookup Code
CUSTOMER_NUM VARCHAR2 (25)
Customer Number
ONE_TIME_FLAG VARCHAR2 (1)
One Time Flag
PARENT_VENDOR_ID NUMBER

Parent Vendor Identifier
MIN_ORDER_AMOUNT NUMBER

Minimum Order Amount
TERMS_ID NUMBER

Terms Identifier
SET_OF_BOOKS_ID NUMBER

Set of Books Identifier
ALWAYS_TAKE_DISC_FLAG VARCHAR2 (1)
Always Take Discount Flag
PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2 (25)
Pay Date Basis Lookup Code
PAY_GROUP_LOOKUP_CODE VARCHAR2 (25)
Pay Group Lookup Code
PAYMENT_PRIORITY NUMBER

Payment Priority
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Invoice Currency Code
PAYMENT_CURRENCY_CODE VARCHAR2 (15)
Payment Currency Code
INVOICE_AMOUNT_LIMIT NUMBER

Invoice Amount Limit
HOLD_ALL_PAYMENTS_FLAG VARCHAR2 (1)
Hold All Payments Flag
HOLD_FUTURE_PAYMENTS_FLAG VARCHAR2 (1)
Hold Future Payments Flag
HOLD_REASON VARCHAR2 (240)
Hold Reason
NUM_1099 VARCHAR2 (20)
Num 1099
TYPE_1099 VARCHAR2 (10)
Type 1099
WITHHOLDING_STATUS_LOOKUP_CODE VARCHAR2 (25)
Withholding Status Look-up Code
WITHHOLDING_START_DATE DATE

Withholding Start Date
ORGANIZATION_TYPE_LOOKUP_CODE VARCHAR2 (25)
Organization Type Lookup Code
START_DATE_ACTIVE DATE

Start Date Active
END_DATE_ACTIVE DATE

End Date Active
MINORITY_GROUP_LOOKUP_CODE VARCHAR2 (25)
Minority Group Lookup Code
WOMEN_OWNED_FLAG VARCHAR2 (1)
Women Owned Flag
SMALL_BUSINESS_FLAG VARCHAR2 (1)
Small Business Flag
STANDARD_INDUSTRY_CLASS VARCHAR2 (25)
Standard Industry Class
HOLD_FLAG VARCHAR2 (1)
Hold Flag
PURCHASING_HOLD_REASON VARCHAR2 (240)
Purchasing Hold Reason
HOLD_BY NUMBER (9)
Hold By
HOLD_DATE DATE

Hold Date
TERMS_DATE_BASIS VARCHAR2 (25)
Term Date Basis
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Inspection Required Flag
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Receipt Required Flag
QTY_RCV_TOLERANCE NUMBER

Quantity Receive Tolerance
QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)
Quantity Receive Exception Code
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
Enforce Ship-To Location Code
DAYS_EARLY_RECEIPT_ALLOWED NUMBER

Days Early Receipt Allowed
DAYS_LATE_RECEIPT_ALLOWED NUMBER

Days Late Receipt Allowed
RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 (25)
Receipt Days Exception Code
RECEIVING_ROUTING_ID NUMBER

Receing Routing Identifier
ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 (1)
Allow Substitute Receipts Flag
ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2 (1)
Allow Unordered Receipts Flag
HOLD_UNMATCHED_INVOICES_FLAG VARCHAR2 (1)
Hold Unmatched Invoices Flag
TAX_VERIFICATION_DATE DATE

Tax Verification Date
NAME_CONTROL VARCHAR2 (4)
Name Control
STATE_REPORTABLE_FLAG VARCHAR2 (1)
State Reportable Flag
FEDERAL_REPORTABLE_FLAG VARCHAR2 (1)
Federal Reportable Flag
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Attribute 15
REQUEST_ID NUMBER

Request Identifier
PROGRAM_APPLICATION_ID NUMBER

Program Application Identifier
PROGRAM_ID NUMBER

Program Identifier
PROGRAM_UPDATE_DATE DATE

Program Update date
VAT_REGISTRATION_NUM VARCHAR2 (20)
VAT Registration Number
AUTO_CALCULATE_INTEREST_FLAG VARCHAR2 (1)
Auto Calculate Interest Flag
VALIDATION_NUMBER NUMBER

Validation Number
EXCLUDE_FREIGHT_FROM_DISCOUNT VARCHAR2 (1)
Exclude Freight From Discount
TAX_REPORTING_NAME VARCHAR2 (80)
Tax Reporting Name
CHECK_DIGITS VARCHAR2 (30)
Check Digits
ALLOW_AWT_FLAG VARCHAR2 (1)
Allow AWT Flag
AWT_GROUP_ID NUMBER (15)
AWT Group Identifier
Query Text

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


SELECT VENDOR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      VENDOR_NAME
,      SEGMENT1
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      EMPLOYEE_ID
,      VENDOR_TYPE_LOOKUP_CODE
,      CUSTOMER_NUM
,      ONE_TIME_FLAG
,      PARENT_VENDOR_ID
,      MIN_ORDER_AMOUNT
,      TERMS_ID
,      SET_OF_BOOKS_ID
,      ALWAYS_TAKE_DISC_FLAG
,      PAY_DATE_BASIS_LOOKUP_CODE
,      PAY_GROUP_LOOKUP_CODE
,      PAYMENT_PRIORITY
,      INVOICE_CURRENCY_CODE
,      PAYMENT_CURRENCY_CODE
,      INVOICE_AMOUNT_LIMIT
,      HOLD_ALL_PAYMENTS_FLAG
,      HOLD_FUTURE_PAYMENTS_FLAG
,      HOLD_REASON
,      NUM_1099
,      TYPE_1099
,      WITHHOLDING_STATUS_LOOKUP_CODE
,      WITHHOLDING_START_DATE
,      ORGANIZATION_TYPE_LOOKUP_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      MINORITY_GROUP_LOOKUP_CODE
,      WOMEN_OWNED_FLAG
,      SMALL_BUSINESS_FLAG
,      STANDARD_INDUSTRY_CLASS
,      HOLD_FLAG
,      PURCHASING_HOLD_REASON
,      HOLD_BY
,      HOLD_DATE
,      TERMS_DATE_BASIS
,      INSPECTION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      QTY_RCV_TOLERANCE
,      QTY_RCV_EXCEPTION_CODE
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      RECEIPT_DAYS_EXCEPTION_CODE
,      RECEIVING_ROUTING_ID
,      ALLOW_SUBSTITUTE_RECEIPTS_FLAG
,      ALLOW_UNORDERED_RECEIPTS_FLAG
,      HOLD_UNMATCHED_INVOICES_FLAG
,      TAX_VERIFICATION_DATE
,      NAME_CONTROL
,      STATE_REPORTABLE_FLAG
,      FEDERAL_REPORTABLE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      VAT_REGISTRATION_NUM
,      AUTO_CALCULATE_INTEREST_FLAG
,      VALIDATION_NUMBER
,      EXCLUDE_FREIGHT_FROM_DISCOUNT
,      TAX_REPORTING_NAME
,      CHECK_DIGITS
,      ALLOW_AWT_FLAG
,      AWT_GROUP_ID
FROM APPS.POS_PO_VENDORS_V;

Dependencies

[top of page]

APPS.POS_PO_VENDORS_V references the following:

SchemaAPPS
ViewPO_VENDORS

APPS.POS_PO_VENDORS_V is not referenced by any database object