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


VIEW: APPS.POFV_QUOTATION_PRICE_BREAKS

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

View Type

A Business Intelligence System view


This shows price discount information based on quantity for a standard or catalog quotation line.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PRICE_BREAK_ID NUMBER
Yes
PRICE_BREAK_NUMBER NUMBER


QUOTATION_LINE_ID NUMBER
Yes
LINE_NUMBER NUMBER
Yes
QUOTATION_ID NUMBER
Yes
QUOTATION_DOCUMENT_NUMBER VARCHAR2 (20) Yes
OPERATING_UNIT_ID NUMBER


OPERATING_UNIT_NAME VARCHAR2 (240) Yes
PRICE_BREAK_QUANTITY NUMBER


DISCOUNTED_PRICE NUMBER


PRICE_DISCOUNT_PERCENTAGE NUMBER


START_EFFECTIVE_DATE DATE


END_EFFECTIVE_DATE DATE


_LA:APPROVED_FLAG CHAR (59)

_LA:FREIGHT_TERM CHAR (78)

_LA:FREE_ON_BOARD_POINT CHAR (45)

_LA:INVOICE_MATCHING CHAR (218)

QUANTITY_RECEIVED_TOLERANCE NUMBER


_LA:QTY_RECEIVED_EXCEPTION CHAR (85)

LEAD_TIME NUMBER


_LA:TAXABLE_FLAG CHAR (58)

_DF CHAR (27)

UNIT_OF_MEASURE VARCHAR2 (25)

UOM_CLASS VARCHAR2 (10)

UOM_DESCRIPTION VARCHAR2 (50)

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)
RFQ_ID NUMBER


RFQ_DOCUMENT_NUMBER VARCHAR2 (20)

RFQ_LINE_ID NUMBER


RFQ_LINE_NUMBER NUMBER


RFQ_PRICE_BREAK_ID NUMBER


RFQ_PRICE_BREAK_NUMBER NUMBER


LEAD_TIME_UOM VARCHAR2 (25)

LEAD_TIME_UOM_CLASS VARCHAR2 (10)

LEAD_TIME_UOM_DESCRIPTION VARCHAR2 (50)

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).
PAYMENT_TYPE VARCHAR2 (25)
Payment Type
DESCRIPTION VARCHAR2 (30)
Description
MATCHING_BASIS VARCHAR2 (30)
Matching Basis
VALUE_BASIS VARCHAR2 (240)
Value Basis
WORK_APPROVER_ID NUMBER

Work Approver Id
BID_PAYMENT_ID NUMBER

Bid Payment Id
QUANTITY_FINANCED NUMBER

Quantity Financed
AMOUNT_FINANCED NUMBER

Amount Financed
QUANTITY_RECOUPED NUMBER

Quantity Recouped
AMOUNT_RECOUPED NUMBER

Amount Recouped
RETAINAGE_WITHHELD_AMOUNT NUMBER

Retainage Withheld Amount
RETAINAGE_RELEASED_AMOUNT NUMBER

Retainage Released Amount
TAX_ATTRIBUTE_UPDATE_CODE VARCHAR2 (15)
Tax Attribute Update Code
OUTSOURCED_ASSEMBLY NUMBER
Yes Outsourced Assembly
ORIGINAL_SHIPMENT_ID NUMBER

Original Shipment Id
Query Text

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


SELECT PRICE_BREAK_ID
,      PRICE_BREAK_NUMBER
,      QUOTATION_LINE_ID
,      LINE_NUMBER
,      QUOTATION_ID
,      QUOTATION_DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      PRICE_BREAK_QUANTITY
,      DISCOUNTED_PRICE
,      PRICE_DISCOUNT_PERCENTAGE
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      _LA:APPROVED_FLAG
,      _LA:FREIGHT_TERM
,      _LA:FREE_ON_BOARD_POINT
,      _LA:INVOICE_MATCHING
,      QUANTITY_RECEIVED_TOLERANCE
,      _LA:QTY_RECEIVED_EXCEPTION
,      LEAD_TIME
,      _LA:TAXABLE_FLAG
,      _DF
,      UNIT_OF_MEASURE
,      UOM_CLASS
,      UOM_DESCRIPTION
,      PAYMENT_TERMS_ID
,      PAYMENT_TERMS_NAME
,      CARRIER
,      CARRIER_DESCRIPTION
,      CARRIER_ORGANIZATION_ID
,      CARRIER_ORGANIZATION_CODE
,      RFQ_ID
,      RFQ_DOCUMENT_NUMBER
,      RFQ_LINE_ID
,      RFQ_LINE_NUMBER
,      RFQ_PRICE_BREAK_ID
,      RFQ_PRICE_BREAK_NUMBER
,      LEAD_TIME_UOM
,      LEAD_TIME_UOM_CLASS
,      LEAD_TIME_UOM_DESCRIPTION
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      PAYMENT_TYPE
,      DESCRIPTION
,      MATCHING_BASIS
,      VALUE_BASIS
,      WORK_APPROVER_ID
,      BID_PAYMENT_ID
,      QUANTITY_FINANCED
,      AMOUNT_FINANCED
,      QUANTITY_RECOUPED
,      AMOUNT_RECOUPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
,      TAX_ATTRIBUTE_UPDATE_CODE
,      OUTSOURCED_ASSEMBLY
,      ORIGINAL_SHIPMENT_ID
FROM APPS.POFV_QUOTATION_PRICE_BREAKS;

Dependencies

[top of page]

APPS.POFV_QUOTATION_PRICE_BREAKS references the following:

SchemaAPPS
SynonymAP_TERMS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS
SynonymMTL_UNITS_OF_MEASURE
SynonymORG_FREIGHT
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL

APPS.POFV_QUOTATION_PRICE_BREAKS is not referenced by any database object