PO_INTG_LINES

Details

Schema: FUSION
Object owner: PO
Object type: VIEW

Columns

Name
PO_LINE_ID DISCOUNT_TYPE DISCOUNT DISCOUNT_REASON LIST_PRICE FUNDS_STATUS CONFIGURED_ITEM_FLAG PARENT_ITEM_ID SUPPLIER_PARENT_ITEM TOP_MODEL_ID SUPPLIER_TOP_MODEL COMPONENT_AMOUNT_RELEASED AMOUNT_RELEASED BASE_MODEL_ID BASE_MODEL_PRICE OPTIONS_PRICE AGING_PERIOD_DAYS CONSIGNMENT_LINE_FLAG CATALOG_NAME LINE_STATUS LAST_UPDATE_DATE LAST_UPDATED_BY PO_HEADER_ID LINE_TYPE_ID LINE_NUM LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY ITEM_ID ITEM_REVISION CATEGORY_ID ITEM_DESCRIPTION PRICING_UOM_CODE QUANTITY_COMMITTED COMMITTED_AMOUNT ALLOW_PRICE_OVERRIDE_FLAG NOT_TO_EXCEED_PRICE LIST_PRICE_PER_UNIT UNIT_PRICE PRICING_QUANTITY TAX_EXCLUSIVE_PRICE UN_NUMBER_ID HAZARD_CLASS_ID NOTE_TO_VENDOR FROM_HEADER_ID FROM_LINE_ID QTY_RCV_TOLERANCE PRC_BU_ID REQ_BU_ID OVER_TOLERANCE_ERROR_FLAG MARKET_PRICE UNORDERED_FLAG CANCEL_FLAG CANCELLED_BY CANCEL_DATE CANCEL_REASON FIRM_STATUS_LOOKUP_CODE FIRM_DATE VENDOR_PRODUCT_NUM TAXABLE_FLAG TAX_NAME TYPE_1099 CAPITAL_EXPENSE_FLAG NEGOTIATED_BY_PREPARER_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 REFERENCE_NUM ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP10 MIN_RELEASE_AMOUNT PRICE_TYPE_LOOKUP_CODE PRICE_BREAK_LOOKUP_CODE GOVERNMENT_CONTEXT REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE PROGRAM_NAME PROGRAM_APP_NAME CLOSED_DATE CLOSED_REASON CLOSED_BY SOLDTO_BU_ID QC_GRADE BASE_UOM BASE_QTY GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 LINE_REFERENCE_NUM EXPIRATION_DATE TAX_CODE_ID OKE_CONTRACT_HEADER_ID OKE_CONTRACT_VERSION_ID SECONDARY_QUANTITY SECONDARY_UOM_CODE PREFERRED_GRADE AUCTION_HEADER_ID AUCTION_DISPLAY_NUMBER AUCTION_LINE_NUMBER BID_NUMBER BID_LINE_NUMBER RETROACTIVE_DATE SUPPLIER_REF_NUMBER CONTRACT_ID START_DATE AMOUNT JOB_ID CONTRACTOR_FIRST_NAME CONTRACTOR_LAST_NAME FROM_LINE_LOCATION_ID ORDER_TYPE_LOOKUP_CODE PURCHASE_BASIS MATCHING_BASIS SVC_AMOUNT_NOTIF_SENT SVC_COMPLETION_NOTIF_SENT BASE_UNIT_PRICE MANUAL_PRICE_CHANGE_FLAG RETAINAGE_RATE MAX_RETAINAGE_AMOUNT PROGRESS_PAYMENT_RATE RECOUPMENT_RATE SUPPLIER_PART_AUXID TAX_ATTRIBUTE_UPDATE_CODE LAST_UPDATED_PROGRAM OBJECT_VERSION_NUMBER ALLOW_DESCRIPTION_UPDATE_FLAG PJC_CONTEXT_CATEGORY SOURCE_DOC_REV_NUM NEXT_CONSUMPTION_ADV_GEN_DATE WORK_ORDER_PRODUCT MANUFACTURER MANUFACTURER_PART_NUM UOM_CODE QUANTITY CREDIT_FLAG SH_ATTRIBUTE_CATEGORY SH_ATTRIBUTE1 SH_ATTRIBUTE2 SH_ATTRIBUTE3 SH_ATTRIBUTE4 SH_ATTRIBUTE5 SH_ATTRIBUTE6 SH_ATTRIBUTE7 SH_ATTRIBUTE8 SH_ATTRIBUTE9 SH_ATTRIBUTE10 SH_ATTRIBUTE11 SH_ATTRIBUTE12 SH_ATTRIBUTE13 SH_ATTRIBUTE14 SH_ATTRIBUTE15 SH_ATTRIBUTE16 SH_ATTRIBUTE17 SH_ATTRIBUTE18 SH_ATTRIBUTE19 SH_ATTRIBUTE20 SH_ATTRIBUTE_NUMBER1 SH_ATTRIBUTE_NUMBER2 SH_ATTRIBUTE_NUMBER3 SH_ATTRIBUTE_NUMBER4 SH_ATTRIBUTE_NUMBER5 SH_ATTRIBUTE_NUMBER6 SH_ATTRIBUTE_NUMBER7 SH_ATTRIBUTE_NUMBER8 SH_ATTRIBUTE_NUMBER9 SH_ATTRIBUTE_NUMBER10 SH_ATTRIBUTE_DATE1 SH_ATTRIBUTE_DATE2 SH_ATTRIBUTE_DATE3 SH_ATTRIBUTE_DATE4 SH_ATTRIBUTE_DATE5 SH_ATTRIBUTE_DATE6 SH_ATTRIBUTE_DATE7 SH_ATTRIBUTE_DATE8 SH_ATTRIBUTE_DATE9 SH_ATTRIBUTE_DATE10 SH_ATTRIBUTE_TIMESTAMP1 SH_ATTRIBUTE_TIMESTAMP2 SH_ATTRIBUTE_TIMESTAMP3 SH_ATTRIBUTE_TIMESTAMP4 SH_ATTRIBUTE_TIMESTAMP5 SH_ATTRIBUTE_TIMESTAMP6 SH_ATTRIBUTE_TIMESTAMP7 SH_ATTRIBUTE_TIMESTAMP8 SH_ATTRIBUTE_TIMESTAMP9 SH_ATTRIBUTE_TIMESTAMP10

Name

PO_LINE_ID

DISCOUNT_TYPE

DISCOUNT

DISCOUNT_REASON

LIST_PRICE

FUNDS_STATUS

CONFIGURED_ITEM_FLAG

PARENT_ITEM_ID

SUPPLIER_PARENT_ITEM

TOP_MODEL_ID

SUPPLIER_TOP_MODEL

COMPONENT_AMOUNT_RELEASED

AMOUNT_RELEASED

BASE_MODEL_ID

BASE_MODEL_PRICE

OPTIONS_PRICE

AGING_PERIOD_DAYS

