View: PO_LINE_TYPES_VAL_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_LINE_TYPES_VAL_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
, LT.MATCHING_BASIS
FROM PO_LINE_TYPES LT
, PO_LOOKUP_CODES LC
, PO_LOOKUP_CODES LC1
WHERE SYSDATE < NVL(LT.INACTIVE_DATE
, SYSDATE +1)
AND 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