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


VIEW: APPS.PO_SUPPLIERS_VAL_V

Object Details
Object Name: PO_SUPPLIERS_VAL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_SUPPLIERS_VAL_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)

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)
Query Text

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;

Dependencies

[top of page]

APPS.PO_SUPPLIERS_VAL_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
ViewPO_VENDORS
APPS.PO_SUPPLIERS_VAL_V is referenced by following:

SchemaAPPS
Package BodyFLM_FLMRFPKB_XMLP_PKG - show dependent code
ViewICX_REQ_SUPPLIERS_V
Package BodyPO_AUTOCREATE_DOC - show dependent code
Package BodyPO_R12_CAT_UPG_VAL_PVT - show dependent code
Package BodyPO_VAL_HEADERS2 - show dependent code
Package BodyPO_VENDORS_SV1 - show dependent code