VIEW: APPS.PO_LINE_TYPES_VAL_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'