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


VIEW: APPS.POBV_BKT_PO_LINE_PRICE_BREAKS

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


SHIP_TO_LOCATION_ID NUMBER


SHIP_TO_ORGANIZATION_ID NUMBER


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
,      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
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_ORGANIZATION_ID
,      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_BKT_PO_LINE_PRICE_BREAKS;

Dependencies

[top of page]

APPS.POBV_BKT_PO_LINE_PRICE_BREAKS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL

APPS.POBV_BKT_PO_LINE_PRICE_BREAKS is not referenced by any database object