VIEW: APPS.OE_HOLD_SOURCES_V

Source

View Text - Preformatted

SELECT hs.HOLD_SOURCE_ID , hs.LAST_UPDATE_DATE , hs.LAST_UPDATED_BY , hs.CREATION_DATE , hs.CREATED_BY , fu.USER_NAME , hs.LAST_UPDATE_LOGIN , hs.PROGRAM_APPLICATION_ID , hs.PROGRAM_ID , hs.PROGRAM_UPDATE_DATE , hs.REQUEST_ID , hd.ITEM_TYPE , hs.HOLD_ID , hd.NAME , hs.HOLD_ENTITY_CODE , flv.MEANING , hs.HOLD_ENTITY_ID , OE_Holds_Pvt.entity_id_value ( hs.HOLD_ENTITY_CODE, hs.HOLD_ENTITY_ID) HOLD_ENTITY_ID_VALUE , hs.HOLD_UNTIL_DATE , hs.RELEASED_FLAG , hd.PROGRESS_WF_ON_RELEASE_FLAG , hs.HOLD_COMMENT , hs.CONTEXT , hs.ATTRIBUTE1 , hs.ATTRIBUTE2 , hs.ATTRIBUTE3 , hs.ATTRIBUTE4 , hs.ATTRIBUTE5 , hs.ATTRIBUTE6 , hs.ATTRIBUTE7 , hs.ATTRIBUTE8 , hs.ATTRIBUTE9 , hs.ATTRIBUTE10 , hs.ATTRIBUTE11 , hs.ATTRIBUTE12 , hs.ATTRIBUTE13 , hs.ATTRIBUTE14 , hs.ATTRIBUTE15 , hs.ORG_ID , hs.HOLD_RELEASE_ID , hs.HOLD_ENTITY_CODE2 , flv2.MEANING , hs.HOLD_ENTITY_ID2 , OE_Holds_Pvt.entity_id_value ( hs.HOLD_ENTITY_CODE2, hs.HOLD_ENTITY_ID2) HOLD_ENTITY_ID2_VALUE FROM OE_HOLD_SOURCES hs, OE_HOLD_DEFINITIONS hd, FND_USER fu, FND_LOOKUP_VALUES flv, FND_LOOKUP_VALUES flv2 WHERE hs.HOLD_ID = hd.HOLD_ID AND hs.HOLD_RELEASE_ID is null AND hs.created_by = fu.USER_ID AND flv.lookup_code = hs.hold_entity_code AND flv.lookup_type = 'HOLD_ENTITY_DESC' AND flv.LANGUAGE = userenv('LANG') AND flv.VIEW_APPLICATION_ID = 660 AND flv.SECURITY_GROUP_ID = fnd_global.lookup_security_group(flv.LOOKUP_TYPE, flv.VIEW_APPLICATION_ID) AND flv2.lookup_code(+) = hs.hold_entity_code2 AND flv2.lookup_type(+) = 'HOLD_ENTITY_DESC' AND flv2.LANGUAGE(+) = userenv('LANG') AND flv2.VIEW_APPLICATION_ID(+) = 660 AND flv2.SECURITY_GROUP_ID(+) = fnd_global.lookup_security_group('HOLD_ENTITY_DESC', 660)

View Text - HTML Formatted

SELECT HS.HOLD_SOURCE_ID
, HS.LAST_UPDATE_DATE
, HS.LAST_UPDATED_BY
, HS.CREATION_DATE
, HS.CREATED_BY
, FU.USER_NAME
, HS.LAST_UPDATE_LOGIN
, HS.PROGRAM_APPLICATION_ID
, HS.PROGRAM_ID
, HS.PROGRAM_UPDATE_DATE
, HS.REQUEST_ID
, HD.ITEM_TYPE
, HS.HOLD_ID
, HD.NAME
, HS.HOLD_ENTITY_CODE
, FLV.MEANING
, HS.HOLD_ENTITY_ID
, OE_HOLDS_PVT.ENTITY_ID_VALUE ( HS.HOLD_ENTITY_CODE
, HS.HOLD_ENTITY_ID) HOLD_ENTITY_ID_VALUE
, HS.HOLD_UNTIL_DATE
, HS.RELEASED_FLAG
, HD.PROGRESS_WF_ON_RELEASE_FLAG
, HS.HOLD_COMMENT
, HS.CONTEXT
, HS.ATTRIBUTE1
, HS.ATTRIBUTE2
, HS.ATTRIBUTE3
, HS.ATTRIBUTE4
, HS.ATTRIBUTE5
, HS.ATTRIBUTE6
, HS.ATTRIBUTE7
, HS.ATTRIBUTE8
, HS.ATTRIBUTE9
, HS.ATTRIBUTE10
, HS.ATTRIBUTE11
, HS.ATTRIBUTE12
, HS.ATTRIBUTE13
, HS.ATTRIBUTE14
, HS.ATTRIBUTE15
, HS.ORG_ID
, HS.HOLD_RELEASE_ID
, HS.HOLD_ENTITY_CODE2
, FLV2.MEANING
, HS.HOLD_ENTITY_ID2
, OE_HOLDS_PVT.ENTITY_ID_VALUE ( HS.HOLD_ENTITY_CODE2
, HS.HOLD_ENTITY_ID2) HOLD_ENTITY_ID2_VALUE
FROM OE_HOLD_SOURCES HS
, OE_HOLD_DEFINITIONS HD
, FND_USER FU
, FND_LOOKUP_VALUES FLV
, FND_LOOKUP_VALUES FLV2
WHERE HS.HOLD_ID = HD.HOLD_ID
AND HS.HOLD_RELEASE_ID IS NULL
AND HS.CREATED_BY = FU.USER_ID
AND FLV.LOOKUP_CODE = HS.HOLD_ENTITY_CODE
AND FLV.LOOKUP_TYPE = 'HOLD_ENTITY_DESC'
AND FLV.LANGUAGE = USERENV('LANG')
AND FLV.VIEW_APPLICATION_ID = 660
AND FLV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLV.LOOKUP_TYPE
, FLV.VIEW_APPLICATION_ID)
AND FLV2.LOOKUP_CODE(+) = HS.HOLD_ENTITY_CODE2
AND FLV2.LOOKUP_TYPE(+) = 'HOLD_ENTITY_DESC'
AND FLV2.LANGUAGE(+) = USERENV('LANG')
AND FLV2.VIEW_APPLICATION_ID(+) = 660
AND FLV2.SECURITY_GROUP_ID(+) = FND_GLOBAL.LOOKUP_SECURITY_GROUP('HOLD_ENTITY_DESC'
, 660)