CONSIGNMENT_LINE_FLAG

CATALOG_NAME

LINE_STATUS

LAST_UPDATE_DATE

LAST_UPDATED_BY

PO_HEADER_ID

LINE_TYPE_ID

LINE_NUM

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

ITEM_ID

ITEM_REVISION

CATEGORY_ID

ITEM_DESCRIPTION

PRICING_UOM_CODE

QUANTITY_COMMITTED

COMMITTED_AMOUNT

ALLOW_PRICE_OVERRIDE_FLAG

NOT_TO_EXCEED_PRICE

LIST_PRICE_PER_UNIT

UNIT_PRICE

PRICING_QUANTITY

TAX_EXCLUSIVE_PRICE

UN_NUMBER_ID

HAZARD_CLASS_ID

NOTE_TO_VENDOR

FROM_HEADER_ID

FROM_LINE_ID

QTY_RCV_TOLERANCE

PRC_BU_ID

REQ_BU_ID

OVER_TOLERANCE_ERROR_FLAG

MARKET_PRICE

UNORDERED_FLAG

CANCEL_FLAG

CANCELLED_BY

CANCEL_DATE

CANCEL_REASON

FIRM_STATUS_LOOKUP_CODE

FIRM_DATE

VENDOR_PRODUCT_NUM

TAXABLE_FLAG

TAX_NAME

TYPE_1099

CAPITAL_EXPENSE_FLAG

NEGOTIATED_BY_PREPARER_FLAG

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

REFERENCE_NUM

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

ATTRIBUTE_TIMESTAMP6

ATTRIBUTE_TIMESTAMP7

ATTRIBUTE_TIMESTAMP8

ATTRIBUTE_TIMESTAMP9

ATTRIBUTE_TIMESTAMP10

MIN_RELEASE_AMOUNT

PRICE_TYPE_LOOKUP_CODE

PRICE_BREAK_LOOKUP_CODE

GOVERNMENT_CONTEXT

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

PROGRAM_NAME

PROGRAM_APP_NAME

CLOSED_DATE

CLOSED_REASON

CLOSED_BY

SOLDTO_BU_ID

QC_GRADE

BASE_UOM

BASE_QTY

GLOBAL_ATTRIBUTE_CATEGORY

GLOBAL_ATTRIBUTE1

GLOBAL_ATTRIBUTE2

GLOBAL_ATTRIBUTE3

GLOBAL_ATTRIBUTE4

GLOBAL_ATTRIBUTE5

GLOBAL_ATTRIBUTE6

GLOBAL_ATTRIBUTE7

GLOBAL_ATTRIBUTE8

GLOBAL_ATTRIBUTE9

GLOBAL_ATTRIBUTE10

GLOBAL_ATTRIBUTE11

GLOBAL_ATTRIBUTE12

GLOBAL_ATTRIBUTE13

GLOBAL_ATTRIBUTE14

GLOBAL_ATTRIBUTE15

GLOBAL_ATTRIBUTE16

GLOBAL_ATTRIBUTE17

GLOBAL_ATTRIBUTE18

GLOBAL_ATTRIBUTE19

GLOBAL_ATTRIBUTE20

GLOBAL_ATTRIBUTE_DATE1

GLOBAL_ATTRIBUTE_DATE2

GLOBAL_ATTRIBUTE_DATE3

GLOBAL_ATTRIBUTE_DATE4

GLOBAL_ATTRIBUTE_DATE5

GLOBAL_ATTRIBUTE_NUMBER1

GLOBAL_ATTRIBUTE_NUMBER2

GLOBAL_ATTRIBUTE_NUMBER3

GLOBAL_ATTRIBUTE_NUMBER4

GLOBAL_ATTRIBUTE_NUMBER5

LINE_REFERENCE_NUM

EXPIRATION_DATE

TAX_CODE_ID

OKE_CONTRACT_HEADER_ID

OKE_CONTRACT_VERSION_ID

SECONDARY_QUANTITY

SECONDARY_UOM_CODE

PREFERRED_GRADE

AUCTION_HEADER_ID

AUCTION_DISPLAY_NUMBER

AUCTION_LINE_NUMBER

BID_NUMBER

BID_LINE_NUMBER

RETROACTIVE_DATE

SUPPLIER_REF_NUMBER

CONTRACT_ID

START_DATE

AMOUNT

JOB_ID

CONTRACTOR_FIRST_NAME

CONTRACTOR_LAST_NAME

FROM_LINE_LOCATION_ID

ORDER_TYPE_LOOKUP_CODE

PURCHASE_BASIS

MATCHING_BASIS

SVC_AMOUNT_NOTIF_SENT

SVC_COMPLETION_NOTIF_SENT

BASE_UNIT_PRICE

MANUAL_PRICE_CHANGE_FLAG

RETAINAGE_RATE

MAX_RETAINAGE_AMOUNT

PROGRESS_PAYMENT_RATE

RECOUPMENT_RATE

SUPPLIER_PART_AUXID

TAX_ATTRIBUTE_UPDATE_CODE

LAST_UPDATED_PROGRAM

OBJECT_VERSION_NUMBER

ALLOW_DESCRIPTION_UPDATE_FLAG

PJC_CONTEXT_CATEGORY

SOURCE_DOC_REV_NUM

NEXT_CONSUMPTION_ADV_GEN_DATE

WORK_ORDER_PRODUCT

MANUFACTURER

MANUFACTURER_PART_NUM

UOM_CODE

QUANTITY

CREDIT_FLAG

SH_ATTRIBUTE_CATEGORY

SH_ATTRIBUTE1

SH_ATTRIBUTE2

SH_ATTRIBUTE3

SH_ATTRIBUTE4

SH_ATTRIBUTE5

SH_ATTRIBUTE6

SH_ATTRIBUTE7

SH_ATTRIBUTE8

SH_ATTRIBUTE9

SH_ATTRIBUTE10

SH_ATTRIBUTE11

SH_ATTRIBUTE12

SH_ATTRIBUTE13

SH_ATTRIBUTE14

SH_ATTRIBUTE15

SH_ATTRIBUTE16

SH_ATTRIBUTE17

SH_ATTRIBUTE18

SH_ATTRIBUTE19

SH_ATTRIBUTE20

SH_ATTRIBUTE_NUMBER1

SH_ATTRIBUTE_NUMBER2

SH_ATTRIBUTE_NUMBER3

SH_ATTRIBUTE_NUMBER4

SH_ATTRIBUTE_NUMBER5

SH_ATTRIBUTE_NUMBER6

SH_ATTRIBUTE_NUMBER7

SH_ATTRIBUTE_NUMBER8

SH_ATTRIBUTE_NUMBER9

SH_ATTRIBUTE_NUMBER10

SH_ATTRIBUTE_DATE1

SH_ATTRIBUTE_DATE2

SH_ATTRIBUTE_DATE3

SH_ATTRIBUTE_DATE4

