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


VIEW: APPS.POBV_RFQ_PRICE_BREAKS

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

View Type

A Business Intelligence System view


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


[View Source]

Columns
Name Datatype Length Mandatory Comments
PRICE_BREAK_ID NUMBER
Yes
PRICE_BREAK_NUMBER NUMBER


RFQ_LINE_ID NUMBER
Yes
LINE_NUMBER NUMBER
Yes
RFQ_ID NUMBER
Yes
RFQ_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: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)

UNIT_OF_MEASURE VARCHAR2 (25)

PAYMENT_TERMS_ID NUMBER


CARRIER VARCHAR2 (25)

LEAD_TIME_UOM VARCHAR2 (25)

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).
VALUE_BASIS VARCHAR2 (25)
Value Basis
MATCHING_BASIS VARCHAR2 (30)
Matching Basis
PAYMENT_TYPE VARCHAR2 (30)
Payment Type
DESCRIPTION VARCHAR2 (240)
Description
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
OUTSOURCED_ASSEMBLY NUMBER
Yes Outsourced Assembly
ORIGINAL_SHIPMENT_ID VARCHAR2 (15)
Original Shipment Id
TAX_ATTRIBUTE_UPDATE_CODE NUMBER

Tax Attribute Update Code
Query Text

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


SELECT PRICE_BREAK_ID
,      PRICE_BREAK_NUMBER
,      RFQ_LINE_ID
,      LINE_NUMBER
,      RFQ_ID
,      RFQ_DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      PRICE_BREAK_QUANTITY
,      DISCOUNTED_PRICE
,      PRICE_DISCOUNT_PERCENTAGE
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      _LA:FREIGHT_TERM
,      _LA:FREE_ON_BOARD_POINT
,      _LA:INVOICE_MATCHING
,      QUANTITY_RECEIVED_TOLERANCE
,      _LA:QTY_RECEIVED_EXCEPTION
,      LEAD_TIME
,      _LA:TAXABLE_FLAG
,      UNIT_OF_MEASURE
,      PAYMENT_TERMS_ID
,      CARRIER
,      LEAD_TIME_UOM
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      VALUE_BASIS
,      MATCHING_BASIS
,      PAYMENT_TYPE
,      DESCRIPTION
,      WORK_APPROVER_ID
,      BID_PAYMENT_ID
,      QUANTITY_FINANCED
,      AMOUNT_FINANCED
,      QUANTITY_RECOUPED
,      AMOUNT_RECOUPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
,      OUTSOURCED_ASSEMBLY
,      ORIGINAL_SHIPMENT_ID
,      TAX_ATTRIBUTE_UPDATE_CODE
FROM APPS.POBV_RFQ_PRICE_BREAKS;

Dependencies

[top of page]

APPS.POBV_RFQ_PRICE_BREAKS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL

APPS.POBV_RFQ_PRICE_BREAKS is not referenced by any database object