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.

[Home] [Help]

View: POBV_STD_PO_LINES

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POBV_STD_PO_LINES

View Text

SELECT PL.PO_LINE_ID
, PL.LINE_NUM
, PL.PO_HEADER_ID
, PH.SEGMENT1
, PL.ORG_ID
, OP.NAME
, LT.LINE_TYPE
, PL.ITEM_DESCRIPTION
, PL.QUANTITY
, PL.UNIT_PRICE
, PL.LIST_PRICE_PER_UNIT
, PL.MARKET_PRICE
, '_LA:PL.PRICE_TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:PRICE TYPE:DISPLAYED_FIELD'
, '_LA:PL.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PL.CANCEL_DATE
, PL.CANCEL_REASON
, '_LA:PL.CLOSED_CODE:PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD'
, PL.CLOSED_DATE
, PL.CLOSED_REASON
, '_LA:PL.NEGOTIATED_BY_PREPARER_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PL.CAPITAL_EXPENSE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PL.NOTE_TO_VENDOR
, PL.VENDOR_PRODUCT_NUM
, '_LA:PL.TAXABLE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PL.TYPE_1099
, PL.TRANSACTION_REASON_CODE
, PL.USSGL_TRANSACTION_CODE
, PL.ITEM_ID
, PL.ITEM_REVISION
, PL.CATEGORY_ID
, PL.UNIT_MEAS_LOOKUP_CODE
, PL.CONTRACT_NUM
, PL.HAZARD_CLASS_ID
, PL.UN_NUMBER_ID
, PL.FROM_HEADER_ID
, PL.FROM_LINE_ID
, PL.CANCELLED_BY
, PL.CLOSED_BY
, PL.TAX_CODE_ID
, PL.CREATION_DATE
, PL.CREATED_BY
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.SECONDARY_QUANTITY
, PL.SECONDARY_UNIT_OF_MEASURE
, PL.PREFERRED_GRADE
, PL.AUCTION_DISPLAY_NUMBER
, PL.AUCTION_HEADER_ID
, PL.AUCTION_LINE_NUMBER
, PL.BID_NUMBER
, PL.BID_LINE_NUMBER
, PL.OKE_CONTRACT_HEADER_ID
, PL.OKE_CONTRACT_VERSION_ID
, PL.SUPPLIER_REF_NUMBER
, PL.CONTRACT_ID
, PL.SVC_AMOUNT_NOTIF_SENT
, PL.SVC_COMPLETION_NOTIF_SENT
, PL.BASE_UNIT_PRICE
, PL.JOB_ID
, PL.AMOUNT
, PL.PURCHASE_BASIS
, PL.MATCHING_BASIS
, PL.ORDER_TYPE_LOOKUP_CODE
, PL.CONTRACTOR_FIRST_NAME
, PL.CONTRACTOR_LAST_NAME
, PL.START_DATE
, PL.EXPIRATION_DATE
, PL.MANUAL_PRICE_CHANGE_FLAG
FROM PO_LINES_ALL PL
, PO_HEADERS_ALL PH
, PO_LINE_TYPES LT
, HR_ALL_ORGANIZATION_UNITS OP
WHERE PH.TYPE_LOOKUP_CODE = 'STANDARD'
AND PL.PO_HEADER_ID = PH.PO_HEADER_ID
AND PL.ORG_ID = OP.ORGANIZATION_ID
AND PL.LINE_TYPE_ID = LT.LINE_TYPE_ID(+)
AND '_SEC:PL.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
PO_LINE_ID
LINE_NUMBER
STANDARD_PO_ID
STANDARD_PO_DOCUMENT_NUMBER
OPERATING_UNIT_ID
OPERATING_UNIT_NAME
LINE_TYPE
ITEM_DESCRIPTION
ORDERED_QUANTITY
UNIT_PRICE
LIST_PRICE
MARKET_PRICE
"_LA:PRICE_TYPE"
"_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
USSGL_TRANSACTION_CODE
ITEM_ID
ITEM_REVISION
CATEGORY_ID
UNIT_OF_MEASURE
CONTRACT_NUMBER
HAZARD_CLASS_ID
UN_NUMBER_ID
SOURCE_DOCUMENT_ID
SOURCE_DOCUMENT_LINE_ID
CANCELLED_BY
CLOSED_BY
TAX_CODE_ID
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
OKE_CONTRACT_HEADER_ID
OKE_CONTRACT_VERSION_ID
SUPPLIER_REF_NUMBER
CONTRACT_ID
SVC_AMOUNT_NOTIF_SENT
SVC_COMPLETION_NOTIF_SENT
BASE_UNIT_PRICE
JOB_ID
AMOUNT
PURCHASE_BASIS
MATCHING_BASIS
ORDER_TYPE_LOOKUP_CODE
CONTRACTOR_FIRST_NAME
CONTRACTOR_LAST_NAME
START_DATE
EXPIRATION_DATE
MANUAL_PRICE_CHANGE_FLAG