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


VIEW: APPS.POFV_QUOTATIONS

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

View Type

A Business Intelligence System view


This shows statements of the price, terms, and conditions of goods or services offered by a supplier.


[View Source]

Columns
Name Datatype Length Mandatory Comments
QUOTATION_ID NUMBER
Yes
DOCUMENT_NUMBER VARCHAR2 (20) Yes
OPERATING_UNIT_ID NUMBER


OPERATING_UNIT_NAME VARCHAR2 (240) Yes
_LA:QUOTATION_CLASS CHAR (75)

QUOTATION_TYPE VARCHAR2 (80)
_LA:STATUS CHAR (74)

DESCRIPTION VARCHAR2 (240)

START_EFFECTIVE_DATE DATE


END_EFFECTIVE_DATE DATE


_LA:APPROVAL_REQUIRED_FLAG CHAR (68)

_LA:FREIGHT_TERM CHAR (78)

_LA:FREE_ON_BOARD_POINT CHAR (45)

CURRENCY_CONVERSION_RATE NUMBER


CURRENCY_CONVERSION_RATE_DATE DATE


_LA:REPLY_METHOD CHAR (81)

RESPONSE_DATE DATE


QUOTATION_WARNING_DELAY NUMBER


SUPPLIER_NOTE VARCHAR2 (480)

SUPPLIER_QUOTATION_NUMBER VARCHAR2 (25)

PRINT_COUNT NUMBER


LAST_PRINTED_DATE DATE


_DF CHAR (20)

SUPPLIER_ID NUMBER


SUPPLIER_NAME VARCHAR2 (240)

SUPPLIER_SITE_ID NUMBER


SUPPLIER_SITE VARCHAR2 (15)

SUPPLIER_CONTACT_ID NUMBER


SUPPLIER_CONTACT_NAME VARCHAR2 (32)

BUYER_ID NUMBER (9) Yes
BUYER_EMPLOYEE_NUMBER VARCHAR2 (30)

BUYER_NAME VARCHAR2 (240)

BILL_TO_LOCATION_ID NUMBER


BILL_TO_LOCATION VARCHAR2 (60)

SHIP_TO_LOCATION_ID NUMBER


SHIP_TO_LOCATION VARCHAR2 (60)

CURRENCY_CODE VARCHAR2 (15)

CURRENCY VARCHAR2 (80)

CURRENCY_CONVERSION_RATE_TYPE VARCHAR2 (30)

RATE_TYPE_NAME VARCHAR2 (30)

RATE_TYPE_DESCRIPTION VARCHAR2 (240)

FROM_RFQ_ID NUMBER


FROM_RFQ_DOCUMENT_NUMBER VARCHAR2 (20)

FROM_RFQ_TYPE_CODE VARCHAR2 (25)

FROM_RFQ_TYPE VARCHAR2 (80)

PAYMENT_TERMS_ID NUMBER


PAYMENT_TERMS_NAME VARCHAR2 (50)

CARRIER VARCHAR2 (25)

CARRIER_DESCRIPTION VARCHAR2 (80)

CARRIER_ORGANIZATION_ID NUMBER

CARRIER_ORGANIZATION_CODE VARCHAR2 (3)
CREATED_DATE DATE


CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
AUTO_SOURCING_FLAG VARCHAR2 (1)
Auto Sourcing Flag
UPDATE_SOURCING_RULES_FLAG VARCHAR2 (1)
Update Sourcing Rules Flag
RETRO_PRICE_APPLY_UPDATES_FLAG VARCHAR2 (1)
Retro Price Apply Updates Flag
RETRO_PRICE_COMM_UPDATES_FLAG VARCHAR2 (1)
Retro Price Comm Updates Flag
EMAIL_ADDRESS VARCHAR2 (2000)
Email Address
FAX VARCHAR2 (30)
Fax
SUPPLIER_NOTIF_METHOD VARCHAR2 (25)
Supplier Notif Method
SUPPLIER_AUTH_ENABLED_FLAG VARCHAR2 (1)
Supplier Auth Enabled Flag
CAT_ADMIN_AUTH_ENABLED_FLAG VARCHAR2 (1)
Cat Admin Auth Enabled Flag
STYLE_ID NUMBER
Yes Style Id
TAX_ATTRIBUTE_UPDATE_CODE VARCHAR2 (15)
Tax Attribute Update Code
Query Text

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


SELECT QUOTATION_ID
,      DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      _LA:QUOTATION_CLASS
,      QUOTATION_TYPE
,      _LA:STATUS
,      DESCRIPTION
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      _LA:APPROVAL_REQUIRED_FLAG
,      _LA:FREIGHT_TERM
,      _LA:FREE_ON_BOARD_POINT
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_RATE_DATE
,      _LA:REPLY_METHOD
,      RESPONSE_DATE
,      QUOTATION_WARNING_DELAY
,      SUPPLIER_NOTE
,      SUPPLIER_QUOTATION_NUMBER
,      PRINT_COUNT
,      LAST_PRINTED_DATE
,      _DF
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      SUPPLIER_CONTACT_ID
,      SUPPLIER_CONTACT_NAME
,      BUYER_ID
,      BUYER_EMPLOYEE_NUMBER
,      BUYER_NAME
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      CURRENCY_CODE
,      CURRENCY
,      CURRENCY_CONVERSION_RATE_TYPE
,      RATE_TYPE_NAME
,      RATE_TYPE_DESCRIPTION
,      FROM_RFQ_ID
,      FROM_RFQ_DOCUMENT_NUMBER
,      FROM_RFQ_TYPE_CODE
,      FROM_RFQ_TYPE
,      PAYMENT_TERMS_ID
,      PAYMENT_TERMS_NAME
,      CARRIER
,      CARRIER_DESCRIPTION
,      CARRIER_ORGANIZATION_ID
,      CARRIER_ORGANIZATION_CODE
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      AUTO_SOURCING_FLAG
,      UPDATE_SOURCING_RULES_FLAG
,      RETRO_PRICE_APPLY_UPDATES_FLAG
,      RETRO_PRICE_COMM_UPDATES_FLAG
,      EMAIL_ADDRESS
,      FAX
,      SUPPLIER_NOTIF_METHOD
,      SUPPLIER_AUTH_ENABLED_FLAG
,      CAT_ADMIN_AUTH_ENABLED_FLAG
,      STYLE_ID
,      TAX_ATTRIBUTE_UPDATE_CODE
FROM APPS.POFV_QUOTATIONS;

Dependencies

[top of page]

APPS.POFV_QUOTATIONS references the following:

SchemaAPPS
SynonymAP_TERMS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
ViewFND_CURRENCIES_VL
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_PARAMETERS
SynonymORG_FREIGHT
ViewPER_PEOPLE_F
SynonymPO_DOCUMENT_TYPES_ALL
SynonymPO_HEADERS_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.POFV_QUOTATIONS is not referenced by any database object