[Home] [Help] [Dependency Information]
Object Name: | PO_SUPPLIERS_VAL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.PO_SUPPLIERS_VAL_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VENDOR_NAME | VARCHAR2 | (240) | ||
SEGMENT1 | VARCHAR2 | (30) | Yes | Key flexfield segment |
NUM_1099 | VARCHAR2 | (20) | ||
VAT_REGISTRATION_NUM | VARCHAR2 | (20) | ||
TYPE_1099 | VARCHAR2 | (10) | ||
VENDOR_ID | NUMBER | Yes | ||
HOLD_STATUS | VARCHAR2 | (80) | Yes | |
TERMS_ID | NUMBER | |||
SHIP_TO_LOCATION_ID | VARCHAR2 | (0) | ||
BILL_TO_LOCATION_ID | VARCHAR2 | (0) | ||
SHIP_VIA_LOOKUP_CODE | VARCHAR2 | (0) | ||
FOB_LOOKUP_CODE | VARCHAR2 | (0) | ||
FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | (0) | ||
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | ||
HOLD_FLAG | VARCHAR2 | (1) | ||
RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | ||
VAT_CODE | VARCHAR2 | (0) | ||
ALLOW_UNORDERED_RECEIPTS_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT VENDOR_NAME
, SEGMENT1
, NUM_1099
, VAT_REGISTRATION_NUM
, TYPE_1099
, VENDOR_ID
, HOLD_STATUS
, TERMS_ID
, SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID
, SHIP_VIA_LOOKUP_CODE
, FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, INVOICE_CURRENCY_CODE
, HOLD_FLAG
, RECEIPT_REQUIRED_FLAG
, VAT_CODE
, ALLOW_UNORDERED_RECEIPTS_FLAG
FROM APPS.PO_SUPPLIERS_VAL_V;
|
|
|