VIEW: EC.ECE_PO_INTERFACE_LINES#

Source

View Text - Preformatted

select LINE_NUMBER LINE_NUMBER, LINE_ORDER_QUANTITY LINE_ORDER_QUANTITY, LINE_UOM LINE_UOM, LINE_UOM_EXT1 LINE_UOM_EXT1, ITEM_ID ITEM_ID, LINE_REVISION_NUMBER LINE_REVISION_NUMBER, VENDOR_PRODUCT_NUMBER VENDOR_PRODUCT_NUMBER, LINE_UNIT_PRICE LINE_UNIT_PRICE, LINE_ITEM_DESCRIPTION LINE_ITEM_DESCRIPTION, CONTRACT_PO_NUMBER CONTRACT_PO_NUMBER, VENDOR_QUOTE_NUMBER VENDOR_QUOTE_NUMBER, LINE_CANCELLED_FLAG LINE_CANCELLED_FLAG, LINE_CANCELLED_DATE LINE_CANCELLED_DATE, BLANKET_QUANTITY_COMMITTED BLANKET_QUANTITY_COMMITTED, BLANKET_AMOUNT_COMMITTED BLANKET_AMOUNT_COMMITTED, LINE_LIST_PRICE LINE_LIST_PRICE, LINE_MARKET_PRICE LINE_MARKET_PRICE, LINE_UNIT_PRICE_NOT_TO_EXCEED LINE_UNIT_PRICE_NOT_TO_EXCEED, NEGOTIATED_PRICE_FLAG NEGOTIATED_PRICE_FLAG, LINE_TAXABLE_FLAG LINE_TAXABLE_FLAG, LINE_TAXABLE_FLAG_EXT1 LINE_TAXABLE_FLAG_EXT1, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE, TYPE_1099 TYPE_1099, LINE_ORDER_TYPE LINE_ORDER_TYPE, LINE_ITEM_HAZARD_CLASS LINE_ITEM_HAZARD_CLASS, UN_HAZARD_CLASS_NUMBER UN_HAZARD_CLASS_NUMBER, UN_HAZARD_CLASS_DESCRIPTION UN_HAZARD_CLASS_DESCRIPTION, LINE_NOTE_TO_VENDOR LINE_NOTE_TO_VENDOR, PO_NUMBER PO_NUMBER, PO_TYPE PO_TYPE, RELEASE_NUMBER RELEASE_NUMBER, QUOTE_NUMBER QUOTE_NUMBER, QUOTE_LINE_NUMBER QUOTE_LINE_NUMBER, LINE_PART_NUMBER LINE_PART_NUMBER, LINE_PART_ATTRIB_CATEGORY LINE_PART_ATTRIB_CATEGORY, LINE_PART_ATTRIBUTE1 LINE_PART_ATTRIBUTE1, LINE_PART_ATTRIBUTE2 LINE_PART_ATTRIBUTE2, LINE_PART_ATTRIBUTE3 LINE_PART_ATTRIBUTE3, LINE_PART_ATTRIBUTE4 LINE_PART_ATTRIBUTE4, LINE_PART_ATTRIBUTE5 LINE_PART_ATTRIBUTE5, LINE_PART_ATTRIBUTE6 LINE_PART_ATTRIBUTE6, LINE_PART_ATTRIBUTE7 LINE_PART_ATTRIBUTE7, LINE_PART_ATTRIBUTE8 LINE_PART_ATTRIBUTE8, LINE_PART_ATTRIBUTE9 LINE_PART_ATTRIBUTE9, LINE_PART_ATTRIBUTE10 LINE_PART_ATTRIBUTE10, LINE_PART_ATTRIBUTE11 LINE_PART_ATTRIBUTE11, LINE_PART_ATTRIBUTE12 LINE_PART_ATTRIBUTE12, LINE_PART_ATTRIBUTE13 LINE_PART_ATTRIBUTE13, LINE_PART_ATTRIBUTE14 LINE_PART_ATTRIBUTE14, LINE_PART_ATTRIBUTE15 LINE_PART_ATTRIBUTE15, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15, LINE_UOM_EXT2 LINE_UOM_EXT2, LINE_UOM_EXT3 LINE_UOM_EXT3, LINE_UOM_EXT4 LINE_UOM_EXT4, LINE_UOM_EXT5 LINE_UOM_EXT5, LINE_TAXABLE_FLAG_EXT2 LINE_TAXABLE_FLAG_EXT2, LINE_TAXABLE_FLAG_EXT3 LINE_TAXABLE_FLAG_EXT3, LINE_TAXABLE_FLAG_EXT4 LINE_TAXABLE_FLAG_EXT4, LINE_TAXABLE_FLAG_EXT5 LINE_TAXABLE_FLAG_EXT5, PO_HEADER_ID PO_HEADER_ID, PO_RELEASE_ID PO_RELEASE_ID, PO_LINE_ID PO_LINE_ID, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, RUN_ID RUN_ID, TRANSACTION_TYPE TRANSACTION_TYPE, COMMUNICATION_METHOD COMMUNICATION_METHOD, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CONTRACT_PO_LINE_NUMBER CONTRACT_PO_LINE_NUMBER, LINE_PART_SEGMENT1 LINE_PART_SEGMENT1, LINE_PART_SEGMENT2 LINE_PART_SEGMENT2, LINE_PART_SEGMENT3 LINE_PART_SEGMENT3, LINE_PART_SEGMENT4 LINE_PART_SEGMENT4, LINE_PART_SEGMENT5 LINE_PART_SEGMENT5, LINE_PART_SEGMENT6 LINE_PART_SEGMENT6, LINE_PART_SEGMENT7 LINE_PART_SEGMENT7, LINE_PART_SEGMENT8 LINE_PART_SEGMENT8, LINE_PART_SEGMENT9 LINE_PART_SEGMENT9, LINE_PART_SEGMENT10 LINE_PART_SEGMENT10, LINE_PART_SEGMENT11 LINE_PART_SEGMENT11, LINE_PART_SEGMENT12 LINE_PART_SEGMENT12, LINE_PART_SEGMENT13 LINE_PART_SEGMENT13, LINE_PART_SEGMENT14 LINE_PART_SEGMENT14, LINE_PART_SEGMENT15 LINE_PART_SEGMENT15, LINE_PART_SEGMENT16 LINE_PART_SEGMENT16, LINE_PART_SEGMENT17 LINE_PART_SEGMENT17, LINE_PART_SEGMENT18 LINE_PART_SEGMENT18, LINE_PART_SEGMENT19 LINE_PART_SEGMENT19, LINE_PART_SEGMENT20 LINE_PART_SEGMENT20, LINE_STATUS_CODE LINE_STATUS_CODE, LINE_STATUS_CODE_EXT1 LINE_STATUS_CODE_EXT1, LINE_STATUS_CODE_EXT2 LINE_STATUS_CODE_EXT2, LINE_STATUS_CODE_EXT3 LINE_STATUS_CODE_EXT3, LINE_STATUS_CODE_EXT4 LINE_STATUS_CODE_EXT4, LINE_STATUS_CODE_EXT5 LINE_STATUS_CODE_EXT5, POR_RELEASE_ID POR_RELEASE_ID, MTL_ORGANIZATION_ID MTL_ORGANIZATION_ID, EXPIRATION_DATE EXPIRATION_DATE, LINE_ITEM_DESCRIPTION_LONG LINE_ITEM_DESCRIPTION_LONG, GLOBAL_AGREEMENT_NUM GLOBAL_AGREEMENT_NUM, GLOBAL_AGREEMENT_LINE_NUM GLOBAL_AGREEMENT_LINE_NUM, SUPPLIER_CONFIG_ID SUPPLIER_CONFIG_ID from "EC"."ECE_PO_INTERFACE_LINES"

