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.OKE_K_HOLDS_V

Source

View Text - Preformatted


SELECT B.ROWID , A.K_NUMBER_DISP , B.HOLD_ID , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN , B.K_HEADER_ID , B.K_LINE_ID , B.DELIVERABLE_ID , B.HOLD_TYPE_CODE , T.HOLD_TYPE_NAME , B.HOLD_REASON_CODE , R.HOLD_REASON_NAME , B.HOLD_STATUS_CODE , S.HOLD_STATUS_NAME , B.HOLD_COMMENT , B.APPLY_DATE , B.SCHEDULE_REMOVE_DATE , B.REMOVE_DATE , B.REMOVE_REASON_CODE , RR.REMOVE_REASON_NAME , B.REMOVE_COMMENT , B.WF_ITEM_TYPE , B.WF_PROCESS , B.WF_ITEM_KEY , B.ATTRIBUTE_CATEGORY , B.ATTRIBUTE1 , B.ATTRIBUTE2 , B.ATTRIBUTE3 , B.ATTRIBUTE4 , B.ATTRIBUTE5 , B.ATTRIBUTE6 , B.ATTRIBUTE7 , B.ATTRIBUTE8 , B.ATTRIBUTE9 , B.ATTRIBUTE10 , B.ATTRIBUTE11 , B.ATTRIBUTE12 , B.ATTRIBUTE13 , B.ATTRIBUTE14 , B.ATTRIBUTE15 FROM OKE_K_HEADERS A , OKE_K_HOLDS B , ( SELECT LOOKUP_CODE HOLD_TYPE_CODE , MEANING HOLD_TYPE_NAME FROM FND_LOOKUP_VALUES_VL WHERE VIEW_APPLICATION_ID = 777 AND LOOKUP_TYPE = 'HOLD_TYPE' ) T , ( SELECT LOOKUP_CODE HOLD_REASON_CODE , MEANING HOLD_REASON_NAME FROM FND_LOOKUP_VALUES_VL WHERE VIEW_APPLICATION_ID = 777 AND LOOKUP_TYPE = 'APPLY_HOLD_REASON' ) R , ( SELECT LOOKUP_CODE REMOVE_REASON_CODE , MEANING REMOVE_REASON_NAME FROM FND_LOOKUP_VALUES_VL WHERE VIEW_APPLICATION_ID = 777 AND LOOKUP_TYPE = 'REMOVE_HOLD_REASON' ) RR , OKE_HOLD_STATUSES_VL S WHERE A.K_HEADER_ID = B.K_HEADER_ID AND R.HOLD_REASON_CODE = B.HOLD_REASON_CODE AND RR.REMOVE_REASON_CODE (+) = B.REMOVE_REASON_CODE AND T.HOLD_TYPE_CODE = B.HOLD_TYPE_CODE AND S.HOLD_STATUS_CODE = B.HOLD_STATUS_CODE

View Text - HTML Formatted

SELECT B.ROWID
, A.K_NUMBER_DISP
, B.HOLD_ID
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.K_HEADER_ID
, B.K_LINE_ID
, B.DELIVERABLE_ID
, B.HOLD_TYPE_CODE
, T.HOLD_TYPE_NAME
, B.HOLD_REASON_CODE
, R.HOLD_REASON_NAME
, B.HOLD_STATUS_CODE
, S.HOLD_STATUS_NAME
, B.HOLD_COMMENT
, B.APPLY_DATE
, B.SCHEDULE_REMOVE_DATE
, B.REMOVE_DATE
, B.REMOVE_REASON_CODE
, RR.REMOVE_REASON_NAME
, B.REMOVE_COMMENT
, B.WF_ITEM_TYPE
, B.WF_PROCESS
, B.WF_ITEM_KEY
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
FROM OKE_K_HEADERS A
, OKE_K_HOLDS B
, ( SELECT LOOKUP_CODE HOLD_TYPE_CODE
, MEANING HOLD_TYPE_NAME
FROM FND_LOOKUP_VALUES_VL
WHERE VIEW_APPLICATION_ID = 777
AND LOOKUP_TYPE = 'HOLD_TYPE' ) T
, ( SELECT LOOKUP_CODE HOLD_REASON_CODE
, MEANING HOLD_REASON_NAME
FROM FND_LOOKUP_VALUES_VL
WHERE VIEW_APPLICATION_ID = 777
AND LOOKUP_TYPE = 'APPLY_HOLD_REASON' ) R
, ( SELECT LOOKUP_CODE REMOVE_REASON_CODE
, MEANING REMOVE_REASON_NAME
FROM FND_LOOKUP_VALUES_VL
WHERE VIEW_APPLICATION_ID = 777
AND LOOKUP_TYPE = 'REMOVE_HOLD_REASON' ) RR
, OKE_HOLD_STATUSES_VL S
WHERE A.K_HEADER_ID = B.K_HEADER_ID
AND R.HOLD_REASON_CODE = B.HOLD_REASON_CODE
AND RR.REMOVE_REASON_CODE (+) = B.REMOVE_REASON_CODE
AND T.HOLD_TYPE_CODE = B.HOLD_TYPE_CODE
AND S.HOLD_STATUS_CODE = B.HOLD_STATUS_CODE