PO_LINE_TYPES_VAL_V
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: VIEW
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 MATCHING_BASIS UOM_CODE |
Query
SQL_Statement |
---|
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, LT.UOM_CODE 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' |