SH_ATTRIBUTE_DATE5

SH_ATTRIBUTE_DATE6

SH_ATTRIBUTE_DATE7

SH_ATTRIBUTE_DATE8

SH_ATTRIBUTE_DATE9

SH_ATTRIBUTE_DATE10

SH_ATTRIBUTE_TIMESTAMP1

SH_ATTRIBUTE_TIMESTAMP2

SH_ATTRIBUTE_TIMESTAMP3

SH_ATTRIBUTE_TIMESTAMP4

SH_ATTRIBUTE_TIMESTAMP5

SH_ATTRIBUTE_TIMESTAMP6

SH_ATTRIBUTE_TIMESTAMP7

SH_ATTRIBUTE_TIMESTAMP8

SH_ATTRIBUTE_TIMESTAMP9

SH_ATTRIBUTE_TIMESTAMP10

Query

SQL_Statement
SELECT PO_LINES_ALL.PO_LINE_ID PO_LINE_ID, PO_LINES_ALL.DISCOUNT_TYPE DISCOUNT_TYPE, PO_LINES_ALL.DISCOUNT DISCOUNT, PO_LINES_ALL.DISCOUNT_REASON DISCOUNT_REASON, PO_LINES_ALL.LIST_PRICE LIST_PRICE, PO_LINES_ALL.FUNDS_STATUS FUNDS_STATUS, PO_LINES_ALL.CONFIGURED_ITEM_FLAG CONFIGURED_ITEM_FLAG, PO_LINES_ALL.PARENT_ITEM_ID PARENT_ITEM_ID, PO_LINES_ALL.SUPPLIER_PARENT_ITEM SUPPLIER_PARENT_ITEM, PO_LINES_ALL.TOP_MODEL_ID TOP_MODEL_ID, PO_LINES_ALL.SUPPLIER_TOP_MODEL SUPPLIER_TOP_MODEL, PO_LINES_ALL.COMPONENT_AMOUNT_RELEASED COMPONENT_AMOUNT_RELEASED, PO_LINES_ALL.AMOUNT_RELEASED AMOUNT_RELEASED, PO_LINES_ALL.BASE_MODEL_ID BASE_MODEL_ID, PO_LINES_ALL.BASE_MODEL_PRICE BASE_MODEL_PRICE, PO_LINES_ALL.OPTIONS_PRICE OPTIONS_PRICE, PO_LINES_ALL.AGING_PERIOD_DAYS AGING_PERIOD_DAYS, PO_LINES_ALL.CONSIGNMENT_LINE_FLAG CONSIGNMENT_LINE_FLAG, PO_LINES_ALL.CATALOG_NAME CATALOG_NAME, PO_LINES_ALL.LINE_STATUS LINE_STATUS, PO_LINES_ALL.LAST_UPDATE_DATE LAST_UPDATE_DATE, PO_LINES_ALL.LAST_UPDATED_BY LAST_UPDATED_BY, PO_LINES_ALL.PO_HEADER_ID PO_HEADER_ID, PO_LINES_ALL.LINE_TYPE_ID LINE_TYPE_ID, PO_LINES_ALL.LINE_NUM LINE_NUM, PO_LINES_ALL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PO_LINES_ALL.CREATION_DATE CREATION_DATE, PO_LINES_ALL.CREATED_BY CREATED_BY, PO_LINES_ALL.ITEM_ID ITEM_ID, PO_LINES_ALL.ITEM_REVISION ITEM_REVISION, PO_LINES_ALL.CATEGORY_ID CATEGORY_ID, PO_LINES_ALL.ITEM_DESCRIPTION ITEM_DESCRIPTION, PO_LINES_ALL.UOM_CODE PRICING_UOM_CODE, PO_LINES_ALL.QUANTITY_COMMITTED QUANTITY_COMMITTED, PO_LINES_ALL.COMMITTED_AMOUNT COMMITTED_AMOUNT, PO_LINES_ALL.ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG, PO_LINES_ALL.NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE, PO_LINES_ALL.LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT, PO_LINES_ALL.UNIT_PRICE UNIT_PRICE, PO_LINES_ALL.QUANTITY PRICING_QUANTITY, PO_LINES_ALL.TAX_EXCLUSIVE_PRICE TAX_EXCLUSIVE_PRICE, PO_LINES_ALL.UN_NUMBER_ID UN_NUMBER_ID, PO_LINES_ALL.HAZARD_CLASS_ID HAZARD_CLASS_ID, PO_LINES_ALL.NOTE_TO_VENDOR NOTE_TO_VENDOR, PO_LINES_ALL.FROM_HEADER_ID FROM_HEADER_ID, PO_LINES_ALL.FROM_LINE_ID FROM_LINE_ID, PO_LINES_ALL.QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE, PO_LINES_ALL.PRC_BU_ID PRC_BU_ID, PO_LINES_ALL.REQ_BU_ID REQ_BU_ID, PO_LINES_ALL.OVER_TOLERANCE_ERROR_FLAG OVER_TOLERANCE_ERROR_FLAG, PO_LINES_ALL.MARKET_PRICE MARKET_PRICE, PO_LINES_ALL.UNORDERED_FLAG UNORDERED_FLAG, PO_LINES_ALL.CANCEL_FLAG CANCEL_FLAG, PO_LINES_ALL.CANCELLED_BY CANCELLED_BY, PO_LINES_ALL.CANCEL_DATE CANCEL_DATE, PO_LINES_ALL.CANCEL_REASON CANCEL_REASON, PO_LINES_ALL.FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE, PO_LINES_ALL.FIRM_DATE FIRM_DATE, PO_LINES_ALL.VENDOR_PRODUCT_NUM VENDOR_PRODUCT_NUM, PO_LINES_ALL.TAXABLE_FLAG TAXABLE_FLAG, PO_LINES_ALL.TAX_NAME TAX_NAME, PO_LINES_ALL.TYPE_1099 TYPE_1099, PO_LINES_ALL.CAPITAL_EXPENSE_FLAG CAPITAL_EXPENSE_FLAG, PO_LINES_ALL.NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG, PO_LINES_ALL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, PO_LINES_ALL.ATTRIBUTE1 ATTRIBUTE1, PO_LINES_ALL.ATTRIBUTE2 ATTRIBUTE2, PO_LINES_ALL.ATTRIBUTE3 ATTRIBUTE3, PO_LINES_ALL.ATTRIBUTE4 ATTRIBUTE4, PO_LINES_ALL.ATTRIBUTE5 ATTRIBUTE5, PO_LINES_ALL.ATTRIBUTE6 ATTRIBUTE6, PO_LINES_ALL.ATTRIBUTE7 ATTRIBUTE7, PO_LINES_ALL.ATTRIBUTE8 ATTRIBUTE8, PO_LINES_ALL.ATTRIBUTE9 ATTRIBUTE9, PO_LINES_ALL.ATTRIBUTE10 ATTRIBUTE10, PO_LINES_ALL.REFERENCE_NUM REFERENCE_NUM, PO_LINES_ALL.ATTRIBUTE11 ATTRIBUTE11, PO_LINES_ALL.ATTRIBUTE12 ATTRIBUTE12, PO_LINES_ALL.ATTRIBUTE13 ATTRIBUTE13, PO_LINES_ALL.ATTRIBUTE14 ATTRIBUTE14, PO_LINES_ALL.ATTRIBUTE15 ATTRIBUTE15, PO_LINES_ALL.ATTRIBUTE16 ATTRIBUTE16, PO_LINES_ALL.ATTRIBUTE17 ATTRIBUTE17, PO_LINES_ALL.ATTRIBUTE18 ATTRIBUTE18, PO_LINES_ALL.ATTRIBUTE19 ATTRIBUTE19, PO_LINES_ALL.ATTRIBUTE20 ATTRIBUTE20, PO_LINES_ALL.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, PO_LINES_ALL.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, PO_LINES_ALL.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, PO_LINES_ALL.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, PO_LINES_ALL.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, PO_LINES_ALL.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, PO_LINES_ALL.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, PO_LINES_ALL.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, PO_LINES_ALL.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, PO_LINES_ALL.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, PO_LINES_ALL.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, PO_LINES_ALL.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, PO_LINES_ALL.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, PO_LINES_ALL.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, PO_LINES_ALL.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, PO_LINES_ALL.ATTRIBUTE_DATE6 ATTRIBUTE_DATE6, PO_LINES_ALL.ATTRIBUTE_DATE7 ATTRIBUTE_DATE7, PO_LINES_ALL.ATTRIBUTE_DATE8 ATTRIBUTE_DATE8, PO_LINES_ALL.ATTRIBUTE_DATE9 ATTRIBUTE_DATE9, PO_LINES_ALL.ATTRIBUTE_DATE10 ATTRIBUTE_DATE10, PO_LINES_ALL.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, PO_LINES_ALL.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, PO_LINES_ALL.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, PO_LINES_ALL.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, PO_LINES_ALL.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, PO_LINES_ALL.ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP6, PO_LINES_ALL.ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP7, PO_LINES_ALL.ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP8, PO_LINES_ALL.ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP9, PO_LINES_ALL.ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP10, PO_LINES_ALL.MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT, PO_LINES_ALL.PRICE_TYPE_LOOKUP_CODE PRICE_TYPE_LOOKUP_CODE, PO_LINES_ALL.PRICE_BREAK_LOOKUP_CODE PRICE_BREAK_LOOKUP_CODE, PO_LINES_ALL.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, PO_LINES_ALL.REQUEST_ID REQUEST_ID, PO_LINES_ALL.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, PO_LINES_ALL.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, PO_LINES_ALL.PROGRAM_NAME PROGRAM_NAME, PO_LINES_ALL.PROGRAM_APP_NAME PROGRAM_APP_NAME, PO_LINES_ALL.CLOSED_DATE CLOSED_DATE, PO_LINES_ALL.CLOSED_REASON CLOSED_REASON, PO_LINES_ALL.CLOSED_BY CLOSED_BY, PO_LINES_ALL.SOLDTO_BU_ID SOLDTO_BU_ID, PO_LINES_ALL.QC_GRADE QC_GRADE, PO_LINES_ALL.BASE_UOM BASE_UOM, PO_LINES_ALL.BASE_QTY BASE_QTY, PO_LINES_ALL.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, PO_LINES_ALL.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, PO_LINES_ALL.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, PO_LINES_ALL.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, PO_LINES_ALL.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, PO_LINES_ALL.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, PO_LINES_ALL.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, PO_LINES_ALL.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, PO_LINES_ALL.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, PO_LINES_ALL.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, PO_LINES_ALL.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, PO_LINES_ALL.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, PO_LINES_ALL.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, PO_LINES_ALL.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, PO_LINES_ALL.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, PO_LINES_ALL.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, PO_LINES_ALL.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, PO_LINES_ALL.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, PO_LINES_ALL.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, PO_LINES_ALL.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, PO_LINES_ALL.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, PO_LINES_ALL.GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE1, PO_LINES_ALL.GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE2, PO_LINES_ALL.GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE3, PO_LINES_ALL.GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE4, PO_LINES_ALL.GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE5, PO_LINES_ALL.GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER1, PO_LINES_ALL.GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER2, PO_LINES_ALL.GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER3, PO_LINES_ALL.GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER4, PO_LINES_ALL.GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER5, PO_LINES_ALL.LINE_REFERENCE_NUM LINE_REFERENCE_NUM, PO_LINES_ALL.EXPIRATION_DATE EXPIRATION_DATE, PO_LINES_ALL.TAX_CODE_ID TAX_CODE_ID, PO_LINES_ALL.OKE_CONTRACT_HEADER_ID OKE_CONTRACT_HEADER_ID, PO_LINES_ALL.OKE_CONTRACT_VERSION_ID OKE_CONTRACT_VERSION_ID, PO_LINES_ALL.SECONDARY_QUANTITY SECONDARY_QUANTITY, PO_LINES_ALL.SECONDARY_UOM_CODE SECONDARY_UOM_CODE, PO_LINES_ALL.PREFERRED_GRADE PREFERRED_GRADE, PO_LINES_ALL.AUCTION_HEADER_ID AUCTION_HEADER_ID, PO_LINES_ALL.AUCTION_DISPLAY_NUMBER AUCTION_DISPLAY_NUMBER, PO_LINES_ALL.AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER, PO_LINES_ALL.BID_NUMBER BID_NUMBER, PO_LINES_ALL.BID_LINE_NUMBER BID_LINE_NUMBER, PO_LINES_ALL.RETROACTIVE_DATE RETROACTIVE_DATE, PO_LINES_ALL.SUPPLIER_REF_NUMBER SUPPLIER_REF_NUMBER, PO_LINES_ALL.CONTRACT_ID CONTRACT_ID, PO_LINES_ALL.START_DATE START_DATE, PO_LINES_ALL.AMOUNT AMOUNT, PO_LINES_ALL.JOB_ID JOB_ID, PO_LINES_ALL.CONTRACTOR_FIRST_NAME CONTRACTOR_FIRST_NAME, PO_LINES_ALL.CONTRACTOR_LAST_NAME CONTRACTOR_LAST_NAME, PO_LINES_ALL.FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID, PO_LINES_ALL.ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE, PO_LINES_ALL.PURCHASE_BASIS PURCHASE_BASIS, PO_LINES_ALL.MATCHING_BASIS MATCHING_BASIS, PO_LINES_ALL.SVC_AMOUNT_NOTIF_SENT SVC_AMOUNT_NOTIF_SENT, PO_LINES_ALL.SVC_COMPLETION_NOTIF_SENT SVC_COMPLETION_NOTIF_SENT, PO_LINES_ALL.BASE_UNIT_PRICE BASE_UNIT_PRICE, PO_LINES_ALL.MANUAL_PRICE_CHANGE_FLAG MANUAL_PRICE_CHANGE_FLAG, PO_LINES_ALL.RETAINAGE_RATE RETAINAGE_RATE, PO_LINES_ALL.MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT, PO_LINES_ALL.PROGRESS_PAYMENT_RATE PROGRESS_PAYMENT_RATE, PO_LINES_ALL.RECOUPMENT_RATE RECOUPMENT_RATE, PO_LINES_ALL.SUPPLIER_PART_AUXID SUPPLIER_PART_AUXID, PO_LINES_ALL.TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE, PO_LINES_ALL.LAST_UPDATED_PROGRAM LAST_UPDATED_PROGRAM, PO_LINES_ALL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PO_LINES_ALL.ALLOW_DESCRIPTION_UPDATE_FLAG ALLOW_DESCRIPTION_UPDATE_FLAG, PO_LINES_ALL.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY, PO_LINES_ALL.SOURCE_DOC_REV_NUM SOURCE_DOC_REV_NUM, PO_LINES_ALL.NEXT_CONSUMPTION_ADV_GEN_DATE NEXT_CONSUMPTION_ADV_GEN_DATE, PO_LINES_ALL.WORK_ORDER_PRODUCT WORK_ORDER_PRODUCT, PO_LINES_ALL.MANUFACTURER MANUFACTURER, PO_LINES_ALL.MANUFACTURER_PART_NUM MANUFACTURER_PART_NUM, PO_LINES_ALL.SHIPPING_UOM_CODE UOM_CODE, PO_LINES_ALL.SHIPPING_UOM_QUANTITY QUANTITY, PO_LINES_ALL.CREDIT_FLAG CREDIT_FLAG, PO_LINES_ALL.SH_ATTRIBUTE_CATEGORY SH_ATTRIBUTE_CATEGORY, PO_LINES_ALL.SH_ATTRIBUTE1 SH_ATTRIBUTE1, PO_LINES_ALL.SH_ATTRIBUTE2 SH_ATTRIBUTE2, PO_LINES_ALL.SH_ATTRIBUTE3 SH_ATTRIBUTE3, PO_LINES_ALL.SH_ATTRIBUTE4 SH_ATTRIBUTE4, PO_LINES_ALL.SH_ATTRIBUTE5 SH_ATTRIBUTE5, PO_LINES_ALL.SH_ATTRIBUTE6 SH_ATTRIBUTE6, PO_LINES_ALL.SH_ATTRIBUTE7 SH_ATTRIBUTE7, PO_LINES_ALL.SH_ATTRIBUTE8 SH_ATTRIBUTE8, PO_LINES_ALL.SH_ATTRIBUTE9 SH_ATTRIBUTE9, PO_LINES_ALL.SH_ATTRIBUTE10 SH_ATTRIBUTE10, PO_LINES_ALL.SH_ATTRIBUTE11 SH_ATTRIBUTE11, PO_LINES_ALL.SH_ATTRIBUTE12 SH_ATTRIBUTE12, PO_LINES_ALL.SH_ATTRIBUTE13 SH_ATTRIBUTE13, PO_LINES_ALL.SH_ATTRIBUTE14 SH_ATTRIBUTE14, PO_LINES_ALL.SH_ATTRIBUTE15 SH_ATTRIBUTE15, PO_LINES_ALL.SH_ATTRIBUTE16 SH_ATTRIBUTE16, PO_LINES_ALL.SH_ATTRIBUTE17 SH_ATTRIBUTE17, PO_LINES_ALL.SH_ATTRIBUTE18 SH_ATTRIBUTE18, PO_LINES_ALL.SH_ATTRIBUTE19 SH_ATTRIBUTE19, PO_LINES_ALL.SH_ATTRIBUTE20 SH_ATTRIBUTE20, PO_LINES_ALL.SH_ATTRIBUTE_NUMBER1 SH_ATTRIBUTE_NUMBER1, PO_LINES_ALL.SH_ATTRIBUTE_NUMBER2 SH_ATTRIBUTE_NUMBER2, PO_LINES_ALL.SH_ATTRIBUTE_NUMBER3 SH_ATTRIBUTE_NUMBER3, PO_LINES_ALL.SH_ATTRIBUTE_NUMBER4 SH_ATTRIBUTE_NUMBER4, PO_LINES_ALL.SH_ATTRIBUTE_NUMBER5 SH_ATTRIBUTE_NUMBER5, PO_LINES_ALL.SH_ATTRIBUTE_NUMBER6 SH_ATTRIBUTE_NUMBER6, PO_LINES_ALL.SH_ATTRIBUTE_NUMBER7 SH_ATTRIBUTE_NUMBER7, PO_LINES_ALL.SH_ATTRIBUTE_NUMBER8 SH_ATTRIBUTE_NUMBER8, PO_LINES_ALL.SH_ATTRIBUTE_NUMBER9 SH_ATTRIBUTE_NUMBER9, PO_LINES_ALL.SH_ATTRIBUTE_NUMBER10 SH_ATTRIBUTE_NUMBER10, PO_LINES_ALL.SH_ATTRIBUTE_DATE1 SH_ATTRIBUTE_DATE1, PO_LINES_ALL.SH_ATTRIBUTE_DATE2 SH_ATTRIBUTE_DATE2, PO_LINES_ALL.SH_ATTRIBUTE_DATE3 SH_ATTRIBUTE_DATE3, PO_LINES_ALL.SH_ATTRIBUTE_DATE4 SH_ATTRIBUTE_DATE4, PO_LINES_ALL.SH_ATTRIBUTE_DATE5 SH_ATTRIBUTE_DATE5, PO_LINES_ALL.SH_ATTRIBUTE_DATE6 SH_ATTRIBUTE_DATE6, PO_LINES_ALL.SH_ATTRIBUTE_DATE7 SH_ATTRIBUTE_DATE7, PO_LINES_ALL.SH_ATTRIBUTE_DATE8 SH_ATTRIBUTE_DATE8, PO_LINES_ALL.SH_ATTRIBUTE_DATE9 SH_ATTRIBUTE_DATE9, PO_LINES_ALL.SH_ATTRIBUTE_DATE10 SH_ATTRIBUTE_DATE10, PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP1 SH_ATTRIBUTE_TIMESTAMP1, PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP2 SH_ATTRIBUTE_TIMESTAMP2, PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP3 SH_ATTRIBUTE_TIMESTAMP3, PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP4 SH_ATTRIBUTE_TIMESTAMP4, PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP5 SH_ATTRIBUTE_TIMESTAMP5, PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP6 SH_ATTRIBUTE_TIMESTAMP6, PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP7 SH_ATTRIBUTE_TIMESTAMP7, PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP8 SH_ATTRIBUTE_TIMESTAMP8, PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP9 SH_ATTRIBUTE_TIMESTAMP9, PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP10 SH_ATTRIBUTE_TIMESTAMP10 FROM PO_LINES_ALL

