VIEW: PO.PO_LINES_ARCHIVE_ALL#

Source

View Text - Preformatted

select PO_LINE_ID PO_LINE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, PO_HEADER_ID PO_HEADER_ID, LINE_TYPE_ID LINE_TYPE_ID, LINE_NUM LINE_NUM, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ITEM_ID ITEM_ID, ITEM_REVISION ITEM_REVISION, CATEGORY_ID CATEGORY_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE, QUANTITY_COMMITTED QUANTITY_COMMITTED, COMMITTED_AMOUNT COMMITTED_AMOUNT, ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG, NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE, LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT, UNIT_PRICE UNIT_PRICE, QUANTITY QUANTITY, UN_NUMBER_ID UN_NUMBER_ID, HAZARD_CLASS_ID HAZARD_CLASS_ID, NOTE_TO_VENDOR NOTE_TO_VENDOR, FROM_HEADER_ID FROM_HEADER_ID, FROM_LINE_ID FROM_LINE_ID, MIN_ORDER_QUANTITY MIN_ORDER_QUANTITY, MAX_ORDER_QUANTITY MAX_ORDER_QUANTITY, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE, OVER_TOLERANCE_ERROR_FLAG OVER_TOLERANCE_ERROR_FLAG, MARKET_PRICE MARKET_PRICE, UNORDERED_FLAG UNORDERED_FLAG, CLOSED_FLAG CLOSED_FLAG, USER_HOLD_FLAG USER_HOLD_FLAG, CANCEL_FLAG CANCEL_FLAG, CANCELLED_BY CANCELLED_BY, CANCEL_DATE CANCEL_DATE, CANCEL_REASON CANCEL_REASON, FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE, FIRM_DATE FIRM_DATE, VENDOR_PRODUCT_NUM VENDOR_PRODUCT_NUM, CONTRACT_NUM CONTRACT_NUM, TAXABLE_FLAG TAXABLE_FLAG, TAX_NAME TAX_NAME, TYPE_1099 TYPE_1099, CAPITAL_EXPENSE_FLAG CAPITAL_EXPENSE_FLAG, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, REFERENCE_NUM REFERENCE_NUM, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT, PRICE_TYPE_LOOKUP_CODE PRICE_TYPE_LOOKUP_CODE, REVISION_NUM REVISION_NUM, PRICE_BREAK_LOOKUP_CODE PRICE_BREAK_LOOKUP_CODE, LATEST_EXTERNAL_FLAG LATEST_EXTERNAL_FLAG, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CLOSED_CODE CLOSED_CODE, CLOSED_BY CLOSED_BY, CLOSED_DATE CLOSED_DATE, CLOSED_REASON CLOSED_REASON, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE, ORG_ID ORG_ID, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, EXPIRATION_DATE EXPIRATION_DATE, QC_GRADE QC_GRADE, BASE_UOM BASE_UOM, BASE_QTY BASE_QTY, SECONDARY_UOM SECONDARY_UOM, SECONDARY_QTY SECONDARY_QTY, LINE_REFERENCE_NUM LINE_REFERENCE_NUM, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, TAX_CODE_ID TAX_CODE_ID, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE, SECONDARY_QUANTITY SECONDARY_QUANTITY, PREFERRED_GRADE PREFERRED_GRADE, AUCTION_HEADER_ID AUCTION_HEADER_ID, AUCTION_DISPLAY_NUMBER AUCTION_DISPLAY_NUMBER, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER, BID_NUMBER BID_NUMBER, BID_LINE_NUMBER BID_LINE_NUMBER, OKE_CONTRACT_HEADER_ID OKE_CONTRACT_HEADER_ID, OKE_CONTRACT_VERSION_ID OKE_CONTRACT_VERSION_ID, RETROACTIVE_DATE RETROACTIVE_DATE, SUPPLIER_REF_NUMBER SUPPLIER_REF_NUMBER, CONTRACT_ID CONTRACT_ID, JOB_ID JOB_ID, AMOUNT AMOUNT, START_DATE START_DATE, CONTRACTOR_FIRST_NAME CONTRACTOR_FIRST_NAME, CONTRACTOR_LAST_NAME CONTRACTOR_LAST_NAME, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS PURCHASE_BASIS, MATCHING_BASIS MATCHING_BASIS, SVC_AMOUNT_NOTIF_SENT SVC_AMOUNT_NOTIF_SENT, SVC_COMPLETION_NOTIF_SENT SVC_COMPLETION_NOTIF_SENT, BASE_UNIT_PRICE BASE_UNIT_PRICE, MANUAL_PRICE_CHANGE_FLAG MANUAL_PRICE_CHANGE_FLAG, RETAINAGE_RATE RETAINAGE_RATE, MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT, PROGRESS_PAYMENT_RATE PROGRESS_PAYMENT_RATE, RECOUPMENT_RATE RECOUPMENT_RATE, CATALOG_NAME CATALOG_NAME, SUPPLIER_PART_AUXID SUPPLIER_PART_AUXID, IP_CATEGORY_ID IP_CATEGORY_ID, LAST_UPDATED_PROGRAM LAST_UPDATED_PROGRAM, GROUP_LINE_ID GROUP_LINE_ID, LINE_NUM_DISPLAY LINE_NUM_DISPLAY, CLM_INFO_FLAG CLM_INFO_FLAG, CLM_OPTION_INDICATOR CLM_OPTION_INDICATOR, CLM_BASE_LINE_NUM CLM_BASE_LINE_NUM, CLM_OPTION_NUM CLM_OPTION_NUM, CLM_OPTION_FROM_DATE CLM_OPTION_FROM_DATE, CLM_OPTION_TO_DATE CLM_OPTION_TO_DATE, CLM_FUNDED_FLAG CLM_FUNDED_FLAG, CONTRACT_TYPE CONTRACT_TYPE, COST_CONSTRAINT COST_CONSTRAINT, CLM_IDC_TYPE CLM_IDC_TYPE, USER_DOCUMENT_STATUS USER_DOCUMENT_STATUS, CLM_EXERCISED_FLAG CLM_EXERCISED_FLAG, CLM_EXERCISED_DATE CLM_EXERCISED_DATE, CLM_FSC_PSC CLM_FSC_PSC, CLM_MAX_ORDER_AMOUNT CLM_MAX_ORDER_AMOUNT, CLM_MAX_ORDER_QUANTITY CLM_MAX_ORDER_QUANTITY, CLM_MAX_TOTAL_AMOUNT CLM_MAX_TOTAL_AMOUNT, CLM_MAX_TOTAL_QUANTITY CLM_MAX_TOTAL_QUANTITY, CLM_MDAPS_MAIS CLM_MDAPS_MAIS, CLM_MIN_ORDER_AMOUNT CLM_MIN_ORDER_AMOUNT, CLM_MIN_ORDER_QUANTITY CLM_MIN_ORDER_QUANTITY, CLM_MIN_TOTAL_AMOUNT CLM_MIN_TOTAL_AMOUNT, CLM_MIN_TOTAL_QUANTITY CLM_MIN_TOTAL_QUANTITY, CLM_NAICS CLM_NAICS, CLM_ORDER_END_DATE CLM_ORDER_END_DATE, CLM_ORDER_START_DATE CLM_ORDER_START_DATE, CLM_TOTAL_AMOUNT_ORDERED CLM_TOTAL_AMOUNT_ORDERED, CLM_TOTAL_QUANTITY_ORDERED CLM_TOTAL_QUANTITY_ORDERED, FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, CLM_APPROVED_UNDEF_AMOUNT CLM_APPROVED_UNDEF_AMOUNT, CLM_DELIVERY_EVENT_CODE CLM_DELIVERY_EVENT_CODE, CLM_EXHIBIT_NAME CLM_EXHIBIT_NAME, CLM_PAYMENT_INSTR_CODE CLM_PAYMENT_INSTR_CODE, CLM_POP_EXCEPTION_REASON CLM_POP_EXCEPTION_REASON, CLM_UDA_PRICING_TOTAL CLM_UDA_PRICING_TOTAL, CLM_UNDEF_ACTION_CODE CLM_UNDEF_ACTION_CODE, CLM_UNDEF_FLAG CLM_UNDEF_FLAG from "PO"."PO_LINES_ARCHIVE_ALL"

