VIEW: MRP.MRP_PLANNED_RESOURCE_REQS#

Source

View Text - Preformatted

select DEPARTMENT_ID DEPARTMENT_ID, ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, RESOURCE_ID RESOURCE_ID, LINE_ID LINE_ID, USING_ASSEMBLY_ITEM_ID USING_ASSEMBLY_ITEM_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, 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, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, RUNTIME_QUANTITY RUNTIME_QUANTITY, RESOURCE_OFFSET_PERCENT RESOURCE_OFFSET_PERCENT, SETBACK_DAYS SETBACK_DAYS, BASIS BASIS, RESOURCE_UNITS RESOURCE_UNITS, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SOURCE_ITEM_ID SOURCE_ITEM_ID, ASSEMBLY_USAGE ASSEMBLY_USAGE, EFFECTIVITY_DATE EFFECTIVITY_DATE, DISABLE_DATE DISABLE_DATE from "MRP"."MRP_PLANNED_RESOURCE_REQS"

View Text - HTML Formatted

SELECT DEPARTMENT_ID DEPARTMENT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, RESOURCE_ID RESOURCE_ID
, LINE_ID LINE_ID
, USING_ASSEMBLY_ITEM_ID USING_ASSEMBLY_ITEM_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, 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
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, RUNTIME_QUANTITY RUNTIME_QUANTITY
, RESOURCE_OFFSET_PERCENT RESOURCE_OFFSET_PERCENT
, SETBACK_DAYS SETBACK_DAYS
, BASIS BASIS
, RESOURCE_UNITS RESOURCE_UNITS
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SOURCE_ITEM_ID SOURCE_ITEM_ID
, ASSEMBLY_USAGE ASSEMBLY_USAGE
, EFFECTIVITY_DATE EFFECTIVITY_DATE
, DISABLE_DATE DISABLE_DATE
FROM "MRP"."MRP_PLANNED_RESOURCE_REQS"