SQL_Statement

SELECT

PO_LINES_ALL.PO_LINE_ID PO_LINE_ID,

PO_LINES_ALL.DISCOUNT_TYPE DISCOUNT_TYPE,

PO_LINES_ALL.DISCOUNT DISCOUNT,

PO_LINES_ALL.DISCOUNT_REASON DISCOUNT_REASON,

PO_LINES_ALL.LIST_PRICE LIST_PRICE,

PO_LINES_ALL.FUNDS_STATUS FUNDS_STATUS,

PO_LINES_ALL.CONFIGURED_ITEM_FLAG CONFIGURED_ITEM_FLAG,

PO_LINES_ALL.PARENT_ITEM_ID PARENT_ITEM_ID,

PO_LINES_ALL.SUPPLIER_PARENT_ITEM SUPPLIER_PARENT_ITEM,

PO_LINES_ALL.TOP_MODEL_ID TOP_MODEL_ID,

PO_LINES_ALL.SUPPLIER_TOP_MODEL SUPPLIER_TOP_MODEL,

PO_LINES_ALL.COMPONENT_AMOUNT_RELEASED COMPONENT_AMOUNT_RELEASED,

PO_LINES_ALL.AMOUNT_RELEASED AMOUNT_RELEASED,

PO_LINES_ALL.BASE_MODEL_ID BASE_MODEL_ID,

