[Home] [Help]
| Product: | OKX - Contracts Integration |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT REQUISITION_LINE_ID ID1
, '#' ID2
, NULL NAME
, 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
, SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, ITEM_ID ITEM_ID
, ITEM_REVISION ITEM_REVISION
, NEED_BY_DATE NEED_BY_DATE
, LINE_LOCATION_ID LINE_LOCATION_ID
, PARENT_REQ_LINE_ID PARENT_REQ_LINE_ID
, JUSTIFICATION JUSTIFICATION
, NOTE_TO_AGENT NOTE_TO_AGENT
, NOTE_TO_RECEIVER NOTE_TO_RECEIVER
, DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE
, CURRENCY_CODE CURRENCY_CODE
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, RATE RATE
, CURRENCY_UNIT_PRICE CURRENCY_UNIT_PRICE
, PURCHASING_AGENT_ID PURCHASING_AGENT_ID
, SUGGESTED_BUYER_ID SUGGESTED_BUYER_ID
, 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
, 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_FLAG CANCEL_FLAG
, 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
, DESTINATION_CONTEXT DESTINATION_CONTEXT
, INVENTORY_SOURCE_CONTEXT INVENTORY_SOURCE_CONTEXT
, VENDOR_SOURCE_CONTEXT VENDOR_SOURCE_CONTEXT
, BOM_RESOURCE_ID BOM_RESOURCE_ID
, 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
, 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
, NOTE_TO_VENDOR NOTE_TO_VENDOR
, 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
FROM PO_REQUISITION_LINES_ALL