VIEW: CSD.CSD_GROUP_JOB_PARAM_TEMP#

Source

View Text - Preformatted

select GROUP_JOB_ID GROUP_JOB_ID, REPAIR_GROUP_ID REPAIR_GROUP_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, JOB_TYPE JOB_TYPE, ROUTING_REFERENCE_ID ROUTING_REFERENCE_ID, ALTERNATE_DESIGNATOR_CODE ALTERNATE_DESIGNATOR_CODE, JOB_STATUS_TYPE JOB_STATUS_TYPE, ACCOUNTING_CLASS ACCOUNTING_CLASS, START_DATE START_DATE, COMPLETION_DATE COMPLETION_DATE, QUANTITY_RECEIVED QUANTITY_RECEIVED, QUANTITY_SUBMITTED QUANTITY_SUBMITTED, ITEM_REVISION ITEM_REVISION, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, INCIDENT_ID INCIDENT_ID, PROCESS_ID PROCESS_ID from "CSD"."CSD_GROUP_JOB_PARAM_TEMP"

View Text - HTML Formatted

SELECT GROUP_JOB_ID GROUP_JOB_ID
, REPAIR_GROUP_ID REPAIR_GROUP_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, JOB_TYPE JOB_TYPE
, ROUTING_REFERENCE_ID ROUTING_REFERENCE_ID
, ALTERNATE_DESIGNATOR_CODE ALTERNATE_DESIGNATOR_CODE
, JOB_STATUS_TYPE JOB_STATUS_TYPE
, ACCOUNTING_CLASS ACCOUNTING_CLASS
, START_DATE START_DATE
, COMPLETION_DATE COMPLETION_DATE
, QUANTITY_RECEIVED QUANTITY_RECEIVED
, QUANTITY_SUBMITTED QUANTITY_SUBMITTED
, ITEM_REVISION ITEM_REVISION
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, INCIDENT_ID INCIDENT_ID
, PROCESS_ID PROCESS_ID
FROM "CSD"."CSD_GROUP_JOB_PARAM_TEMP"