PO_LINES_ALL.BASE_MODEL_PRICE BASE_MODEL_PRICE,

PO_LINES_ALL.OPTIONS_PRICE OPTIONS_PRICE,

PO_LINES_ALL.AGING_PERIOD_DAYS AGING_PERIOD_DAYS,

PO_LINES_ALL.CONSIGNMENT_LINE_FLAG CONSIGNMENT_LINE_FLAG,

PO_LINES_ALL.CATALOG_NAME CATALOG_NAME,

PO_LINES_ALL.LINE_STATUS LINE_STATUS,

PO_LINES_ALL.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PO_LINES_ALL.LAST_UPDATED_BY LAST_UPDATED_BY,

PO_LINES_ALL.PO_HEADER_ID PO_HEADER_ID,

PO_LINES_ALL.LINE_TYPE_ID LINE_TYPE_ID,

PO_LINES_ALL.LINE_NUM LINE_NUM,

PO_LINES_ALL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PO_LINES_ALL.CREATION_DATE CREATION_DATE,

PO_LINES_ALL.CREATED_BY CREATED_BY,

PO_LINES_ALL.ITEM_ID ITEM_ID,

PO_LINES_ALL.ITEM_REVISION ITEM_REVISION,

PO_LINES_ALL.CATEGORY_ID CATEGORY_ID,

