DBA Data[Home] [Help]

VIEW: MSC.MSC_PURCHASE_ORDER_INTERFACE#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, SR_INSTANCE_ID SR_INSTANCE_ID, OLD_NEED_BY_DATE OLD_NEED_BY_DATE, NEW_NEED_BY_DATE NEW_NEED_BY_DATE, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, PO_NUMBER PO_NUMBER, PO_QUANTITY PO_QUANTITY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ACTION ACTION, OPERATING_UNIT OPERATING_UNIT, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, UOM UOM from "MSC"."MSC_PURCHASE_ORDER_INTERFACE"
View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, OLD_NEED_BY_DATE OLD_NEED_BY_DATE
, NEW_NEED_BY_DATE NEW_NEED_BY_DATE
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, PO_NUMBER PO_NUMBER
, PO_QUANTITY PO_QUANTITY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ACTION ACTION
, OPERATING_UNIT OPERATING_UNIT
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, UOM UOM
FROM "MSC"."MSC_PURCHASE_ORDER_INTERFACE"