eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.POFV_PO_LINES

Object Details

Object Name:	POFV_PO_LINES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POFV_PO_LINES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PO_LINE_ID	NUMBER		Yes
LINE_NUMBER	NUMBER		Yes
PURCHASE_ORDER_ID	NUMBER		Yes
PO_DOCUMENT_NUMBER	VARCHAR2	(20)	Yes
OPERATING_UNIT_ID	NUMBER
OPERATING_UNIT_NAME	VARCHAR2	(240)	Yes
_LA:DOCUMENT_TYPE	CHAR	(72)
LINE_TYPE	VARCHAR2	(25)
ITEM_DESCRIPTION	VARCHAR2	(240)
ORDERED_QUANTITY	NUMBER
UNIT_PRICE	NUMBER
LIST_PRICE	NUMBER
MARKET_PRICE	NUMBER
_LA:PRICE_TYPE	CHAR	(72)
_LA:PRICE_BREAK_TYPE	CHAR	(79)
AGREED_AMOUNT	NUMBER
AGREED_QUANTITY	NUMBER
_LA:ALLOW_PRICE_OVERRIDE	CHAR	(71)
PRICE_LIMIT	NUMBER
MINIMUM_RELEASE_AMOUNT	NUMBER
_LA:CANCEL_FLAG	CHAR	(57)
CANCEL_DATE	DATE
CANCEL_REASON	VARCHAR2	(240)
_LA:CLOSURE_STATUS	CHAR	(77)
CLOSED_DATE	DATE
CLOSED_REASON	VARCHAR2	(240)
_LA:NEGOTIATED_BY_BUYER_FLAG	CHAR	(73)
_LA:CAPITAL_EXPENSE_FLAG	CHAR	(66)
SUPPLIER_NOTE	VARCHAR2	(480)
SUPPLIER_PRODUCT_NUMBER	VARCHAR2	(25)
_LA:TAXABLE_FLAG	CHAR	(58)
TYPE_OF_1099	VARCHAR2	(10)
TRANSACTION_REASON	VARCHAR2	(25)
EXPIRATION_DATE	DATE
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
_DF	CHAR	(18)
ITEM_ID	NUMBER
_KF:ITEM_NUMBER::_CO	CHAR	(15)
ITEM_REVISION	VARCHAR2	(3)
ITEM_ORGANIZATION_ID	NUMBER
ITEM_ORGANIZATION_CODE	VARCHAR2	(3)
CATEGORY_ID	NUMBER
_KF:CATEGORY::_CO	CHAR	(15)
UNIT_OF_MEASURE	VARCHAR2	(25)
UOM_CLASS	VARCHAR2	(10)
UOM_DESCRIPTION	VARCHAR2	(50)
CONTRACT_NUMBER	VARCHAR2	(20)		Referenced Contract Number
HAZARD_CLASS_ID	NUMBER
HAZARD_CLASS	VARCHAR2	(40)
UN_NUMBER_ID	NUMBER
UN_NUMBER	VARCHAR2	(25)
SOURCE_DOCUMENT_ID	NUMBER
SOURCE_DOCUMENT_NUMBER	VARCHAR2	(20)
_LA:SOURCE_DOCUMENT_TYPE	CHAR	(76)
SOURCE_DOCUMENT_LINE_ID	NUMBER
SOURCE_DOCUMENT_LINE_NUMBER	NUMBER
CANCELLED_BY	NUMBER	(9)
CANCELLED_BY_EMPLOYEE_NUMBER	VARCHAR2	(30)
CANCELLED_BY_EMPLOYEE_NAME	VARCHAR2	(240)
CLOSED_BY	NUMBER	(9)
CLOSED_BY_EMPLOYEE_NUMBER	VARCHAR2	(30)
CLOSED_BY_EMPLOYEE_NAME	VARCHAR2	(240)
TAX_CODE_ID	NUMBER
TAX_CODE_NAME	VARCHAR2	(0)
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).
SECONDARY_QUANTITY	NUMBER
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)
PREFERRED_GRADE	VARCHAR2	(150)
AUCTION_DISPLAY_NUMBER	VARCHAR2	(40)
AUCTION_HEADER_ID	NUMBER
AUCTION_LINE_NUMBER	NUMBER
BID_NUMBER	NUMBER
BID_LINE_NUMBER	NUMBER
RETROACTIVE_DATE	DATE
OKE_CONTRACT_HEADER_ID	NUMBER
OKE_CONTRACT_VERSION_ID	NUMBER
OKE_CONTRACT_NUM	VARCHAR2	(120)
OKE_CONTRACT_VERSION_NUM	NUMBER	(4)
OKE_CONTRACT_LINE_NUM	VARCHAR2	(150)
SUPPLIER_REF_NUMBER	VARCHAR2	(150)		Tracking code that links to a specific configuration of an item. Generated by a configuration engine maintained by suppliers.
CONTRACT_ID	NUMBER			Referenced Contract Unique Identifier
CONTRACT_OWNING_ORG_ID	NUMBER			Operating Unit where the referenced contract is created from
SVC_AMOUNT_NOTIF_SENT	VARCHAR2	(1)		Temp Labor lines only (i.e. PURCHASE_BASIS='TEMP LABOR'): Indicates whether an Amount Billed Approaching Budget reminder notification has been sent for this line.
SVC_COMPLETION_NOTIF_SENT	VARCHAR2	(1)		Temp Labor lines only (i.e. PURCHASE_BASIS='TEMP LABOR'): Indicates whether a Contractor Assignment Nearing Completion reminder notification has been sent for this line.
BASE_UNIT_PRICE	NUMBER			Base Unit Price
JOB_ID	NUMBER			Stores the HR Job identifier
JOB_NAME	VARCHAR2	(700)		The name of the HR Job.
AMOUNT	NUMBER			Budget Amout for temp labor standard PO lines
PURCHASE_BASIS	VARCHAR2	(30)	Yes	Purchase basis of the line type
MATCHING_BASIS	VARCHAR2	(30)	Yes	Matching basis of the line type
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes	Value basis of the line
MANUAL_PRICE_CHANGE_FLAG	VARCHAR2	(1)		Only for Standard PO lines referencing a Global Agreement, Contract, or Quotation: Y if the user has manually entered a price overriding the source document price, N or null otherwise.
RETAINAGE_RATE	NUMBER			Retainage Rate
PROGRESS_PAYMENT_RATE	NUMBER			Progress Payment Rate
MAX_RETAINAGE_AMOUNT	NUMBER			Max Retainage Amount
RECOUPMENT_RATE	NUMBER			RECOUPMENT RATE
TAX_ATTRIBUTE_UPDATE_CODE	VARCHAR2	(15)		Tax Attribute Update Code

