VIEW: PO.PO_LINES_INTERFACE#

Source

View Text - Preformatted

select INTERFACE_LINE_ID INTERFACE_LINE_ID, INTERFACE_HEADER_ID INTERFACE_HEADER_ID, ACTION ACTION, GROUP_CODE GROUP_CODE, LINE_NUM LINE_NUM, PO_LINE_ID PO_LINE_ID, SHIPMENT_NUM SHIPMENT_NUM, LINE_LOCATION_ID LINE_LOCATION_ID, SHIPMENT_TYPE SHIPMENT_TYPE, REQUISITION_LINE_ID REQUISITION_LINE_ID, DOCUMENT_NUM DOCUMENT_NUM, RELEASE_NUM RELEASE_NUM, PO_HEADER_ID PO_HEADER_ID, PO_RELEASE_ID PO_RELEASE_ID, SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID, CONTRACT_NUM CONTRACT_NUM, LINE_TYPE LINE_TYPE, LINE_TYPE_ID LINE_TYPE_ID, ITEM ITEM, ITEM_ID ITEM_ID, ITEM_REVISION ITEM_REVISION, CATEGORY CATEGORY, CATEGORY_ID CATEGORY_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, VENDOR_PRODUCT_NUM VENDOR_PRODUCT_NUM, UOM_CODE UOM_CODE, UNIT_OF_MEASURE UNIT_OF_MEASURE, QUANTITY QUANTITY, COMMITTED_AMOUNT COMMITTED_AMOUNT, MIN_ORDER_QUANTITY MIN_ORDER_QUANTITY, MAX_ORDER_QUANTITY MAX_ORDER_QUANTITY, UNIT_PRICE UNIT_PRICE, LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT, MARKET_PRICE MARKET_PRICE, ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG, NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG, UN_NUMBER UN_NUMBER, UN_NUMBER_ID UN_NUMBER_ID, HAZARD_CLASS HAZARD_CLASS, HAZARD_CLASS_ID HAZARD_CLASS_ID, NOTE_TO_VENDOR NOTE_TO_VENDOR, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE, TAXABLE_FLAG TAXABLE_FLAG, TAX_NAME TAX_NAME, TYPE_1099 TYPE_1099, CAPITAL_EXPENSE_FLAG CAPITAL_EXPENSE_FLAG, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG, PAYMENT_TERMS PAYMENT_TERMS, TERMS_ID TERMS_ID, PRICE_TYPE PRICE_TYPE, MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT, PRICE_BREAK_LOOKUP_CODE PRICE_BREAK_LOOKUP_CODE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, CLOSED_CODE CLOSED_CODE, CLOSED_REASON CLOSED_REASON, CLOSED_DATE CLOSED_DATE, CLOSED_BY CLOSED_BY, INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE, RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE, FIRM_FLAG FIRM_FLAG, DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED, DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED, ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE, ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG, RECEIVING_ROUTING RECEIVING_ROUTING, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE, OVER_TOLERANCE_ERROR_FLAG OVER_TOLERANCE_ERROR_FLAG, QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE, RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, SHIP_TO_LOCATION SHIP_TO_LOCATION, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, NEED_BY_DATE NEED_BY_DATE, PROMISED_DATE PROMISED_DATE, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG, LEAD_TIME LEAD_TIME, LEAD_TIME_UNIT LEAD_TIME_UNIT, PRICE_DISCOUNT PRICE_DISCOUNT, FREIGHT_CARRIER FREIGHT_CARRIER, FOB FOB, FREIGHT_TERMS FREIGHT_TERMS, EFFECTIVE_DATE EFFECTIVE_DATE, EXPIRATION_DATE EXPIRATION_DATE, FROM_HEADER_ID FROM_HEADER_ID, FROM_LINE_ID FROM_LINE_ID, FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID, LINE_ATTRIBUTE_CATEGORY_LINES LINE_ATTRIBUTE_CATEGORY_LINES, 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, SHIPMENT_ATTRIBUTE_CATEGORY SHIPMENT_ATTRIBUTE_CATEGORY, SHIPMENT_ATTRIBUTE1 SHIPMENT_ATTRIBUTE1, SHIPMENT_ATTRIBUTE2 SHIPMENT_ATTRIBUTE2, SHIPMENT_ATTRIBUTE3 SHIPMENT_ATTRIBUTE3, SHIPMENT_ATTRIBUTE4 SHIPMENT_ATTRIBUTE4, SHIPMENT_ATTRIBUTE5 SHIPMENT_ATTRIBUTE5, SHIPMENT_ATTRIBUTE6 SHIPMENT_ATTRIBUTE6, SHIPMENT_ATTRIBUTE7 SHIPMENT_ATTRIBUTE7, SHIPMENT_ATTRIBUTE8 SHIPMENT_ATTRIBUTE8, SHIPMENT_ATTRIBUTE9 SHIPMENT_ATTRIBUTE9, SHIPMENT_ATTRIBUTE10 SHIPMENT_ATTRIBUTE10, SHIPMENT_ATTRIBUTE11 SHIPMENT_ATTRIBUTE11, SHIPMENT_ATTRIBUTE12 SHIPMENT_ATTRIBUTE12, SHIPMENT_ATTRIBUTE13 SHIPMENT_ATTRIBUTE13, SHIPMENT_ATTRIBUTE14 SHIPMENT_ATTRIBUTE14, SHIPMENT_ATTRIBUTE15 SHIPMENT_ATTRIBUTE15, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORGANIZATION_ID ORGANIZATION_ID, ITEM_ATTRIBUTE_CATEGORY ITEM_ATTRIBUTE_CATEGORY, ITEM_ATTRIBUTE1 ITEM_ATTRIBUTE1, ITEM_ATTRIBUTE2 ITEM_ATTRIBUTE2, ITEM_ATTRIBUTE3 ITEM_ATTRIBUTE3, ITEM_ATTRIBUTE4 ITEM_ATTRIBUTE4, ITEM_ATTRIBUTE5 ITEM_ATTRIBUTE5, ITEM_ATTRIBUTE6 ITEM_ATTRIBUTE6, ITEM_ATTRIBUTE7 ITEM_ATTRIBUTE7, ITEM_ATTRIBUTE8 ITEM_ATTRIBUTE8, ITEM_ATTRIBUTE9 ITEM_ATTRIBUTE9, ITEM_ATTRIBUTE10 ITEM_ATTRIBUTE10, ITEM_ATTRIBUTE11 ITEM_ATTRIBUTE11, ITEM_ATTRIBUTE12 ITEM_ATTRIBUTE12, ITEM_ATTRIBUTE13 ITEM_ATTRIBUTE13, ITEM_ATTRIBUTE14 ITEM_ATTRIBUTE14, ITEM_ATTRIBUTE15 ITEM_ATTRIBUTE15, UNIT_WEIGHT UNIT_WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, VOLUME_UOM_CODE VOLUME_UOM_CODE, UNIT_VOLUME UNIT_VOLUME, TEMPLATE_ID TEMPLATE_ID, TEMPLATE_NAME TEMPLATE_NAME, LINE_REFERENCE_NUM LINE_REFERENCE_NUM, SOURCING_RULE_NAME SOURCING_RULE_NAME, TAX_STATUS_INDICATOR TAX_STATUS_INDICATOR, PROCESS_CODE PROCESS_CODE, PRICE_CHG_ACCEPT_FLAG PRICE_CHG_ACCEPT_FLAG, PRICE_BREAK_FLAG PRICE_BREAK_FLAG, PRICE_UPDATE_TOLERANCE PRICE_UPDATE_TOLERANCE, TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG, TAX_CODE_ID TAX_CODE_ID, NOTE_TO_RECEIVER NOTE_TO_RECEIVER, OKE_CONTRACT_HEADER_ID OKE_CONTRACT_HEADER_ID, OKE_CONTRACT_HEADER_NUM OKE_CONTRACT_HEADER_NUM, OKE_CONTRACT_VERSION_ID OKE_CONTRACT_VERSION_ID, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE, SECONDARY_UOM_CODE SECONDARY_UOM_CODE, SECONDARY_QUANTITY SECONDARY_QUANTITY, PREFERRED_GRADE PREFERRED_GRADE, VMI_FLAG VMI_FLAG, AUCTION_HEADER_ID AUCTION_HEADER_ID, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER, AUCTION_DISPLAY_NUMBER AUCTION_DISPLAY_NUMBER, BID_NUMBER BID_NUMBER, BID_LINE_NUMBER BID_LINE_NUMBER, ORIG_FROM_REQ_FLAG ORIG_FROM_REQ_FLAG, CONSIGNED_FLAG CONSIGNED_FLAG, SUPPLIER_REF_NUMBER SUPPLIER_REF_NUMBER, CONTRACT_ID CONTRACT_ID, JOB_ID JOB_ID, AMOUNT AMOUNT, JOB_NAME JOB_NAME, CONTRACTOR_FIRST_NAME CONTRACTOR_FIRST_NAME, CONTRACTOR_LAST_NAME CONTRACTOR_LAST_NAME, DROP_SHIP_FLAG DROP_SHIP_FLAG, BASE_UNIT_PRICE BASE_UNIT_PRICE, TRANSACTION_FLOW_HEADER_ID TRANSACTION_FLOW_HEADER_ID, JOB_BUSINESS_GROUP_ID JOB_BUSINESS_GROUP_ID, JOB_BUSINESS_GROUP_NAME JOB_BUSINESS_GROUP_NAME, CATALOG_NAME CATALOG_NAME, SUPPLIER_PART_AUXID SUPPLIER_PART_AUXID, IP_CATEGORY_ID IP_CATEGORY_ID, TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND, SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND, DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH, DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW, PROCESSING_ID PROCESSING_ID, LINE_LOC_POPULATED_FLAG LINE_LOC_POPULATED_FLAG, IP_CATEGORY_NAME IP_CATEGORY_NAME, RETAINAGE_RATE RETAINAGE_RATE, MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT, PROGRESS_PAYMENT_RATE PROGRESS_PAYMENT_RATE, RECOUPMENT_RATE RECOUPMENT_RATE, ADVANCE_AMOUNT ADVANCE_AMOUNT, FILE_LINE_NUMBER FILE_LINE_NUMBER, PARENT_INTERFACE_LINE_ID PARENT_INTERFACE_LINE_ID, FILE_LINE_LANGUAGE FILE_LINE_LANGUAGE, 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_MIN_TOTAL_AMOUNT CLM_MIN_TOTAL_AMOUNT, CLM_MAX_TOTAL_AMOUNT CLM_MAX_TOTAL_AMOUNT, CLM_MIN_TOTAL_QUANTITY CLM_MIN_TOTAL_QUANTITY, CLM_MAX_TOTAL_QUANTITY CLM_MAX_TOTAL_QUANTITY, CLM_MIN_ORDER_AMOUNT CLM_MIN_ORDER_AMOUNT, CLM_MAX_ORDER_AMOUNT CLM_MAX_ORDER_AMOUNT, CLM_MIN_ORDER_QUANTITY CLM_MIN_ORDER_QUANTITY, CLM_MAX_ORDER_QUANTITY CLM_MAX_ORDER_QUANTITY, CLM_TOTAL_AMOUNT_ORDERED CLM_TOTAL_AMOUNT_ORDERED, CLM_TOTAL_QUANTITY_ORDERED CLM_TOTAL_QUANTITY_ORDERED, CLM_PERIOD_PERF_END_DATE CLM_PERIOD_PERF_END_DATE, CLM_PERIOD_PERF_START_DATE CLM_PERIOD_PERF_START_DATE, CONTRACT_TYPE_DISPLAY CONTRACT_TYPE_DISPLAY, COST_CONSTRAINT_DISPLAY COST_CONSTRAINT_DISPLAY, CLM_IDC_TYPE_DISPLAY CLM_IDC_TYPE_DISPLAY, CLM_BASE_LINE_NUM_DISP CLM_BASE_LINE_NUM_DISP, FROM_HEADER_DISP FROM_HEADER_DISP, FROM_LINE_DISP FROM_LINE_DISP, CLM_APPROVED_UNDEF_AMOUNT CLM_APPROVED_UNDEF_AMOUNT, CLM_DELIVERY_EVENT_CODE CLM_DELIVERY_EVENT_CODE, CLM_DELIVERY_PERIOD CLM_DELIVERY_PERIOD, CLM_DELIVERY_PERIOD_UOM CLM_DELIVERY_PERIOD_UOM, CLM_EXHIBIT_NAME CLM_EXHIBIT_NAME, CLM_PAYMENT_INSTR_CODE CLM_PAYMENT_INSTR_CODE, CLM_POP_DURATION CLM_POP_DURATION, CLM_POP_DURATION_UOM CLM_POP_DURATION_UOM, CLM_POP_EXCEPTION_REASON CLM_POP_EXCEPTION_REASON, CLM_PROMISE_PERIOD CLM_PROMISE_PERIOD, CLM_PROMISE_PERIOD_UOM CLM_PROMISE_PERIOD_UOM, 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_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_LINE_ID INTERFACE_LINE_ID
, INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, ACTION ACTION
, GROUP_CODE GROUP_CODE
, LINE_NUM LINE_NUM
, PO_LINE_ID PO_LINE_ID
, SHIPMENT_NUM SHIPMENT_NUM
, LINE_LOCATION_ID LINE_LOCATION_ID
, SHIPMENT_TYPE SHIPMENT_TYPE
, REQUISITION_LINE_ID REQUISITION_LINE_ID
, DOCUMENT_NUM DOCUMENT_NUM
, RELEASE_NUM RELEASE_NUM
, PO_HEADER_ID PO_HEADER_ID
, PO_RELEASE_ID PO_RELEASE_ID
, SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID
, CONTRACT_NUM CONTRACT_NUM
, LINE_TYPE LINE_TYPE
, LINE_TYPE_ID LINE_TYPE_ID
, ITEM ITEM
, ITEM_ID ITEM_ID
, ITEM_REVISION ITEM_REVISION
, CATEGORY CATEGORY
, CATEGORY_ID CATEGORY_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, VENDOR_PRODUCT_NUM VENDOR_PRODUCT_NUM
, UOM_CODE UOM_CODE
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, QUANTITY QUANTITY
, COMMITTED_AMOUNT COMMITTED_AMOUNT
, MIN_ORDER_QUANTITY MIN_ORDER_QUANTITY
, MAX_ORDER_QUANTITY MAX_ORDER_QUANTITY
, UNIT_PRICE UNIT_PRICE
, LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT
, MARKET_PRICE MARKET_PRICE
, ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG
, NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE
, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG
, UN_NUMBER UN_NUMBER
, UN_NUMBER_ID UN_NUMBER_ID
, HAZARD_CLASS HAZARD_CLASS
, HAZARD_CLASS_ID HAZARD_CLASS_ID
, NOTE_TO_VENDOR NOTE_TO_VENDOR
, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE
, TAXABLE_FLAG TAXABLE_FLAG
, TAX_NAME TAX_NAME
, TYPE_1099 TYPE_1099
, CAPITAL_EXPENSE_FLAG CAPITAL_EXPENSE_FLAG
, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG
, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG
, PAYMENT_TERMS PAYMENT_TERMS
, TERMS_ID TERMS_ID
, PRICE_TYPE PRICE_TYPE
, MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT
, PRICE_BREAK_LOOKUP_CODE PRICE_BREAK_LOOKUP_CODE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, CLOSED_CODE CLOSED_CODE
, CLOSED_REASON CLOSED_REASON
, CLOSED_DATE CLOSED_DATE
, CLOSED_BY CLOSED_BY
, INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE
, RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE
, FIRM_FLAG FIRM_FLAG
, DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED
, DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED
, ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE
, ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, RECEIVING_ROUTING RECEIVING_ROUTING
, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID
, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE
, OVER_TOLERANCE_ERROR_FLAG OVER_TOLERANCE_ERROR_FLAG
, QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE
, RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE
, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE
, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, SHIP_TO_LOCATION SHIP_TO_LOCATION
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, NEED_BY_DATE NEED_BY_DATE
, PROMISED_DATE PROMISED_DATE
, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG
, LEAD_TIME LEAD_TIME
, LEAD_TIME_UNIT LEAD_TIME_UNIT
, PRICE_DISCOUNT PRICE_DISCOUNT
, FREIGHT_CARRIER FREIGHT_CARRIER
, FOB FOB
, FREIGHT_TERMS FREIGHT_TERMS
, EFFECTIVE_DATE EFFECTIVE_DATE
, EXPIRATION_DATE EXPIRATION_DATE
, FROM_HEADER_ID FROM_HEADER_ID
, FROM_LINE_ID FROM_LINE_ID
, FROM_LINE_LOCATION_ID FROM_LINE_LOCATION_ID
, LINE_ATTRIBUTE_CATEGORY_LINES LINE_ATTRIBUTE_CATEGORY_LINES
, 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
, SHIPMENT_ATTRIBUTE_CATEGORY SHIPMENT_ATTRIBUTE_CATEGORY
, SHIPMENT_ATTRIBUTE1 SHIPMENT_ATTRIBUTE1
, SHIPMENT_ATTRIBUTE2 SHIPMENT_ATTRIBUTE2
, SHIPMENT_ATTRIBUTE3 SHIPMENT_ATTRIBUTE3
, SHIPMENT_ATTRIBUTE4 SHIPMENT_ATTRIBUTE4
, SHIPMENT_ATTRIBUTE5 SHIPMENT_ATTRIBUTE5
, SHIPMENT_ATTRIBUTE6 SHIPMENT_ATTRIBUTE6
, SHIPMENT_ATTRIBUTE7 SHIPMENT_ATTRIBUTE7
, SHIPMENT_ATTRIBUTE8 SHIPMENT_ATTRIBUTE8
, SHIPMENT_ATTRIBUTE9 SHIPMENT_ATTRIBUTE9
, SHIPMENT_ATTRIBUTE10 SHIPMENT_ATTRIBUTE10
, SHIPMENT_ATTRIBUTE11 SHIPMENT_ATTRIBUTE11
, SHIPMENT_ATTRIBUTE12 SHIPMENT_ATTRIBUTE12
, SHIPMENT_ATTRIBUTE13 SHIPMENT_ATTRIBUTE13
, SHIPMENT_ATTRIBUTE14 SHIPMENT_ATTRIBUTE14
, SHIPMENT_ATTRIBUTE15 SHIPMENT_ATTRIBUTE15
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORGANIZATION_ID ORGANIZATION_ID
, ITEM_ATTRIBUTE_CATEGORY ITEM_ATTRIBUTE_CATEGORY
, ITEM_ATTRIBUTE1 ITEM_ATTRIBUTE1
, ITEM_ATTRIBUTE2 ITEM_ATTRIBUTE2
, ITEM_ATTRIBUTE3 ITEM_ATTRIBUTE3
, ITEM_ATTRIBUTE4 ITEM_ATTRIBUTE4
, ITEM_ATTRIBUTE5 ITEM_ATTRIBUTE5
, ITEM_ATTRIBUTE6 ITEM_ATTRIBUTE6
, ITEM_ATTRIBUTE7 ITEM_ATTRIBUTE7
, ITEM_ATTRIBUTE8 ITEM_ATTRIBUTE8
, ITEM_ATTRIBUTE9 ITEM_ATTRIBUTE9
, ITEM_ATTRIBUTE10 ITEM_ATTRIBUTE10
, ITEM_ATTRIBUTE11 ITEM_ATTRIBUTE11
, ITEM_ATTRIBUTE12 ITEM_ATTRIBUTE12
, ITEM_ATTRIBUTE13 ITEM_ATTRIBUTE13
, ITEM_ATTRIBUTE14 ITEM_ATTRIBUTE14
, ITEM_ATTRIBUTE15 ITEM_ATTRIBUTE15
, UNIT_WEIGHT UNIT_WEIGHT
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, UNIT_VOLUME UNIT_VOLUME
, TEMPLATE_ID TEMPLATE_ID
, TEMPLATE_NAME TEMPLATE_NAME
, LINE_REFERENCE_NUM LINE_REFERENCE_NUM
, SOURCING_RULE_NAME SOURCING_RULE_NAME
, TAX_STATUS_INDICATOR TAX_STATUS_INDICATOR
, PROCESS_CODE PROCESS_CODE
, PRICE_CHG_ACCEPT_FLAG PRICE_CHG_ACCEPT_FLAG
, PRICE_BREAK_FLAG PRICE_BREAK_FLAG
, PRICE_UPDATE_TOLERANCE PRICE_UPDATE_TOLERANCE
, TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG
, TAX_CODE_ID TAX_CODE_ID
, NOTE_TO_RECEIVER NOTE_TO_RECEIVER
, OKE_CONTRACT_HEADER_ID OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_HEADER_NUM OKE_CONTRACT_HEADER_NUM
, OKE_CONTRACT_VERSION_ID OKE_CONTRACT_VERSION_ID
, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE
, SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, PREFERRED_GRADE PREFERRED_GRADE
, VMI_FLAG VMI_FLAG
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER
, AUCTION_DISPLAY_NUMBER AUCTION_DISPLAY_NUMBER
, BID_NUMBER BID_NUMBER
, BID_LINE_NUMBER BID_LINE_NUMBER
, ORIG_FROM_REQ_FLAG ORIG_FROM_REQ_FLAG
, CONSIGNED_FLAG CONSIGNED_FLAG
, SUPPLIER_REF_NUMBER SUPPLIER_REF_NUMBER
, CONTRACT_ID CONTRACT_ID
, JOB_ID JOB_ID
, AMOUNT AMOUNT
, JOB_NAME JOB_NAME
, CONTRACTOR_FIRST_NAME CONTRACTOR_FIRST_NAME
, CONTRACTOR_LAST_NAME CONTRACTOR_LAST_NAME
, DROP_SHIP_FLAG DROP_SHIP_FLAG
, BASE_UNIT_PRICE BASE_UNIT_PRICE
, TRANSACTION_FLOW_HEADER_ID TRANSACTION_FLOW_HEADER_ID
, JOB_BUSINESS_GROUP_ID JOB_BUSINESS_GROUP_ID
, JOB_BUSINESS_GROUP_NAME JOB_BUSINESS_GROUP_NAME
, CATALOG_NAME CATALOG_NAME
, SUPPLIER_PART_AUXID SUPPLIER_PART_AUXID
, IP_CATEGORY_ID IP_CATEGORY_ID
, TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND
, SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND
, DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH
, DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW
, PROCESSING_ID PROCESSING_ID
, LINE_LOC_POPULATED_FLAG LINE_LOC_POPULATED_FLAG
, IP_CATEGORY_NAME IP_CATEGORY_NAME
, RETAINAGE_RATE RETAINAGE_RATE
, MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT
, PROGRESS_PAYMENT_RATE PROGRESS_PAYMENT_RATE
, RECOUPMENT_RATE RECOUPMENT_RATE
, ADVANCE_AMOUNT ADVANCE_AMOUNT
, FILE_LINE_NUMBER FILE_LINE_NUMBER
, PARENT_INTERFACE_LINE_ID PARENT_INTERFACE_LINE_ID
, FILE_LINE_LANGUAGE FILE_LINE_LANGUAGE
, 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_MIN_TOTAL_AMOUNT CLM_MIN_TOTAL_AMOUNT
, CLM_MAX_TOTAL_AMOUNT CLM_MAX_TOTAL_AMOUNT
, CLM_MIN_TOTAL_QUANTITY CLM_MIN_TOTAL_QUANTITY
, CLM_MAX_TOTAL_QUANTITY CLM_MAX_TOTAL_QUANTITY
, CLM_MIN_ORDER_AMOUNT CLM_MIN_ORDER_AMOUNT
, CLM_MAX_ORDER_AMOUNT CLM_MAX_ORDER_AMOUNT
, CLM_MIN_ORDER_QUANTITY CLM_MIN_ORDER_QUANTITY
, CLM_MAX_ORDER_QUANTITY CLM_MAX_ORDER_QUANTITY
, CLM_TOTAL_AMOUNT_ORDERED CLM_TOTAL_AMOUNT_ORDERED
, CLM_TOTAL_QUANTITY_ORDERED CLM_TOTAL_QUANTITY_ORDERED
, CLM_PERIOD_PERF_END_DATE CLM_PERIOD_PERF_END_DATE
, CLM_PERIOD_PERF_START_DATE CLM_PERIOD_PERF_START_DATE
, CONTRACT_TYPE_DISPLAY CONTRACT_TYPE_DISPLAY
, COST_CONSTRAINT_DISPLAY COST_CONSTRAINT_DISPLAY
, CLM_IDC_TYPE_DISPLAY CLM_IDC_TYPE_DISPLAY
, CLM_BASE_LINE_NUM_DISP CLM_BASE_LINE_NUM_DISP
, FROM_HEADER_DISP FROM_HEADER_DISP
, FROM_LINE_DISP FROM_LINE_DISP
, CLM_APPROVED_UNDEF_AMOUNT CLM_APPROVED_UNDEF_AMOUNT
, CLM_DELIVERY_EVENT_CODE CLM_DELIVERY_EVENT_CODE
, CLM_DELIVERY_PERIOD CLM_DELIVERY_PERIOD
, CLM_DELIVERY_PERIOD_UOM CLM_DELIVERY_PERIOD_UOM
, CLM_EXHIBIT_NAME CLM_EXHIBIT_NAME
, CLM_PAYMENT_INSTR_CODE CLM_PAYMENT_INSTR_CODE
, CLM_POP_DURATION CLM_POP_DURATION
, CLM_POP_DURATION_UOM CLM_POP_DURATION_UOM
, CLM_POP_EXCEPTION_REASON CLM_POP_EXCEPTION_REASON
, CLM_PROMISE_PERIOD CLM_PROMISE_PERIOD
, CLM_PROMISE_PERIOD_UOM CLM_PROMISE_PERIOD_UOM
, 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_INTERFACE"