eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: PO.PO_REQUISITION_LINES_ALL#

Source

View Text - Preformatted


select REQUISITION_LINE_ID REQUISITION_LINE_ID, REQUISITION_HEADER_ID REQUISITION_HEADER_ID, LINE_NUM LINE_NUM, LINE_TYPE_ID LINE_TYPE_ID, CATEGORY_ID CATEGORY_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE, UNIT_PRICE UNIT_PRICE, QUANTITY QUANTITY, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, TO_PERSON_ID TO_PERSON_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, SOURCE_TYPE_CODE SOURCE_TYPE_CODE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ITEM_ID ITEM_ID, ITEM_REVISION ITEM_REVISION, QUANTITY_DELIVERED QUANTITY_DELIVERED, SUGGESTED_BUYER_ID SUGGESTED_BUYER_ID, ENCUMBERED_FLAG ENCUMBERED_FLAG, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG, NEED_BY_DATE NEED_BY_DATE, LINE_LOCATION_ID LINE_LOCATION_ID, MODIFIED_BY_AGENT_FLAG MODIFIED_BY_AGENT_FLAG, PARENT_REQ_LINE_ID PARENT_REQ_LINE_ID, JUSTIFICATION JUSTIFICATION, NOTE_TO_AGENT NOTE_TO_AGENT, NOTE_TO_RECEIVER NOTE_TO_RECEIVER, PURCHASING_AGENT_ID PURCHASING_AGENT_ID, DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE, BLANKET_PO_HEADER_ID BLANKET_PO_HEADER_ID, BLANKET_PO_LINE_NUM BLANKET_PO_LINE_NUM, CURRENCY_CODE CURRENCY_CODE, RATE_TYPE RATE_TYPE, RATE_DATE RATE_DATE, RATE RATE, CURRENCY_UNIT_PRICE CURRENCY_UNIT_PRICE, SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_LOCATION SUGGESTED_VENDOR_LOCATION, SUGGESTED_VENDOR_CONTACT SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE SUGGESTED_VENDOR_PHONE, SUGGESTED_VENDOR_PRODUCT_CODE SUGGESTED_VENDOR_PRODUCT_CODE, UN_NUMBER_ID UN_NUMBER_ID, HAZARD_CLASS_ID HAZARD_CLASS_ID, MUST_USE_SUGG_VENDOR_FLAG MUST_USE_SUGG_VENDOR_FLAG, REFERENCE_NUM REFERENCE_NUM, ON_RFQ_FLAG ON_RFQ_FLAG, URGENT_FLAG URGENT_FLAG, CANCEL_FLAG CANCEL_FLAG, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY, QUANTITY_CANCELLED QUANTITY_CANCELLED, CANCEL_DATE CANCEL_DATE, CANCEL_REASON CANCEL_REASON, CLOSED_CODE CLOSED_CODE, AGENT_RETURN_NOTE AGENT_RETURN_NOTE, CHANGED_AFTER_RESEARCH_FLAG CHANGED_AFTER_RESEARCH_FLAG, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_CONTACT_ID VENDOR_CONTACT_ID, RESEARCH_AGENT_ID RESEARCH_AGENT_ID, ON_LINE_FLAG ON_LINE_FLAG, WIP_ENTITY_ID WIP_ENTITY_ID, WIP_LINE_ID WIP_LINE_ID, WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID, WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, DESTINATION_CONTEXT DESTINATION_CONTEXT, INVENTORY_SOURCE_CONTEXT INVENTORY_SOURCE_CONTEXT, VENDOR_SOURCE_CONTEXT VENDOR_SOURCE_CONTEXT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, BOM_RESOURCE_ID BOM_RESOURCE_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, CLOSED_REASON CLOSED_REASON, CLOSED_DATE CLOSED_DATE, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE, QUANTITY_RECEIVED QUANTITY_RECEIVED, SOURCE_REQ_LINE_ID SOURCE_REQ_LINE_ID, ORG_ID ORG_ID, 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, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, KANBAN_CARD_ID KANBAN_CARD_ID, CATALOG_TYPE CATALOG_TYPE, CATALOG_SOURCE CATALOG_SOURCE, MANUFACTURER_ID MANUFACTURER_ID, MANUFACTURER_NAME MANUFACTURER_NAME, MANUFACTURER_PART_NUMBER MANUFACTURER_PART_NUMBER, REQUESTER_EMAIL REQUESTER_EMAIL, REQUESTER_FAX REQUESTER_FAX, REQUESTER_PHONE REQUESTER_PHONE, UNSPSC_CODE UNSPSC_CODE, OTHER_CATEGORY_CODE OTHER_CATEGORY_CODE, SUPPLIER_DUNS SUPPLIER_DUNS, TAX_STATUS_INDICATOR TAX_STATUS_INDICATOR, PCARD_FLAG PCARD_FLAG, NEW_SUPPLIER_FLAG NEW_SUPPLIER_FLAG, AUTO_RECEIVE_FLAG AUTO_RECEIVE_FLAG, TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG, TAX_CODE_ID TAX_CODE_ID, NOTE_TO_VENDOR NOTE_TO_VENDOR, OKE_CONTRACT_VERSION_ID OKE_CONTRACT_VERSION_ID, OKE_CONTRACT_HEADER_ID OKE_CONTRACT_HEADER_ID, ITEM_SOURCE_ID ITEM_SOURCE_ID, SUPPLIER_REF_NUMBER SUPPLIER_REF_NUMBER, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE, SECONDARY_QUANTITY SECONDARY_QUANTITY, PREFERRED_GRADE PREFERRED_GRADE, SECONDARY_QUANTITY_RECEIVED SECONDARY_QUANTITY_RECEIVED, SECONDARY_QUANTITY_CANCELLED SECONDARY_QUANTITY_CANCELLED, VMI_FLAG VMI_FLAG, AUCTION_HEADER_ID AUCTION_HEADER_ID, AUCTION_DISPLAY_NUMBER AUCTION_DISPLAY_NUMBER, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER, REQS_IN_POOL_FLAG REQS_IN_POOL_FLAG, BID_NUMBER BID_NUMBER, BID_LINE_NUMBER BID_LINE_NUMBER, NONCAT_TEMPLATE_ID NONCAT_TEMPLATE_ID, SUGGESTED_VENDOR_CONTACT_FAX SUGGESTED_VENDOR_CONTACT_FAX, SUGGESTED_VENDOR_CONTACT_EMAIL SUGGESTED_VENDOR_CONTACT_EMAIL, AMOUNT AMOUNT, CURRENCY_AMOUNT CURRENCY_AMOUNT, LABOR_REQ_LINE_ID LABOR_REQ_LINE_ID, JOB_ID JOB_ID, JOB_LONG_DESCRIPTION JOB_LONG_DESCRIPTION, CONTRACTOR_STATUS CONTRACTOR_STATUS, CONTACT_INFORMATION CONTACT_INFORMATION, SUGGESTED_SUPPLIER_FLAG SUGGESTED_SUPPLIER_FLAG, CANDIDATE_SCREENING_REQD_FLAG CANDIDATE_SCREENING_REQD_FLAG, CANDIDATE_FIRST_NAME CANDIDATE_FIRST_NAME, CANDIDATE_LAST_NAME CANDIDATE_LAST_NAME, ASSIGNMENT_END_DATE ASSIGNMENT_END_DATE, OVERTIME_ALLOWED_FLAG OVERTIME_ALLOWED_FLAG, CONTRACTOR_REQUISITION_FLAG CONTRACTOR_REQUISITION_FLAG, DROP_SHIP_FLAG DROP_SHIP_FLAG, ASSIGNMENT_START_DATE ASSIGNMENT_START_DATE, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS PURCHASE_BASIS, MATCHING_BASIS MATCHING_BASIS, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG, SHIP_METHOD SHIP_METHOD, ESTIMATED_PICKUP_DATE ESTIMATED_PICKUP_DATE, SUPPLIER_NOTIFIED_FOR_CANCEL SUPPLIER_NOTIFIED_FOR_CANCEL, BASE_UNIT_PRICE BASE_UNIT_PRICE, AT_SOURCING_FLAG AT_SOURCING_FLAG, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE, TAX_NAME TAX_NAME, TRANSFERRED_TO_OE_FLAG TRANSFERRED_TO_OE_FLAG, CONFORMED_LINE_ID CONFORMED_LINE_ID, AMENDMENT_TYPE AMENDMENT_TYPE, AMENDMENT_STATUS AMENDMENT_STATUS, LINE_NUM_DISPLAY LINE_NUM_DISPLAY, GROUP_LINE_ID GROUP_LINE_ID, 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, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, CONTRACT_TYPE CONTRACT_TYPE, COST_CONSTRAINT COST_CONSTRAINT, AMENDMENT_RESPONSE_REASON AMENDMENT_RESPONSE_REASON, CLM_PERIOD_PERF_START_DATE CLM_PERIOD_PERF_START_DATE, CLM_PERIOD_PERF_END_DATE CLM_PERIOD_PERF_END_DATE, CLM_EXTENDED_ITEM_DESCRIPTION CLM_EXTENDED_ITEM_DESCRIPTION, CLM_OPTION_EXERCISED CLM_OPTION_EXERCISED, IS_LINE_NUM_DISPLAY_MODIFIED IS_LINE_NUM_DISPLAY_MODIFIED, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER, PO_DRAFT_ID PO_DRAFT_ID, PO_LINE_ID PO_LINE_ID, CLM_EXERCISED_DATE CLM_EXERCISED_DATE, LINKED_TO_FUND LINKED_TO_FUND, FUND_SOURCE_NOT_KNOWN FUND_SOURCE_NOT_KNOWN, LINKED_PO_COUNT LINKED_PO_COUNT, CLM_MIPR_OBLIGATION_TYPE CLM_MIPR_OBLIGATION_TYPE, PAR_DRAFT_ID PAR_DRAFT_ID, PAR_LINE_ID PAR_LINE_ID from "PO"."PO_REQUISITION_LINES_ALL"

