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


VIEW: APPS.POFV_BKT_PO_LINE_PRICE_BREAKS

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

View Type

A Business Intelligence System view


This shows price discount information based on quantity for a blanket purchase order line.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PRICE_BREAK_ID NUMBER
Yes
PRICE_BREAK_NUMBER NUMBER


PO_LINE_ID NUMBER
Yes
LINE_NUMBER NUMBER
Yes
BLANKET_PO_ID NUMBER
Yes
BLANKET_PO_DOCUMENT_NUMBER VARCHAR2 (20) Yes
OPERATING_UNIT_ID NUMBER


OPERATING_UNIT_NAME VARCHAR2 (240) Yes
APPROVAL_DATE DATE


_LA:APPROVED_FLAG CHAR (59)

PRICE_BREAK_QUANTITY NUMBER


DISCOUNTED_PRICE NUMBER


PRICE_DISCOUNT_PERCENTAGE NUMBER


_DF CHAR (27)

SHIP_TO_LOCATION_ID NUMBER


SHIP_TO_LOCATION VARCHAR2 (60)

SHIP_TO_ORGANIZATION_ID NUMBER


SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)

SHIP_TO_ORGANIZATION_NAME VARCHAR2 (240)

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
TAX_ATTRIBUTE_UPDATE_CODE NUMBER
Yes Tax Attribute Update Code
OUTSOURCED_ASSEMBLY VARCHAR2 (15)
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
,      PO_LINE_ID
,      LINE_NUMBER
,      BLANKET_PO_ID
,      BLANKET_PO_DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      APPROVAL_DATE
,      _LA:APPROVED_FLAG
,      PRICE_BREAK_QUANTITY
,      DISCOUNTED_PRICE
,      PRICE_DISCOUNT_PERCENTAGE
,      _DF
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_ORGANIZATION_NAME
,      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
,      TAX_ATTRIBUTE_UPDATE_CODE
,      OUTSOURCED_ASSEMBLY
,      ORIGINAL_SHIPMENT_ID
FROM APPS.POFV_BKT_PO_LINE_PRICE_BREAKS;

Dependencies

[top of page]

APPS.POFV_BKT_PO_LINE_PRICE_BREAKS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymMTL_PARAMETERS
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL

APPS.POFV_BKT_PO_LINE_PRICE_BREAKS is not referenced by any database object