DBA Data[Home] [Help]

VIEW: CSP.CSP_REPAIR_PO_HEADERS#

Source

View Text - Preformatted

select REPAIR_PO_HEADER_ID REPAIR_PO_HEADER_ID, REQUISITION_HEADER_ID REQUISITION_HEADER_ID, PURCHASE_ORDER_HEADER_ID PURCHASE_ORDER_HEADER_ID, INTERNAL_ORDER_HEADER_ID INTERNAL_ORDER_HEADER_ID, WIP_ID WIP_ID, STATUS STATUS, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, QUANTITY QUANTITY, DEST_ORGANIZATION_ID DEST_ORGANIZATION_ID, NEED_BY_DATE NEED_BY_DATE, REQUISITION_NUMBER REQUISITION_NUMBER, REQUISITION_LINE_ID REQUISITION_LINE_ID, ORDER_LINE_ID ORDER_LINE_ID, LINE_NUM LINE_NUM, POREQ_LINE_RESERVATION_ID POREQ_LINE_RESERVATION_ID, POREQ_LINE_ID POREQ_LINE_ID, ERROR_MESSAGE ERROR_MESSAGE, REPAIR_PROGRAM REPAIR_PROGRAM, PO_NUMBER PO_NUMBER, REPAIR_SUPPLIER_ID REPAIR_SUPPLIER_ID, REPAIR_SUPPLIER_ORG_ID REPAIR_SUPPLIER_ORG_ID, RECEIVED_QTY RECEIVED_QTY from "CSP"."CSP_REPAIR_PO_HEADERS"
View Text - HTML Formatted

SELECT REPAIR_PO_HEADER_ID REPAIR_PO_HEADER_ID
, REQUISITION_HEADER_ID REQUISITION_HEADER_ID
, PURCHASE_ORDER_HEADER_ID PURCHASE_ORDER_HEADER_ID
, INTERNAL_ORDER_HEADER_ID INTERNAL_ORDER_HEADER_ID
, WIP_ID WIP_ID
, STATUS STATUS
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, QUANTITY QUANTITY
, DEST_ORGANIZATION_ID DEST_ORGANIZATION_ID
, NEED_BY_DATE NEED_BY_DATE
, REQUISITION_NUMBER REQUISITION_NUMBER
, REQUISITION_LINE_ID REQUISITION_LINE_ID
, ORDER_LINE_ID ORDER_LINE_ID
, LINE_NUM LINE_NUM
, POREQ_LINE_RESERVATION_ID POREQ_LINE_RESERVATION_ID
, POREQ_LINE_ID POREQ_LINE_ID
, ERROR_MESSAGE ERROR_MESSAGE
, REPAIR_PROGRAM REPAIR_PROGRAM
, PO_NUMBER PO_NUMBER
, REPAIR_SUPPLIER_ID REPAIR_SUPPLIER_ID
, REPAIR_SUPPLIER_ORG_ID REPAIR_SUPPLIER_ORG_ID
, RECEIVED_QTY RECEIVED_QTY
FROM "CSP"."CSP_REPAIR_PO_HEADERS"