PO_LINES_ALL.ITEM_DESCRIPTION ITEM_DESCRIPTION,

PO_LINES_ALL.UOM_CODE PRICING_UOM_CODE,

PO_LINES_ALL.QUANTITY_COMMITTED QUANTITY_COMMITTED,

PO_LINES_ALL.COMMITTED_AMOUNT COMMITTED_AMOUNT,

PO_LINES_ALL.ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG,

PO_LINES_ALL.NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE,

PO_LINES_ALL.LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT,

PO_LINES_ALL.UNIT_PRICE UNIT_PRICE,

PO_LINES_ALL.QUANTITY PRICING_QUANTITY,

PO_LINES_ALL.TAX_EXCLUSIVE_PRICE TAX_EXCLUSIVE_PRICE,

PO_LINES_ALL.UN_NUMBER_ID UN_NUMBER_ID,

PO_LINES_ALL.HAZARD_CLASS_ID HAZARD_CLASS_ID,

PO_LINES_ALL.NOTE_TO_VENDOR NOTE_TO_VENDOR,

PO_LINES_ALL.FROM_HEADER_ID FROM_HEADER_ID,

PO_LINES_ALL.FROM_LINE_ID FROM_LINE_ID,

PO_LINES_ALL.QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE,

PO_LINES_ALL.PRC_BU_ID PRC_BU_ID,

PO_LINES_ALL.REQ_BU_ID REQ_BU_ID,

PO_LINES_ALL.OVER_TOLERANCE_ERROR_FLAG OVER_TOLERANCE_ERROR_FLAG,

PO_LINES_ALL.MARKET_PRICE MARKET_PRICE,

PO_LINES_ALL.UNORDERED_FLAG UNORDERED_FLAG,

PO_LINES_ALL.CANCEL_FLAG CANCEL_FLAG,

PO_LINES_ALL.CANCELLED_BY CANCELLED_BY,

PO_LINES_ALL.CANCEL_DATE CANCEL_DATE,

PO_LINES_ALL.CANCEL_REASON CANCEL_REASON,

PO_LINES_ALL.FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE,

PO_LINES_ALL.FIRM_DATE FIRM_DATE,

PO_LINES_ALL.VENDOR_PRODUCT_NUM VENDOR_PRODUCT_NUM,

PO_LINES_ALL.TAXABLE_FLAG TAXABLE_FLAG,

PO_LINES_ALL.TAX_NAME TAX_NAME,

PO_LINES_ALL.TYPE_1099 TYPE_1099,

PO_LINES_ALL.CAPITAL_EXPENSE_FLAG CAPITAL_EXPENSE_FLAG,

PO_LINES_ALL.NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG,

PO_LINES_ALL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

PO_LINES_ALL.ATTRIBUTE1 ATTRIBUTE1,

PO_LINES_ALL.ATTRIBUTE2 ATTRIBUTE2,

PO_LINES_ALL.ATTRIBUTE3 ATTRIBUTE3,

PO_LINES_ALL.ATTRIBUTE4 ATTRIBUTE4,

PO_LINES_ALL.ATTRIBUTE5 ATTRIBUTE5,

PO_LINES_ALL.ATTRIBUTE6 ATTRIBUTE6,

PO_LINES_ALL.ATTRIBUTE7 ATTRIBUTE7,

PO_LINES_ALL.ATTRIBUTE8 ATTRIBUTE8,

PO_LINES_ALL.ATTRIBUTE9 ATTRIBUTE9,

PO_LINES_ALL.ATTRIBUTE10 ATTRIBUTE10,

PO_LINES_ALL.REFERENCE_NUM REFERENCE_NUM,

PO_LINES_ALL.ATTRIBUTE11 ATTRIBUTE11,

PO_LINES_ALL.ATTRIBUTE12 ATTRIBUTE12,

PO_LINES_ALL.ATTRIBUTE13 ATTRIBUTE13,

PO_LINES_ALL.ATTRIBUTE14 ATTRIBUTE14,

PO_LINES_ALL.ATTRIBUTE15 ATTRIBUTE15,

PO_LINES_ALL.ATTRIBUTE16 ATTRIBUTE16,

PO_LINES_ALL.ATTRIBUTE17 ATTRIBUTE17,

