VIEW: APPS.OE_HOLDS_HISTORY_V

Source

View Text - Preformatted

SELECT oh.header_id , oh.line_id , 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 , 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 , hs.HOLD_COMMENT , 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 , oh.CREATION_DATE APPLIED_DATE , OE_Holds_Pvt.user_name(oh.CREATED_BY) APPLIED_BY , hr.CREATION_DATE RELEASED_DATE , OE_Holds_Pvt.user_name(hr.CREATED_BY) RELEASED_BY , hr.release_reason_code , hr.release_comment FROM OE_ORDER_HOLDS_ALL oh, OE_HOLD_SOURCES hs, OE_HOLD_RELEASES hr, OE_HOLD_DEFINITIONS hd, FND_USER fu, FND_LOOKUP_VALUES flv, FND_LOOKUP_VALUES flv2 WHERE oh.hold_source_id = hs.hold_source_id AND hs.hold_id = hd.hold_id AND hs.created_by = fu.USER_ID AND oh.HOLD_RELEASE_ID = hr.HOLD_RELEASE_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) AND hs.ORG_ID = oh.ORG_ID

View Text - HTML Formatted

SELECT OH.HEADER_ID
, OH.LINE_ID
, 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
, 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
, HS.HOLD_COMMENT
, 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
, OH.CREATION_DATE APPLIED_DATE
, OE_HOLDS_PVT.USER_NAME(OH.CREATED_BY) APPLIED_BY
, HR.CREATION_DATE RELEASED_DATE
, OE_HOLDS_PVT.USER_NAME(HR.CREATED_BY) RELEASED_BY
, HR.RELEASE_REASON_CODE
, HR.RELEASE_COMMENT
FROM OE_ORDER_HOLDS_ALL OH
, OE_HOLD_SOURCES HS
, OE_HOLD_RELEASES HR
, OE_HOLD_DEFINITIONS HD
, FND_USER FU
, FND_LOOKUP_VALUES FLV
, FND_LOOKUP_VALUES FLV2
WHERE OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID
AND HS.HOLD_ID = HD.HOLD_ID
AND HS.CREATED_BY = FU.USER_ID
AND OH.HOLD_RELEASE_ID = HR.HOLD_RELEASE_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)
AND HS.ORG_ID = OH.ORG_ID