[Home] [Help]
View: PO_LINE_TYPES_ALL_V
View Text
SELECT LT.LINE_TYPE
, LT.DESCRIPTION
, LT.LINE_TYPE_ID
, LC.DISPLAYED_FIELD
, LT.ORDER_TYPE_LOOKUP_CODE
, LT.CATEGORY_ID
, LT.UNIT_OF_MEASURE
, LT.UNIT_PRICE
, LT.OUTSIDE_OPERATION_FLAG
, LT.RECEIVING_FLAG
, LT.PURCHASE_BASIS
, LC1.DISPLAYED_FIELD PURCHASE_BASIS_DSP
FROM PO_LINE_TYPES LT
, PO_LOOKUP_CODES LC
, PO_LOOKUP_CODES LC1
WHERE LC.LOOKUP_CODE = LT.ORDER_TYPE_LOOKUP_CODE
AND LC.LOOKUP_TYPE = 'ORDER TYPE'
AND LT.PURCHASE_BASIS = LC1.LOOKUP_CODE
AND LC1.LOOKUP_TYPE = 'PURCHASE BASIS'
Columns
Name |
LINE_TYPE |
DESCRIPTION |
LINE_TYPE_ID |
DISPLAYED_FIELD |
ORDER_TYPE_LOOKUP_CODE |
CATEGORY_ID |
UNIT_OF_MEASURE |
UNIT_PRICE |
OUTSIDE_OPERATION_FLAG |
RECEIVING_FLAG |
PURCHASE_BASIS |
PURCHASE_BASIS_DSP |