PO_LINES_ALL.ATTRIBUTE18 ATTRIBUTE18,

PO_LINES_ALL.ATTRIBUTE19 ATTRIBUTE19,

PO_LINES_ALL.ATTRIBUTE20 ATTRIBUTE20,

PO_LINES_ALL.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

PO_LINES_ALL.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

PO_LINES_ALL.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

PO_LINES_ALL.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

PO_LINES_ALL.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

PO_LINES_ALL.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6,

PO_LINES_ALL.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7,

PO_LINES_ALL.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8,

PO_LINES_ALL.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9,

PO_LINES_ALL.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10,

PO_LINES_ALL.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

PO_LINES_ALL.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

PO_LINES_ALL.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

PO_LINES_ALL.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

PO_LINES_ALL.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

PO_LINES_ALL.ATTRIBUTE_DATE6 ATTRIBUTE_DATE6,

PO_LINES_ALL.ATTRIBUTE_DATE7 ATTRIBUTE_DATE7,

PO_LINES_ALL.ATTRIBUTE_DATE8 ATTRIBUTE_DATE8,

PO_LINES_ALL.ATTRIBUTE_DATE9 ATTRIBUTE_DATE9,

PO_LINES_ALL.ATTRIBUTE_DATE10 ATTRIBUTE_DATE10,

PO_LINES_ALL.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1,

PO_LINES_ALL.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2,

PO_LINES_ALL.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3,

PO_LINES_ALL.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4,

PO_LINES_ALL.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5,

PO_LINES_ALL.ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP6,

PO_LINES_ALL.ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP7,

PO_LINES_ALL.ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP8,

PO_LINES_ALL.ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP9,

PO_LINES_ALL.ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP10,

PO_LINES_ALL.MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT,

PO_LINES_ALL.PRICE_TYPE_LOOKUP_CODE PRICE_TYPE_LOOKUP_CODE,

PO_LINES_ALL.PRICE_BREAK_LOOKUP_CODE PRICE_BREAK_LOOKUP_CODE,

PO_LINES_ALL.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT,

PO_LINES_ALL.REQUEST_ID REQUEST_ID,

PO_LINES_ALL.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

PO_LINES_ALL.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

PO_LINES_ALL.PROGRAM_NAME PROGRAM_NAME,

PO_LINES_ALL.PROGRAM_APP_NAME PROGRAM_APP_NAME,

PO_LINES_ALL.CLOSED_DATE CLOSED_DATE,

PO_LINES_ALL.CLOSED_REASON CLOSED_REASON,

PO_LINES_ALL.CLOSED_BY CLOSED_BY,

PO_LINES_ALL.SOLDTO_BU_ID SOLDTO_BU_ID,

PO_LINES_ALL.QC_GRADE QC_GRADE,

PO_LINES_ALL.BASE_UOM BASE_UOM,

PO_LINES_ALL.BASE_QTY BASE_QTY,

PO_LINES_ALL.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY,

PO_LINES_ALL.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1,

PO_LINES_ALL.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2,

PO_LINES_ALL.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3,

PO_LINES_ALL.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4,

PO_LINES_ALL.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5,

PO_LINES_ALL.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6,

PO_LINES_ALL.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7,

PO_LINES_ALL.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8,

PO_LINES_ALL.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9,

PO_LINES_ALL.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10,

PO_LINES_ALL.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11,

PO_LINES_ALL.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12,

PO_LINES_ALL.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13,

PO_LINES_ALL.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14,

PO_LINES_ALL.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15,

PO_LINES_ALL.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16,

PO_LINES_ALL.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17,

PO_LINES_ALL.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18,

PO_LINES_ALL.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19,

PO_LINES_ALL.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20,

PO_LINES_ALL.GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE1,

PO_LINES_ALL.GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE2,

PO_LINES_ALL.GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE3,

PO_LINES_ALL.GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE4,

PO_LINES_ALL.GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE5,

PO_LINES_ALL.GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER1,

PO_LINES_ALL.GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER2,

PO_LINES_ALL.GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER3,

PO_LINES_ALL.GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER4,

PO_LINES_ALL.GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER5,

PO_LINES_ALL.LINE_REFERENCE_NUM LINE_REFERENCE_NUM,

PO_LINES_ALL.EXPIRATION_DATE EXPIRATION_DATE,

PO_LINES_ALL.TAX_CODE_ID TAX_CODE_ID,

PO_LINES_ALL.OKE_CONTRACT_HEADER_ID OKE_CONTRACT_HEADER_ID,

PO_LINES_ALL.OKE_CONTRACT_VERSION_ID OKE_CONTRACT_VERSION_ID,

PO_LINES_ALL.SECONDARY_QUANTITY SECONDARY_QUANTITY,

PO_LINES_ALL.SECONDARY_UOM_CODE SECONDARY_UOM_CODE,

PO_LINES_ALL.PREFERRED_GRADE PREFERRED_GRADE,

PO_LINES_ALL.AUCTION_HEADER_ID AUCTION_HEADER_ID,

PO_LINES_ALL.AUCTION_DISPLAY_NUMBER AUCTION_DISPLAY_NUMBER,

PO_LINES_ALL.AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER,

PO_LINES_ALL.BID_NUMBER BID_NUMBER,

PO_LINES_ALL.BID_LINE_NUMBER BID_LINE_NUMBER,

PO_LINES_ALL.RETROACTIVE_DATE RETROACTIVE_DATE,

PO_LINES_ALL.SUPPLIER_REF_NUMBER SUPPLIER_REF_NUMBER,

PO_LINES_ALL.CONTRACT_ID CONTRACT_ID,

PO_LINES_ALL.START_DATE START_DATE,

PO_LINES_ALL.AMOUNT AMOUNT,

PO_LINES_ALL.JOB_ID JOB_ID,

PO_LINES_ALL.CONTRACTOR_FIRST_NAME CONTRACTOR_FIRST_NAME,

PO_LINES_ALL.CONTRACTOR_LAST_NAME CONTRACTOR_LAST_NAME,

PO_LINES_ALL.FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID,

PO_LINES_ALL.ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE,

PO_LINES_ALL.PURCHASE_BASIS PURCHASE_BASIS,

PO_LINES_ALL.MATCHING_BASIS MATCHING_BASIS,

PO_LINES_ALL.SVC_AMOUNT_NOTIF_SENT SVC_AMOUNT_NOTIF_SENT,

PO_LINES_ALL.SVC_COMPLETION_NOTIF_SENT SVC_COMPLETION_NOTIF_SENT,

PO_LINES_ALL.BASE_UNIT_PRICE BASE_UNIT_PRICE,

PO_LINES_ALL.MANUAL_PRICE_CHANGE_FLAG MANUAL_PRICE_CHANGE_FLAG,

PO_LINES_ALL.RETAINAGE_RATE RETAINAGE_RATE,

PO_LINES_ALL.MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT,

