VIEW: MRP.MRP_ITEM_PURCHASE_ORDERS#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, PURCHASE_ORDER_ID PURCHASE_ORDER_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, ORDER_TYPE ORDER_TYPE, DELIVERY_SCHEDULE_DATE DELIVERY_SCHEDULE_DATE, PO_NUMBER PO_NUMBER, DELIVERY_BALANCE DELIVERY_BALANCE, EXPECTED_SCRAP_QUANTITY EXPECTED_SCRAP_QUANTITY, UOM_CODE UOM_CODE, PO_UOM_DELIVERY_BALANCE PO_UOM_DELIVERY_BALANCE, DELIVERY_PRICE DELIVERY_PRICE, DELIVERY_STATUS_TYPE DELIVERY_STATUS_TYPE, PURCH_LINE_NUM PURCH_LINE_NUM, LINE_ID LINE_ID, FIRM_PLANNED_STATUS_TYPE FIRM_PLANNED_STATUS_TYPE, DELIVERY_NEED_DATE DELIVERY_NEED_DATE, REVISION REVISION, PRINT_DATE PRINT_DATE, RECEIVING_DOCUMENT_DESIGNATOR RECEIVING_DOCUMENT_DESIGNATOR, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, DEMAND_CLASS DEMAND_CLASS, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PLANNING_GROUP PLANNING_GROUP, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER from "MRP"."MRP_ITEM_PURCHASE_ORDERS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, PURCHASE_ORDER_ID PURCHASE_ORDER_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, ORDER_TYPE ORDER_TYPE
, DELIVERY_SCHEDULE_DATE DELIVERY_SCHEDULE_DATE
, PO_NUMBER PO_NUMBER
, DELIVERY_BALANCE DELIVERY_BALANCE
, EXPECTED_SCRAP_QUANTITY EXPECTED_SCRAP_QUANTITY
, UOM_CODE UOM_CODE
, PO_UOM_DELIVERY_BALANCE PO_UOM_DELIVERY_BALANCE
, DELIVERY_PRICE DELIVERY_PRICE
, DELIVERY_STATUS_TYPE DELIVERY_STATUS_TYPE
, PURCH_LINE_NUM PURCH_LINE_NUM
, LINE_ID LINE_ID
, FIRM_PLANNED_STATUS_TYPE FIRM_PLANNED_STATUS_TYPE
, DELIVERY_NEED_DATE DELIVERY_NEED_DATE
, REVISION REVISION
, PRINT_DATE PRINT_DATE
, RECEIVING_DOCUMENT_DESIGNATOR RECEIVING_DOCUMENT_DESIGNATOR
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, DEMAND_CLASS DEMAND_CLASS
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PLANNING_GROUP PLANNING_GROUP
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
FROM "MRP"."MRP_ITEM_PURCHASE_ORDERS"