VIEW: APPS.AHL_MR_HEADERS_APP_V

Source

View Text - Preformatted

SELECT MR_HEADER_ID,OBJECT_VERSION_NUMBER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,TITLE,VERSION_NUMBER,PRECEDING_MR_HEADER_ID,CATEGORY_CODE,SERVICE_TYPE_CODE,MR_STATUS_CODE,IMPLEMENT_STATUS_CODE,REPETITIVE_FLAG,SHOW_REPETITIVE_CODE,WHICHEVER_FIRST_CODE,COPY_ACCOMPLISHMENT_FLAG,PROGRAM_TYPE_CODE,PROGRAM_SUBTYPE_CODE,EFFECTIVE_FROM,EFFECTIVE_TO,REVISION,BILLING_ITEM_ID,BILLING_ORG_ID,SPACE_CATEGORY_CODE,QA_INSPECTION_TYPE_CODE,DESCRIPTION,COMMENTS,SERVICE_REQUEST_TEMPLATE_ID,TYPE_CODE,DOWN_TIME,UOM_CODE,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,APPLICATION_USG_CODE, AUTO_SIGNOFF_FLAG, COPY_INIT_ACCOMPL_FLAG, COPY_DEFERRALS_FLAG FROM AHL_MR_HEADERS_VL WHERE APPLICATION_USG_CODE=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))

View Text - HTML Formatted

SELECT MR_HEADER_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, TITLE
, VERSION_NUMBER
, PRECEDING_MR_HEADER_ID
, CATEGORY_CODE
, SERVICE_TYPE_CODE
, MR_STATUS_CODE
, IMPLEMENT_STATUS_CODE
, REPETITIVE_FLAG
, SHOW_REPETITIVE_CODE
, WHICHEVER_FIRST_CODE
, COPY_ACCOMPLISHMENT_FLAG
, PROGRAM_TYPE_CODE
, PROGRAM_SUBTYPE_CODE
, EFFECTIVE_FROM
, EFFECTIVE_TO
, REVISION
, BILLING_ITEM_ID
, BILLING_ORG_ID
, SPACE_CATEGORY_CODE
, QA_INSPECTION_TYPE_CODE
, DESCRIPTION
, COMMENTS
, SERVICE_REQUEST_TEMPLATE_ID
, TYPE_CODE
, DOWN_TIME
, UOM_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, APPLICATION_USG_CODE
, AUTO_SIGNOFF_FLAG
, COPY_INIT_ACCOMPL_FLAG
, COPY_DEFERRALS_FLAG
FROM AHL_MR_HEADERS_VL
WHERE APPLICATION_USG_CODE=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))