PO_LINES_ALL.PROGRESS_PAYMENT_RATE PROGRESS_PAYMENT_RATE,

PO_LINES_ALL.RECOUPMENT_RATE RECOUPMENT_RATE,

PO_LINES_ALL.SUPPLIER_PART_AUXID SUPPLIER_PART_AUXID,

PO_LINES_ALL.TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE,

PO_LINES_ALL.LAST_UPDATED_PROGRAM LAST_UPDATED_PROGRAM,

PO_LINES_ALL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PO_LINES_ALL.ALLOW_DESCRIPTION_UPDATE_FLAG ALLOW_DESCRIPTION_UPDATE_FLAG,

PO_LINES_ALL.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY,

PO_LINES_ALL.SOURCE_DOC_REV_NUM SOURCE_DOC_REV_NUM,

PO_LINES_ALL.NEXT_CONSUMPTION_ADV_GEN_DATE NEXT_CONSUMPTION_ADV_GEN_DATE,

PO_LINES_ALL.WORK_ORDER_PRODUCT WORK_ORDER_PRODUCT,

PO_LINES_ALL.MANUFACTURER MANUFACTURER,

PO_LINES_ALL.MANUFACTURER_PART_NUM MANUFACTURER_PART_NUM,

PO_LINES_ALL.SHIPPING_UOM_CODE UOM_CODE,

PO_LINES_ALL.SHIPPING_UOM_QUANTITY QUANTITY,

PO_LINES_ALL.CREDIT_FLAG CREDIT_FLAG,

PO_LINES_ALL.SH_ATTRIBUTE_CATEGORY SH_ATTRIBUTE_CATEGORY,

PO_LINES_ALL.SH_ATTRIBUTE1 SH_ATTRIBUTE1,

PO_LINES_ALL.SH_ATTRIBUTE2 SH_ATTRIBUTE2,

PO_LINES_ALL.SH_ATTRIBUTE3 SH_ATTRIBUTE3,

PO_LINES_ALL.SH_ATTRIBUTE4 SH_ATTRIBUTE4,

PO_LINES_ALL.SH_ATTRIBUTE5 SH_ATTRIBUTE5,

PO_LINES_ALL.SH_ATTRIBUTE6 SH_ATTRIBUTE6,

PO_LINES_ALL.SH_ATTRIBUTE7 SH_ATTRIBUTE7,

PO_LINES_ALL.SH_ATTRIBUTE8 SH_ATTRIBUTE8,

PO_LINES_ALL.SH_ATTRIBUTE9 SH_ATTRIBUTE9,

PO_LINES_ALL.SH_ATTRIBUTE10 SH_ATTRIBUTE10,

PO_LINES_ALL.SH_ATTRIBUTE11 SH_ATTRIBUTE11,

PO_LINES_ALL.SH_ATTRIBUTE12 SH_ATTRIBUTE12,

PO_LINES_ALL.SH_ATTRIBUTE13 SH_ATTRIBUTE13,

PO_LINES_ALL.SH_ATTRIBUTE14 SH_ATTRIBUTE14,

PO_LINES_ALL.SH_ATTRIBUTE15 SH_ATTRIBUTE15,

PO_LINES_ALL.SH_ATTRIBUTE16 SH_ATTRIBUTE16,

PO_LINES_ALL.SH_ATTRIBUTE17 SH_ATTRIBUTE17,

PO_LINES_ALL.SH_ATTRIBUTE18 SH_ATTRIBUTE18,

PO_LINES_ALL.SH_ATTRIBUTE19 SH_ATTRIBUTE19,

PO_LINES_ALL.SH_ATTRIBUTE20 SH_ATTRIBUTE20,

PO_LINES_ALL.SH_ATTRIBUTE_NUMBER1 SH_ATTRIBUTE_NUMBER1,

PO_LINES_ALL.SH_ATTRIBUTE_NUMBER2 SH_ATTRIBUTE_NUMBER2,

PO_LINES_ALL.SH_ATTRIBUTE_NUMBER3 SH_ATTRIBUTE_NUMBER3,

PO_LINES_ALL.SH_ATTRIBUTE_NUMBER4 SH_ATTRIBUTE_NUMBER4,

PO_LINES_ALL.SH_ATTRIBUTE_NUMBER5 SH_ATTRIBUTE_NUMBER5,

PO_LINES_ALL.SH_ATTRIBUTE_NUMBER6 SH_ATTRIBUTE_NUMBER6,

PO_LINES_ALL.SH_ATTRIBUTE_NUMBER7 SH_ATTRIBUTE_NUMBER7,

PO_LINES_ALL.SH_ATTRIBUTE_NUMBER8 SH_ATTRIBUTE_NUMBER8,

PO_LINES_ALL.SH_ATTRIBUTE_NUMBER9 SH_ATTRIBUTE_NUMBER9,

PO_LINES_ALL.SH_ATTRIBUTE_NUMBER10 SH_ATTRIBUTE_NUMBER10,

PO_LINES_ALL.SH_ATTRIBUTE_DATE1 SH_ATTRIBUTE_DATE1,

PO_LINES_ALL.SH_ATTRIBUTE_DATE2 SH_ATTRIBUTE_DATE2,

PO_LINES_ALL.SH_ATTRIBUTE_DATE3 SH_ATTRIBUTE_DATE3,

PO_LINES_ALL.SH_ATTRIBUTE_DATE4 SH_ATTRIBUTE_DATE4,

PO_LINES_ALL.SH_ATTRIBUTE_DATE5 SH_ATTRIBUTE_DATE5,

PO_LINES_ALL.SH_ATTRIBUTE_DATE6 SH_ATTRIBUTE_DATE6,

PO_LINES_ALL.SH_ATTRIBUTE_DATE7 SH_ATTRIBUTE_DATE7,

PO_LINES_ALL.SH_ATTRIBUTE_DATE8 SH_ATTRIBUTE_DATE8,

PO_LINES_ALL.SH_ATTRIBUTE_DATE9 SH_ATTRIBUTE_DATE9,

PO_LINES_ALL.SH_ATTRIBUTE_DATE10 SH_ATTRIBUTE_DATE10,

PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP1 SH_ATTRIBUTE_TIMESTAMP1,

PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP2 SH_ATTRIBUTE_TIMESTAMP2,

PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP3 SH_ATTRIBUTE_TIMESTAMP3,

PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP4 SH_ATTRIBUTE_TIMESTAMP4,

PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP5 SH_ATTRIBUTE_TIMESTAMP5,

PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP6 SH_ATTRIBUTE_TIMESTAMP6,

PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP7 SH_ATTRIBUTE_TIMESTAMP7,

PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP8 SH_ATTRIBUTE_TIMESTAMP8,

PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP9 SH_ATTRIBUTE_TIMESTAMP9,

PO_LINES_ALL.SH_ATTRIBUTE_TIMESTAMP10 SH_ATTRIBUTE_TIMESTAMP10

FROM

PO_LINES_ALL