VIEW: IGC.IGC_CC_ARC_PO_LINES_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, CLOSED_CODE CLOSED_CODE, PRICE_BREAK_LOOKUP_CODE PRICE_BREAK_LOOKUP_CODE, 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_DATE CLOSED_DATE, CLOSED_REASON CLOSED_REASON, CLOSED_BY CLOSED_BY, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE, ORG_ID ORG_ID, QC_GRADE QC_GRADE, BASE_UOM BASE_UOM, BASE_QTY BASE_QTY, SECONDARY_UOM SECONDARY_UOM, SECONDARY_QTY SECONDARY_QTY, 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, LINE_REFERENCE_NUM LINE_REFERENCE_NUM, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPIRATION_DATE EXPIRATION_DATE, TAX_CODE_ID TAX_CODE_ID from "IGC"."IGC_CC_ARC_PO_LINES_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
, CLOSED_CODE CLOSED_CODE
, PRICE_BREAK_LOOKUP_CODE PRICE_BREAK_LOOKUP_CODE
, 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_DATE CLOSED_DATE
, CLOSED_REASON CLOSED_REASON
, CLOSED_BY CLOSED_BY
, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE
, ORG_ID ORG_ID
, QC_GRADE QC_GRADE
, BASE_UOM BASE_UOM
, BASE_QTY BASE_QTY
, SECONDARY_UOM SECONDARY_UOM
, SECONDARY_QTY SECONDARY_QTY
, 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
, LINE_REFERENCE_NUM LINE_REFERENCE_NUM
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPIRATION_DATE EXPIRATION_DATE
, TAX_CODE_ID TAX_CODE_ID
FROM "IGC"."IGC_CC_ARC_PO_LINES_ALL"