View: PO_LINE_TYPES_V

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

View Text

SELECT PLT.ROW_ID ROW_ID
, PLT.LINE_TYPE_ID
, PLT.LAST_UPDATE_DATE
, PLT.LAST_UPDATED_BY
, PLT.LINE_TYPE
, PLT.ORDER_TYPE_LOOKUP_CODE
, PLC.DISPLAYED_FIELD DISPLAYED_ORDER_TYPE
, PLT.LAST_UPDATE_LOGIN
, PLT.CREATION_DATE
, PLT.CREATED_BY
, PLT.DESCRIPTION
, PLT.CATEGORY_ID
, PLT.UNIT_OF_MEASURE
, PLT.UNIT_PRICE
, PLT.RECEIVING_FLAG
, PLT.RECEIVE_CLOSE_TOLERANCE RECEIPT_CLOSE
, PLT.INACTIVE_DATE
, PLT.ATTRIBUTE_CATEGORY
, PLT.ATTRIBUTE1
, PLT.ATTRIBUTE2
, PLT.ATTRIBUTE3
, PLT.ATTRIBUTE4
, PLT.ATTRIBUTE5
, PLT.ATTRIBUTE6
, PLT.ATTRIBUTE7
, PLT.ATTRIBUTE8
, PLT.ATTRIBUTE9
, PLT.ATTRIBUTE10
, PLT.ATTRIBUTE11
, PLT.ATTRIBUTE12
, PLT.ATTRIBUTE13
, PLT.ATTRIBUTE14
, PLT.ATTRIBUTE15
, PLT.OUTSIDE_OPERATION_FLAG
, PLT.REQUEST_ID
, PLT.PROGRAM_APPLICATION_ID
, PLT.PROGRAM_ID
, PLT.PROGRAM_UPDATE_DATE
, PLT.PURCHASE_BASIS
, PLC1.DISPLAYED_FIELD PURCHASE_BASIS_DSP
, PLT.MATCHING_BASIS
FROM PO_LINE_TYPES PLT
, PO_LOOKUP_CODES PLC
, PO_LOOKUP_CODES PLC1
WHERE PLT.ORDER_TYPE_LOOKUP_CODE = PLC.LOOKUP_CODE
AND PLC.LOOKUP_TYPE = 'ORDER TYPE'
AND PLT.PURCHASE_BASIS = PLC1.LOOKUP_CODE
AND PLC1.LOOKUP_TYPE = 'PURCHASE BASIS'

Columns