VIEW: AHL.AHL_MR_HEADERS_B#

Source

View Text - Preformatted

select MR_HEADER_ID MR_HEADER_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, TITLE TITLE, VERSION_NUMBER VERSION_NUMBER, PRECEDING_MR_HEADER_ID PRECEDING_MR_HEADER_ID, CATEGORY_CODE CATEGORY_CODE, SERVICE_TYPE_CODE SERVICE_TYPE_CODE, MR_STATUS_CODE MR_STATUS_CODE, IMPLEMENT_STATUS_CODE IMPLEMENT_STATUS_CODE, REPETITIVE_FLAG REPETITIVE_FLAG, SHOW_REPETITIVE_CODE SHOW_REPETITIVE_CODE, COPY_ACCOMPLISHMENT_FLAG COPY_ACCOMPLISHMENT_FLAG, WHICHEVER_FIRST_CODE WHICHEVER_FIRST_CODE, PROGRAM_TYPE_CODE PROGRAM_TYPE_CODE, PROGRAM_SUBTYPE_CODE PROGRAM_SUBTYPE_CODE, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, REVISION REVISION, SERVICE_REQUEST_TEMPLATE_ID SERVICE_REQUEST_TEMPLATE_ID, TYPE_CODE TYPE_CODE, DOWN_TIME DOWN_TIME, UOM_CODE UOM_CODE, SECURITY_GROUP_ID SECURITY_GROUP_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, QA_INSPECTION_TYPE QA_INSPECTION_TYPE, BILLING_ITEM_ID BILLING_ITEM_ID, BILLING_ORG_ID BILLING_ORG_ID, SPACE_CATEGORY_CODE SPACE_CATEGORY_CODE, APPLICATION_USG_CODE APPLICATION_USG_CODE, AUTO_SIGNOFF_FLAG AUTO_SIGNOFF_FLAG, COPY_INIT_ACCOMPL_FLAG COPY_INIT_ACCOMPL_FLAG, COPY_DEFERRALS_FLAG COPY_DEFERRALS_FLAG, TERMINATION_REQUIRED_FLAG TERMINATION_REQUIRED_FLAG, WARRANTY_TEMPLATE_ID WARRANTY_TEMPLATE_ID, SERVICE_CATEGORY_RANK SERVICE_CATEGORY_RANK from "AHL"."AHL_MR_HEADERS_B"

View Text - HTML Formatted

SELECT MR_HEADER_ID MR_HEADER_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, TITLE TITLE
, VERSION_NUMBER VERSION_NUMBER
, PRECEDING_MR_HEADER_ID PRECEDING_MR_HEADER_ID
, CATEGORY_CODE CATEGORY_CODE
, SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, MR_STATUS_CODE MR_STATUS_CODE
, IMPLEMENT_STATUS_CODE IMPLEMENT_STATUS_CODE
, REPETITIVE_FLAG REPETITIVE_FLAG
, SHOW_REPETITIVE_CODE SHOW_REPETITIVE_CODE
, COPY_ACCOMPLISHMENT_FLAG COPY_ACCOMPLISHMENT_FLAG
, WHICHEVER_FIRST_CODE WHICHEVER_FIRST_CODE
, PROGRAM_TYPE_CODE PROGRAM_TYPE_CODE
, PROGRAM_SUBTYPE_CODE PROGRAM_SUBTYPE_CODE
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, REVISION REVISION
, SERVICE_REQUEST_TEMPLATE_ID SERVICE_REQUEST_TEMPLATE_ID
, TYPE_CODE TYPE_CODE
, DOWN_TIME DOWN_TIME
, UOM_CODE UOM_CODE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, QA_INSPECTION_TYPE QA_INSPECTION_TYPE
, BILLING_ITEM_ID BILLING_ITEM_ID
, BILLING_ORG_ID BILLING_ORG_ID
, SPACE_CATEGORY_CODE SPACE_CATEGORY_CODE
, APPLICATION_USG_CODE APPLICATION_USG_CODE
, AUTO_SIGNOFF_FLAG AUTO_SIGNOFF_FLAG
, COPY_INIT_ACCOMPL_FLAG COPY_INIT_ACCOMPL_FLAG
, COPY_DEFERRALS_FLAG COPY_DEFERRALS_FLAG
, TERMINATION_REQUIRED_FLAG TERMINATION_REQUIRED_FLAG
, WARRANTY_TEMPLATE_ID WARRANTY_TEMPLATE_ID
, SERVICE_CATEGORY_RANK SERVICE_CATEGORY_RANK
FROM "AHL"."AHL_MR_HEADERS_B"