VIEW: INV.MTL_REPLENISH_HEADERS#

Source

View Text - Preformatted

select REPLENISHMENT_HEADER_ID REPLENISHMENT_HEADER_ID, REPLENISHMENT_COUNT_NAME REPLENISHMENT_COUNT_NAME, COUNT_DATE COUNT_DATE, 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, ORGANIZATION_ID ORGANIZATION_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, SUPPLY_CUTOFF_DATE SUPPLY_CUTOFF_DATE, REQUISITION_APPROVAL_TYPE REQUISITION_APPROVAL_TYPE, PROCESS_STATUS PROCESS_STATUS, PROCESS_MODE PROCESS_MODE, ERROR_FLAG ERROR_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, DELIVERY_LOCATION_ID DELIVERY_LOCATION_ID, COUNT_MODE COUNT_MODE, DEFAULT_COUNT_TYPE_CODE DEFAULT_COUNT_TYPE_CODE, DEFAULT_LINE_ITEMS DEFAULT_LINE_ITEMS from "INV"."MTL_REPLENISH_HEADERS"

View Text - HTML Formatted

SELECT REPLENISHMENT_HEADER_ID REPLENISHMENT_HEADER_ID
, REPLENISHMENT_COUNT_NAME REPLENISHMENT_COUNT_NAME
, COUNT_DATE COUNT_DATE
, 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
, ORGANIZATION_ID ORGANIZATION_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, SUPPLY_CUTOFF_DATE SUPPLY_CUTOFF_DATE
, REQUISITION_APPROVAL_TYPE REQUISITION_APPROVAL_TYPE
, PROCESS_STATUS PROCESS_STATUS
, PROCESS_MODE PROCESS_MODE
, ERROR_FLAG ERROR_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, DELIVERY_LOCATION_ID DELIVERY_LOCATION_ID
, COUNT_MODE COUNT_MODE
, DEFAULT_COUNT_TYPE_CODE DEFAULT_COUNT_TYPE_CODE
, DEFAULT_LINE_ITEMS DEFAULT_LINE_ITEMS
FROM "INV"."MTL_REPLENISH_HEADERS"