PO_LINE_TYPES_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name

ROW_ID LINE_TYPE_ID LAST_UPDATE_DATE LAST_UPDATED_BY LINE_TYPE ORDER_TYPE_LOOKUP_CODE DISPLAYED_ORDER_TYPE LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY DESCRIPTION CATEGORY_ID UNIT_OF_MEASURE UNIT_PRICE RECEIVING_FLAG RECEIPT_CLOSE INACTIVE_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 PURCHASE_BASIS PURCHASE_BASIS_DSP MATCHING_BASIS UOM_CODE

Query

SQL_Statement

SELECT PLT.ROW_ID ROW_ID, PLT.LINE_TYPE_ID, PLT.LAST_UPDATE_DATE, PLT.LAST_UPDATED_BY, PLT.LINE_TYPE, PLT.ORDER_TYPE_LOOKUP_CODE, TO_CHAR(null) DISPLAYED_ORDER_TYPE, PLT.LAST_UPDATE_LOGIN, PLT.CREATION_DATE, PLT.CREATED_BY, PLT.DESCRIPTION, PLT.CATEGORY_ID, PLT.UNIT_OF_MEASURE, PLT.UNIT_PRICE, PLT.RECEIVING_FLAG, PLT.RECEIVE_CLOSE_TOLERANCE RECEIPT_CLOSE, PLT.INACTIVE_DATE, PLT.ATTRIBUTE_CATEGORY, PLT.ATTRIBUTE1, PLT.ATTRIBUTE2, PLT.ATTRIBUTE3, PLT.ATTRIBUTE4, PLT.ATTRIBUTE5, PLT.ATTRIBUTE6, PLT.ATTRIBUTE7, PLT.ATTRIBUTE8, PLT.ATTRIBUTE9, PLT.ATTRIBUTE10, PLT.ATTRIBUTE11, PLT.ATTRIBUTE12, PLT.ATTRIBUTE13, PLT.ATTRIBUTE14, PLT.ATTRIBUTE15, PLT.PURCHASE_BASIS, TO_CHAR(null) PURCHASE_BASIS_DSP, PLT.MATCHING_BASIS, PLT.UOM_CODE FROM PO_LINE_TYPES_VL PLT