View Text - HTML Formatted

SELECT LINE_NUMBER LINE_NUMBER
, LINE_ORDER_QUANTITY LINE_ORDER_QUANTITY
, LINE_UOM LINE_UOM
, LINE_UOM_EXT1 LINE_UOM_EXT1
, ITEM_ID ITEM_ID
, LINE_REVISION_NUMBER LINE_REVISION_NUMBER
, VENDOR_PRODUCT_NUMBER VENDOR_PRODUCT_NUMBER
, LINE_UNIT_PRICE LINE_UNIT_PRICE
, LINE_ITEM_DESCRIPTION LINE_ITEM_DESCRIPTION
, CONTRACT_PO_NUMBER CONTRACT_PO_NUMBER
, VENDOR_QUOTE_NUMBER VENDOR_QUOTE_NUMBER
, LINE_CANCELLED_FLAG LINE_CANCELLED_FLAG
, LINE_CANCELLED_DATE LINE_CANCELLED_DATE
, BLANKET_QUANTITY_COMMITTED BLANKET_QUANTITY_COMMITTED
, BLANKET_AMOUNT_COMMITTED BLANKET_AMOUNT_COMMITTED
, LINE_LIST_PRICE LINE_LIST_PRICE
, LINE_MARKET_PRICE LINE_MARKET_PRICE
, LINE_UNIT_PRICE_NOT_TO_EXCEED LINE_UNIT_PRICE_NOT_TO_EXCEED
, NEGOTIATED_PRICE_FLAG NEGOTIATED_PRICE_FLAG
, LINE_TAXABLE_FLAG LINE_TAXABLE_FLAG
, LINE_TAXABLE_FLAG_EXT1 LINE_TAXABLE_FLAG_EXT1
, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE
, TYPE_1099 TYPE_1099
, LINE_ORDER_TYPE LINE_ORDER_TYPE
, LINE_ITEM_HAZARD_CLASS LINE_ITEM_HAZARD_CLASS
, UN_HAZARD_CLASS_NUMBER UN_HAZARD_CLASS_NUMBER
, UN_HAZARD_CLASS_DESCRIPTION UN_HAZARD_CLASS_DESCRIPTION
, LINE_NOTE_TO_VENDOR LINE_NOTE_TO_VENDOR
, PO_NUMBER PO_NUMBER
, PO_TYPE PO_TYPE
, RELEASE_NUMBER RELEASE_NUMBER
, QUOTE_NUMBER QUOTE_NUMBER
, QUOTE_LINE_NUMBER QUOTE_LINE_NUMBER
, LINE_PART_NUMBER LINE_PART_NUMBER
, LINE_PART_ATTRIB_CATEGORY LINE_PART_ATTRIB_CATEGORY
, LINE_PART_ATTRIBUTE1 LINE_PART_ATTRIBUTE1
, LINE_PART_ATTRIBUTE2 LINE_PART_ATTRIBUTE2
, LINE_PART_ATTRIBUTE3 LINE_PART_ATTRIBUTE3
, LINE_PART_ATTRIBUTE4 LINE_PART_ATTRIBUTE4
, LINE_PART_ATTRIBUTE5 LINE_PART_ATTRIBUTE5
, LINE_PART_ATTRIBUTE6 LINE_PART_ATTRIBUTE6
, LINE_PART_ATTRIBUTE7 LINE_PART_ATTRIBUTE7
, LINE_PART_ATTRIBUTE8 LINE_PART_ATTRIBUTE8
, LINE_PART_ATTRIBUTE9 LINE_PART_ATTRIBUTE9
, LINE_PART_ATTRIBUTE10 LINE_PART_ATTRIBUTE10
, LINE_PART_ATTRIBUTE11 LINE_PART_ATTRIBUTE11
, LINE_PART_ATTRIBUTE12 LINE_PART_ATTRIBUTE12
, LINE_PART_ATTRIBUTE13 LINE_PART_ATTRIBUTE13
, LINE_PART_ATTRIBUTE14 LINE_PART_ATTRIBUTE14
, LINE_PART_ATTRIBUTE15 LINE_PART_ATTRIBUTE15
, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15
, LINE_UOM_EXT2 LINE_UOM_EXT2
, LINE_UOM_EXT3 LINE_UOM_EXT3
, LINE_UOM_EXT4 LINE_UOM_EXT4
, LINE_UOM_EXT5 LINE_UOM_EXT5
, LINE_TAXABLE_FLAG_EXT2 LINE_TAXABLE_FLAG_EXT2
, LINE_TAXABLE_FLAG_EXT3 LINE_TAXABLE_FLAG_EXT3
, LINE_TAXABLE_FLAG_EXT4 LINE_TAXABLE_FLAG_EXT4
, LINE_TAXABLE_FLAG_EXT5 LINE_TAXABLE_FLAG_EXT5
, PO_HEADER_ID PO_HEADER_ID
, PO_RELEASE_ID PO_RELEASE_ID
, PO_LINE_ID PO_LINE_ID
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, RUN_ID RUN_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, COMMUNICATION_METHOD COMMUNICATION_METHOD
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CONTRACT_PO_LINE_NUMBER CONTRACT_PO_LINE_NUMBER
, LINE_PART_SEGMENT1 LINE_PART_SEGMENT1
, LINE_PART_SEGMENT2 LINE_PART_SEGMENT2
, LINE_PART_SEGMENT3 LINE_PART_SEGMENT3
, LINE_PART_SEGMENT4 LINE_PART_SEGMENT4
, LINE_PART_SEGMENT5 LINE_PART_SEGMENT5
, LINE_PART_SEGMENT6 LINE_PART_SEGMENT6
, LINE_PART_SEGMENT7 LINE_PART_SEGMENT7
, LINE_PART_SEGMENT8 LINE_PART_SEGMENT8
, LINE_PART_SEGMENT9 LINE_PART_SEGMENT9
, LINE_PART_SEGMENT10 LINE_PART_SEGMENT10
, LINE_PART_SEGMENT11 LINE_PART_SEGMENT11
, LINE_PART_SEGMENT12 LINE_PART_SEGMENT12
, LINE_PART_SEGMENT13 LINE_PART_SEGMENT13
, LINE_PART_SEGMENT14 LINE_PART_SEGMENT14
, LINE_PART_SEGMENT15 LINE_PART_SEGMENT15
, LINE_PART_SEGMENT16 LINE_PART_SEGMENT16
, LINE_PART_SEGMENT17 LINE_PART_SEGMENT17
, LINE_PART_SEGMENT18 LINE_PART_SEGMENT18
, LINE_PART_SEGMENT19 LINE_PART_SEGMENT19
, LINE_PART_SEGMENT20 LINE_PART_SEGMENT20
, LINE_STATUS_CODE LINE_STATUS_CODE
, LINE_STATUS_CODE_EXT1 LINE_STATUS_CODE_EXT1
, LINE_STATUS_CODE_EXT2 LINE_STATUS_CODE_EXT2
, LINE_STATUS_CODE_EXT3 LINE_STATUS_CODE_EXT3
, LINE_STATUS_CODE_EXT4 LINE_STATUS_CODE_EXT4
, LINE_STATUS_CODE_EXT5 LINE_STATUS_CODE_EXT5
, POR_RELEASE_ID POR_RELEASE_ID
, MTL_ORGANIZATION_ID MTL_ORGANIZATION_ID
, EXPIRATION_DATE EXPIRATION_DATE
, LINE_ITEM_DESCRIPTION_LONG LINE_ITEM_DESCRIPTION_LONG
, GLOBAL_AGREEMENT_NUM GLOBAL_AGREEMENT_NUM
, GLOBAL_AGREEMENT_LINE_NUM GLOBAL_AGREEMENT_LINE_NUM
, SUPPLIER_CONFIG_ID SUPPLIER_CONFIG_ID
FROM "EC"."ECE_PO_INTERFACE_LINES"