Query Text

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


SELECT PO_LINE_ID
,      LINE_NUMBER
,      PURCHASE_ORDER_ID
,      PO_DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      _LA:DOCUMENT_TYPE
,      LINE_TYPE
,      ITEM_DESCRIPTION
,      ORDERED_QUANTITY
,      UNIT_PRICE
,      LIST_PRICE
,      MARKET_PRICE
,      _LA:PRICE_TYPE
,      _LA:PRICE_BREAK_TYPE
,      AGREED_AMOUNT
,      AGREED_QUANTITY
,      _LA:ALLOW_PRICE_OVERRIDE
,      PRICE_LIMIT
,      MINIMUM_RELEASE_AMOUNT
,      _LA:CANCEL_FLAG
,      CANCEL_DATE
,      CANCEL_REASON
,      _LA:CLOSURE_STATUS
,      CLOSED_DATE
,      CLOSED_REASON
,      _LA:NEGOTIATED_BY_BUYER_FLAG
,      _LA:CAPITAL_EXPENSE_FLAG
,      SUPPLIER_NOTE
,      SUPPLIER_PRODUCT_NUMBER
,      _LA:TAXABLE_FLAG
,      TYPE_OF_1099
,      TRANSACTION_REASON
,      EXPIRATION_DATE
,      USSGL_TRANSACTION_CODE
,      _DF
,      ITEM_ID
,      _KF:ITEM_NUMBER::_CO
,      ITEM_REVISION
,      ITEM_ORGANIZATION_ID
,      ITEM_ORGANIZATION_CODE
,      CATEGORY_ID
,      _KF:CATEGORY::_CO
,      UNIT_OF_MEASURE
,      UOM_CLASS
,      UOM_DESCRIPTION
,      CONTRACT_NUMBER
,      HAZARD_CLASS_ID
,      HAZARD_CLASS
,      UN_NUMBER_ID
,      UN_NUMBER
,      SOURCE_DOCUMENT_ID
,      SOURCE_DOCUMENT_NUMBER
,      _LA:SOURCE_DOCUMENT_TYPE
,      SOURCE_DOCUMENT_LINE_ID
,      SOURCE_DOCUMENT_LINE_NUMBER
,      CANCELLED_BY
,      CANCELLED_BY_EMPLOYEE_NUMBER
,      CANCELLED_BY_EMPLOYEE_NAME
,      CLOSED_BY
,      CLOSED_BY_EMPLOYEE_NUMBER
,      CLOSED_BY_EMPLOYEE_NAME
,      TAX_CODE_ID
,      TAX_CODE_NAME
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      PREFERRED_GRADE
,      AUCTION_DISPLAY_NUMBER
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      BID_LINE_NUMBER
,      RETROACTIVE_DATE
,      OKE_CONTRACT_HEADER_ID
,      OKE_CONTRACT_VERSION_ID
,      OKE_CONTRACT_NUM
,      OKE_CONTRACT_VERSION_NUM
,      OKE_CONTRACT_LINE_NUM
,      SUPPLIER_REF_NUMBER
,      CONTRACT_ID
,      CONTRACT_OWNING_ORG_ID
,      SVC_AMOUNT_NOTIF_SENT
,      SVC_COMPLETION_NOTIF_SENT
,      BASE_UNIT_PRICE
,      JOB_ID
,      JOB_NAME
,      AMOUNT
,      PURCHASE_BASIS
,      MATCHING_BASIS
,      ORDER_TYPE_LOOKUP_CODE
,      MANUAL_PRICE_CHANGE_FLAG
,      RETAINAGE_RATE
,      PROGRESS_PAYMENT_RATE
,      MAX_RETAINAGE_AMOUNT
,      RECOUPMENT_RATE
,      TAX_ATTRIBUTE_UPDATE_CODE
FROM APPS.POFV_PO_LINES;

Dependencies

[top of page]

APPS.POFV_PO_LINES references the following:

APPS: FINANCIALS_SYSTEM_PARAMS_ALL; HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MTL_CATEGORIES; MTL_ITEM_REVISIONS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; OKC_K_HEADERS_B; OKC_K_LINES_B; OKC_K_VERS_NUMBERS_V; PER_JOBS_VL; PER_PEOPLE_F; PO_HAZARD_CLASSES; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_TYPES; PO_UN_NUMBERS

APPS.POFV_PO_LINES is not referenced by any database object