VIEW: APPS.PO_LINE_TYPES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'