View Text - HTML Formatted

SELECT PO_LINE_ID PO_LINE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, PO_HEADER_ID PO_HEADER_ID
, LINE_TYPE_ID LINE_TYPE_ID
, LINE_NUM LINE_NUM
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ITEM_ID ITEM_ID
, ITEM_REVISION ITEM_REVISION
, CATEGORY_ID CATEGORY_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE
, QUANTITY_COMMITTED QUANTITY_COMMITTED
, COMMITTED_AMOUNT COMMITTED_AMOUNT
, ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG
, NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE
, LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT
, UNIT_PRICE UNIT_PRICE
, QUANTITY QUANTITY
, UN_NUMBER_ID UN_NUMBER_ID
, HAZARD_CLASS_ID HAZARD_CLASS_ID
, NOTE_TO_VENDOR NOTE_TO_VENDOR
, FROM_HEADER_ID FROM_HEADER_ID
, FROM_LINE_ID FROM_LINE_ID
, MIN_ORDER_QUANTITY MIN_ORDER_QUANTITY
, MAX_ORDER_QUANTITY MAX_ORDER_QUANTITY
, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE
, OVER_TOLERANCE_ERROR_FLAG OVER_TOLERANCE_ERROR_FLAG
, MARKET_PRICE MARKET_PRICE
, UNORDERED_FLAG UNORDERED_FLAG
, CLOSED_FLAG CLOSED_FLAG
, USER_HOLD_FLAG USER_HOLD_FLAG
, CANCEL_FLAG CANCEL_FLAG
, CANCELLED_BY CANCELLED_BY
, CANCEL_DATE CANCEL_DATE
, CANCEL_REASON CANCEL_REASON
, FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE FIRM_DATE
, VENDOR_PRODUCT_NUM VENDOR_PRODUCT_NUM
, CONTRACT_NUM CONTRACT_NUM
, TAXABLE_FLAG TAXABLE_FLAG
, TAX_NAME TAX_NAME
, TYPE_1099 TYPE_1099
, CAPITAL_EXPENSE_FLAG CAPITAL_EXPENSE_FLAG
, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, REFERENCE_NUM REFERENCE_NUM
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT
, PRICE_TYPE_LOOKUP_CODE PRICE_TYPE_LOOKUP_CODE
, REVISION_NUM REVISION_NUM
, PRICE_BREAK_LOOKUP_CODE PRICE_BREAK_LOOKUP_CODE
, LATEST_EXTERNAL_FLAG LATEST_EXTERNAL_FLAG
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CLOSED_CODE CLOSED_CODE
, CLOSED_BY CLOSED_BY
, CLOSED_DATE CLOSED_DATE
, CLOSED_REASON CLOSED_REASON
, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE
, ORG_ID ORG_ID
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, EXPIRATION_DATE EXPIRATION_DATE
, QC_GRADE QC_GRADE
, BASE_UOM BASE_UOM
, BASE_QTY BASE_QTY
, SECONDARY_UOM SECONDARY_UOM
, SECONDARY_QTY SECONDARY_QTY
, LINE_REFERENCE_NUM LINE_REFERENCE_NUM
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, TAX_CODE_ID TAX_CODE_ID
, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, PREFERRED_GRADE PREFERRED_GRADE
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, AUCTION_DISPLAY_NUMBER AUCTION_DISPLAY_NUMBER
, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER
, BID_NUMBER BID_NUMBER
, BID_LINE_NUMBER BID_LINE_NUMBER
, OKE_CONTRACT_HEADER_ID OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_VERSION_ID OKE_CONTRACT_VERSION_ID
, RETROACTIVE_DATE RETROACTIVE_DATE
, SUPPLIER_REF_NUMBER SUPPLIER_REF_NUMBER
, CONTRACT_ID CONTRACT_ID
, JOB_ID JOB_ID
, AMOUNT AMOUNT
, START_DATE START_DATE
, CONTRACTOR_FIRST_NAME CONTRACTOR_FIRST_NAME
, CONTRACTOR_LAST_NAME CONTRACTOR_LAST_NAME
, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE
, PURCHASE_BASIS PURCHASE_BASIS
, MATCHING_BASIS MATCHING_BASIS
, SVC_AMOUNT_NOTIF_SENT SVC_AMOUNT_NOTIF_SENT
, SVC_COMPLETION_NOTIF_SENT SVC_COMPLETION_NOTIF_SENT
, BASE_UNIT_PRICE BASE_UNIT_PRICE
, MANUAL_PRICE_CHANGE_FLAG MANUAL_PRICE_CHANGE_FLAG
, RETAINAGE_RATE RETAINAGE_RATE
, MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT
, PROGRESS_PAYMENT_RATE PROGRESS_PAYMENT_RATE
, RECOUPMENT_RATE RECOUPMENT_RATE
, CATALOG_NAME CATALOG_NAME
, SUPPLIER_PART_AUXID SUPPLIER_PART_AUXID
, IP_CATEGORY_ID IP_CATEGORY_ID
, LAST_UPDATED_PROGRAM LAST_UPDATED_PROGRAM
, GROUP_LINE_ID GROUP_LINE_ID
, LINE_NUM_DISPLAY LINE_NUM_DISPLAY
, CLM_INFO_FLAG CLM_INFO_FLAG
, CLM_OPTION_INDICATOR CLM_OPTION_INDICATOR
, CLM_BASE_LINE_NUM CLM_BASE_LINE_NUM
, CLM_OPTION_NUM CLM_OPTION_NUM
, CLM_OPTION_FROM_DATE CLM_OPTION_FROM_DATE
, CLM_OPTION_TO_DATE CLM_OPTION_TO_DATE
, CLM_FUNDED_FLAG CLM_FUNDED_FLAG
, CONTRACT_TYPE CONTRACT_TYPE
, COST_CONSTRAINT COST_CONSTRAINT
, CLM_IDC_TYPE CLM_IDC_TYPE
, USER_DOCUMENT_STATUS USER_DOCUMENT_STATUS
, CLM_EXERCISED_FLAG CLM_EXERCISED_FLAG
, CLM_EXERCISED_DATE CLM_EXERCISED_DATE
, CLM_FSC_PSC CLM_FSC_PSC
, CLM_MAX_ORDER_AMOUNT CLM_MAX_ORDER_AMOUNT
, CLM_MAX_ORDER_QUANTITY CLM_MAX_ORDER_QUANTITY
, CLM_MAX_TOTAL_AMOUNT CLM_MAX_TOTAL_AMOUNT
, CLM_MAX_TOTAL_QUANTITY CLM_MAX_TOTAL_QUANTITY
, CLM_MDAPS_MAIS CLM_MDAPS_MAIS
, CLM_MIN_ORDER_AMOUNT CLM_MIN_ORDER_AMOUNT
, CLM_MIN_ORDER_QUANTITY CLM_MIN_ORDER_QUANTITY
, CLM_MIN_TOTAL_AMOUNT CLM_MIN_TOTAL_AMOUNT
, CLM_MIN_TOTAL_QUANTITY CLM_MIN_TOTAL_QUANTITY
, CLM_NAICS CLM_NAICS
, CLM_ORDER_END_DATE CLM_ORDER_END_DATE
, CLM_ORDER_START_DATE CLM_ORDER_START_DATE
, CLM_TOTAL_AMOUNT_ORDERED CLM_TOTAL_AMOUNT_ORDERED
, CLM_TOTAL_QUANTITY_ORDERED CLM_TOTAL_QUANTITY_ORDERED
, FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID
, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, CLM_APPROVED_UNDEF_AMOUNT CLM_APPROVED_UNDEF_AMOUNT
, CLM_DELIVERY_EVENT_CODE CLM_DELIVERY_EVENT_CODE
, CLM_EXHIBIT_NAME CLM_EXHIBIT_NAME
, CLM_PAYMENT_INSTR_CODE CLM_PAYMENT_INSTR_CODE
, CLM_POP_EXCEPTION_REASON CLM_POP_EXCEPTION_REASON
, CLM_UDA_PRICING_TOTAL CLM_UDA_PRICING_TOTAL
, CLM_UNDEF_ACTION_CODE CLM_UNDEF_ACTION_CODE
, CLM_UNDEF_FLAG CLM_UNDEF_FLAG
FROM "PO"."PO_LINES_ARCHIVE_ALL"