eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AHL_MEL_CDL_HEADERS_V

Source

View Text - Preformatted


SELECT HDR.MEL_CDL_HEADER_ID, HDR.OBJECT_VERSION_NUMBER, HDR.PC_NODE_ID, PCN.NAME PC_NODE_NAME, PCN.DESCRIPTION PC_NODE_DESC, PCH.PC_HEADER_ID, PCH.NAME PC_HEADER_NAME, PCH.DESCRIPTION PC_HEADER_DESC, HDR.MEL_CDL_TYPE_CODE, FLT.MEANING MEL_CDL_TYPE_MEANING, FLT.DESCRIPTION MEL_CDL_TYPE_DESC, HDR.STATUS_CODE, FLS.MEANING STATUS_MEANING, FLS.DESCRIPTION STATUS_DESC, HDR.REVISION, HDR.VERSION_NUMBER, HDR.REVISION_DATE, HDR.EXPIRED_DATE, HDR.ATTRIBUTE_CATEGORY, HDR.ATTRIBUTE1, HDR.ATTRIBUTE2, HDR.ATTRIBUTE3, HDR.ATTRIBUTE4, HDR.ATTRIBUTE5, HDR.ATTRIBUTE6, HDR.ATTRIBUTE7, HDR.ATTRIBUTE8, HDR.ATTRIBUTE9, HDR.ATTRIBUTE10, HDR.ATTRIBUTE11, HDR.ATTRIBUTE12, HDR.ATTRIBUTE13, HDR.ATTRIBUTE14, HDR.ATTRIBUTE15 FROM AHL_MEL_CDL_HEADERS HDR, AHL_PC_NODES_VL PCN, AHL_PC_HEADERS_VL PCH, FND_LOOKUP_VALUES_VL FLT, FND_LOOKUP_VALUES_VL FLS WHERE HDR.PC_NODE_ID = PCN.PC_NODE_ID AND PCN.PC_HEADER_ID = PCH.PC_HEADER_ID AND PCH.STATUS = 'COMPLETE' AND PCH.PRIMARY_FLAG = 'Y' AND FLT.LOOKUP_TYPE = 'AHL_MEL_CDL_TYPE' AND FLT.LOOKUP_CODE = HDR.MEL_CDL_TYPE_CODE AND FLS.LOOKUP_TYPE = 'AHL_MEL_CDL_STATUS' AND FLS.LOOKUP_CODE = HDR.STATUS_CODE

View Text - HTML Formatted

SELECT HDR.MEL_CDL_HEADER_ID
, HDR.OBJECT_VERSION_NUMBER
, HDR.PC_NODE_ID
, PCN.NAME PC_NODE_NAME
, PCN.DESCRIPTION PC_NODE_DESC
, PCH.PC_HEADER_ID
, PCH.NAME PC_HEADER_NAME
, PCH.DESCRIPTION PC_HEADER_DESC
, HDR.MEL_CDL_TYPE_CODE
, FLT.MEANING MEL_CDL_TYPE_MEANING
, FLT.DESCRIPTION MEL_CDL_TYPE_DESC
, HDR.STATUS_CODE
, FLS.MEANING STATUS_MEANING
, FLS.DESCRIPTION STATUS_DESC
, HDR.REVISION
, HDR.VERSION_NUMBER
, HDR.REVISION_DATE
, HDR.EXPIRED_DATE
, HDR.ATTRIBUTE_CATEGORY
, HDR.ATTRIBUTE1
, HDR.ATTRIBUTE2
, HDR.ATTRIBUTE3
, HDR.ATTRIBUTE4
, HDR.ATTRIBUTE5
, HDR.ATTRIBUTE6
, HDR.ATTRIBUTE7
, HDR.ATTRIBUTE8
, HDR.ATTRIBUTE9
, HDR.ATTRIBUTE10
, HDR.ATTRIBUTE11
, HDR.ATTRIBUTE12
, HDR.ATTRIBUTE13
, HDR.ATTRIBUTE14
, HDR.ATTRIBUTE15
FROM AHL_MEL_CDL_HEADERS HDR
, AHL_PC_NODES_VL PCN
, AHL_PC_HEADERS_VL PCH
, FND_LOOKUP_VALUES_VL FLT
, FND_LOOKUP_VALUES_VL FLS
WHERE HDR.PC_NODE_ID = PCN.PC_NODE_ID
AND PCN.PC_HEADER_ID = PCH.PC_HEADER_ID
AND PCH.STATUS = 'COMPLETE'
AND PCH.PRIMARY_FLAG = 'Y'
AND FLT.LOOKUP_TYPE = 'AHL_MEL_CDL_TYPE'
AND FLT.LOOKUP_CODE = HDR.MEL_CDL_TYPE_CODE
AND FLS.LOOKUP_TYPE = 'AHL_MEL_CDL_STATUS'
AND FLS.LOOKUP_CODE = HDR.STATUS_CODE