View Text - HTML Formatted

SELECT REQUISITION_LINE_ID REQUISITION_LINE_ID
, REQUISITION_HEADER_ID REQUISITION_HEADER_ID
, LINE_NUM LINE_NUM
, LINE_TYPE_ID LINE_TYPE_ID
, CATEGORY_ID CATEGORY_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE
, UNIT_PRICE UNIT_PRICE
, QUANTITY QUANTITY
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, TO_PERSON_ID TO_PERSON_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ITEM_ID ITEM_ID
, ITEM_REVISION ITEM_REVISION
, QUANTITY_DELIVERED QUANTITY_DELIVERED
, SUGGESTED_BUYER_ID SUGGESTED_BUYER_ID
, ENCUMBERED_FLAG ENCUMBERED_FLAG
, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG
, NEED_BY_DATE NEED_BY_DATE
, LINE_LOCATION_ID LINE_LOCATION_ID
, MODIFIED_BY_AGENT_FLAG MODIFIED_BY_AGENT_FLAG
, PARENT_REQ_LINE_ID PARENT_REQ_LINE_ID
, JUSTIFICATION JUSTIFICATION
, NOTE_TO_AGENT NOTE_TO_AGENT
, NOTE_TO_RECEIVER NOTE_TO_RECEIVER
, PURCHASING_AGENT_ID PURCHASING_AGENT_ID
, DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE
, BLANKET_PO_HEADER_ID BLANKET_PO_HEADER_ID
, BLANKET_PO_LINE_NUM BLANKET_PO_LINE_NUM
, CURRENCY_CODE CURRENCY_CODE
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, RATE RATE
, CURRENCY_UNIT_PRICE CURRENCY_UNIT_PRICE
, SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_LOCATION SUGGESTED_VENDOR_LOCATION
, SUGGESTED_VENDOR_CONTACT SUGGESTED_VENDOR_CONTACT
, SUGGESTED_VENDOR_PHONE SUGGESTED_VENDOR_PHONE
, SUGGESTED_VENDOR_PRODUCT_CODE SUGGESTED_VENDOR_PRODUCT_CODE
, UN_NUMBER_ID UN_NUMBER_ID
, HAZARD_CLASS_ID HAZARD_CLASS_ID
, MUST_USE_SUGG_VENDOR_FLAG MUST_USE_SUGG_VENDOR_FLAG
, REFERENCE_NUM REFERENCE_NUM
, ON_RFQ_FLAG ON_RFQ_FLAG
, URGENT_FLAG URGENT_FLAG
, CANCEL_FLAG CANCEL_FLAG
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY
, QUANTITY_CANCELLED QUANTITY_CANCELLED
, CANCEL_DATE CANCEL_DATE
, CANCEL_REASON CANCEL_REASON
, CLOSED_CODE CLOSED_CODE
, AGENT_RETURN_NOTE AGENT_RETURN_NOTE
, CHANGED_AFTER_RESEARCH_FLAG CHANGED_AFTER_RESEARCH_FLAG
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, RESEARCH_AGENT_ID RESEARCH_AGENT_ID
, ON_LINE_FLAG ON_LINE_FLAG
, WIP_ENTITY_ID WIP_ENTITY_ID
, WIP_LINE_ID WIP_LINE_ID
, WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID
, WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, DESTINATION_CONTEXT DESTINATION_CONTEXT
, INVENTORY_SOURCE_CONTEXT INVENTORY_SOURCE_CONTEXT
, VENDOR_SOURCE_CONTEXT VENDOR_SOURCE_CONTEXT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, BOM_RESOURCE_ID BOM_RESOURCE_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, CLOSED_REASON CLOSED_REASON
, CLOSED_DATE CLOSED_DATE
, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE
, QUANTITY_RECEIVED QUANTITY_RECEIVED
, SOURCE_REQ_LINE_ID SOURCE_REQ_LINE_ID
, ORG_ID ORG_ID
, 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
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, KANBAN_CARD_ID KANBAN_CARD_ID
, CATALOG_TYPE CATALOG_TYPE
, CATALOG_SOURCE CATALOG_SOURCE
, MANUFACTURER_ID MANUFACTURER_ID
, MANUFACTURER_NAME MANUFACTURER_NAME
, MANUFACTURER_PART_NUMBER MANUFACTURER_PART_NUMBER
, REQUESTER_EMAIL REQUESTER_EMAIL
, REQUESTER_FAX REQUESTER_FAX
, REQUESTER_PHONE REQUESTER_PHONE
, UNSPSC_CODE UNSPSC_CODE
, OTHER_CATEGORY_CODE OTHER_CATEGORY_CODE
, SUPPLIER_DUNS SUPPLIER_DUNS
, TAX_STATUS_INDICATOR TAX_STATUS_INDICATOR
, PCARD_FLAG PCARD_FLAG
, NEW_SUPPLIER_FLAG NEW_SUPPLIER_FLAG
, AUTO_RECEIVE_FLAG AUTO_RECEIVE_FLAG
, TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG
, TAX_CODE_ID TAX_CODE_ID
, NOTE_TO_VENDOR NOTE_TO_VENDOR
, OKE_CONTRACT_VERSION_ID OKE_CONTRACT_VERSION_ID
, OKE_CONTRACT_HEADER_ID OKE_CONTRACT_HEADER_ID
, ITEM_SOURCE_ID ITEM_SOURCE_ID
, SUPPLIER_REF_NUMBER SUPPLIER_REF_NUMBER
, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, PREFERRED_GRADE PREFERRED_GRADE
, SECONDARY_QUANTITY_RECEIVED SECONDARY_QUANTITY_RECEIVED
, SECONDARY_QUANTITY_CANCELLED SECONDARY_QUANTITY_CANCELLED
, VMI_FLAG VMI_FLAG
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, AUCTION_DISPLAY_NUMBER AUCTION_DISPLAY_NUMBER
, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER
, REQS_IN_POOL_FLAG REQS_IN_POOL_FLAG
, BID_NUMBER BID_NUMBER
, BID_LINE_NUMBER BID_LINE_NUMBER
, NONCAT_TEMPLATE_ID NONCAT_TEMPLATE_ID
, SUGGESTED_VENDOR_CONTACT_FAX SUGGESTED_VENDOR_CONTACT_FAX
, SUGGESTED_VENDOR_CONTACT_EMAIL SUGGESTED_VENDOR_CONTACT_EMAIL
, AMOUNT AMOUNT
, CURRENCY_AMOUNT CURRENCY_AMOUNT
, LABOR_REQ_LINE_ID LABOR_REQ_LINE_ID
, JOB_ID JOB_ID
, JOB_LONG_DESCRIPTION JOB_LONG_DESCRIPTION
, CONTRACTOR_STATUS CONTRACTOR_STATUS
, CONTACT_INFORMATION CONTACT_INFORMATION
, SUGGESTED_SUPPLIER_FLAG SUGGESTED_SUPPLIER_FLAG
, CANDIDATE_SCREENING_REQD_FLAG CANDIDATE_SCREENING_REQD_FLAG
, CANDIDATE_FIRST_NAME CANDIDATE_FIRST_NAME
, CANDIDATE_LAST_NAME CANDIDATE_LAST_NAME
, ASSIGNMENT_END_DATE ASSIGNMENT_END_DATE
, OVERTIME_ALLOWED_FLAG OVERTIME_ALLOWED_FLAG
, CONTRACTOR_REQUISITION_FLAG CONTRACTOR_REQUISITION_FLAG
, DROP_SHIP_FLAG DROP_SHIP_FLAG
, ASSIGNMENT_START_DATE ASSIGNMENT_START_DATE
, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE
, PURCHASE_BASIS PURCHASE_BASIS
, MATCHING_BASIS MATCHING_BASIS
, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG
, SHIP_METHOD SHIP_METHOD
, ESTIMATED_PICKUP_DATE ESTIMATED_PICKUP_DATE
, SUPPLIER_NOTIFIED_FOR_CANCEL SUPPLIER_NOTIFIED_FOR_CANCEL
, BASE_UNIT_PRICE BASE_UNIT_PRICE
, AT_SOURCING_FLAG AT_SOURCING_FLAG
, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE
, TAX_NAME TAX_NAME
, TRANSFERRED_TO_OE_FLAG TRANSFERRED_TO_OE_FLAG
, CONFORMED_LINE_ID CONFORMED_LINE_ID
, AMENDMENT_TYPE AMENDMENT_TYPE
, AMENDMENT_STATUS AMENDMENT_STATUS
, LINE_NUM_DISPLAY LINE_NUM_DISPLAY
, GROUP_LINE_ID GROUP_LINE_ID
, 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
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, CONTRACT_TYPE CONTRACT_TYPE
, COST_CONSTRAINT COST_CONSTRAINT
, AMENDMENT_RESPONSE_REASON AMENDMENT_RESPONSE_REASON
, CLM_PERIOD_PERF_START_DATE CLM_PERIOD_PERF_START_DATE
, CLM_PERIOD_PERF_END_DATE CLM_PERIOD_PERF_END_DATE
, CLM_EXTENDED_ITEM_DESCRIPTION CLM_EXTENDED_ITEM_DESCRIPTION
, CLM_OPTION_EXERCISED CLM_OPTION_EXERCISED
, IS_LINE_NUM_DISPLAY_MODIFIED IS_LINE_NUM_DISPLAY_MODIFIED
, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PO_DRAFT_ID PO_DRAFT_ID
, PO_LINE_ID PO_LINE_ID
, CLM_EXERCISED_DATE CLM_EXERCISED_DATE
, LINKED_TO_FUND LINKED_TO_FUND
, FUND_SOURCE_NOT_KNOWN FUND_SOURCE_NOT_KNOWN
, LINKED_PO_COUNT LINKED_PO_COUNT
, CLM_MIPR_OBLIGATION_TYPE CLM_MIPR_OBLIGATION_TYPE
, PAR_DRAFT_ID PAR_DRAFT_ID
, PAR_LINE_ID PAR_LINE_ID
FROM "PO"."PO_REQUISITION_LINES_ALL"