[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 |
APPS.PO_LINE_TYPES_ALL_V