VIEW: APPS.OKI_HSTATUS_DTL_V

Source

View Text - Preformatted

SELECT H.CHR_ID , HDR.CONTRACT_NUMBER , HDR.CONTRACT_NUMBER_MODIFIER , HDR.COMPLETE_K_NUMBER , H.CREATION_DATE STATUS_CHANGE_DATE , H.CONTRACT_VERSION , H.STS_CODE_TO STATUS_CODE , H.REASON_CODE CHANGE_REASON_CODE , STS_REASON.MEANING CHANGE_REASON , H.TRN_CODE , HL.COMMENTS , FND.USER_NAME CHANGE_USER , HZ.PERSON_LAST_NAME || ' ' || HZ.PERSON_PRE_NAME_ADJUNCT || ' ' || HZ.PERSON_FIRST_NAME || ' (' || HZ.KNOWN_AS || ')' CHANGE_PERSON , HZ.EMAIL_ADDRESS FROM FND_LOOKUP_VALUES STS_REASON , OKC_K_HISTORY_TL HL , OKC_K_HISTORY_B H , OKI_SRM_006_V HDR , FND_USER FND , HZ_PARTIES HZ WHERE H.CLE_ID IS NULL AND H.ID = HL.ID AND HDR.CHR_ID = H.CHR_ID AND H.OPN_CODE = 'STS_CHG' AND STS_REASON.LOOKUP_TYPE(+) = 'OKC_STS_CHG_REASON' AND STS_REASON.LOOKUP_CODE(+) = H.REASON_CODE AND STS_REASON.LANGUAGE(+) = USERENV( 'LANG' ) AND HL.LANGUAGE = USERENV( 'LANG' ) AND H.CREATED_BY = FND.USER_ID AND FND.PERSON_PARTY_ID = HZ.PARTY_ID(+)

View Text - HTML Formatted

SELECT H.CHR_ID
, HDR.CONTRACT_NUMBER
, HDR.CONTRACT_NUMBER_MODIFIER
, HDR.COMPLETE_K_NUMBER
, H.CREATION_DATE STATUS_CHANGE_DATE
, H.CONTRACT_VERSION
, H.STS_CODE_TO STATUS_CODE
, H.REASON_CODE CHANGE_REASON_CODE
, STS_REASON.MEANING CHANGE_REASON
, H.TRN_CODE
, HL.COMMENTS
, FND.USER_NAME CHANGE_USER
, HZ.PERSON_LAST_NAME || ' ' || HZ.PERSON_PRE_NAME_ADJUNCT || ' ' || HZ.PERSON_FIRST_NAME || ' (' || HZ.KNOWN_AS || ')' CHANGE_PERSON
, HZ.EMAIL_ADDRESS
FROM FND_LOOKUP_VALUES STS_REASON
, OKC_K_HISTORY_TL HL
, OKC_K_HISTORY_B H
, OKI_SRM_006_V HDR
, FND_USER FND
, HZ_PARTIES HZ
WHERE H.CLE_ID IS NULL
AND H.ID = HL.ID
AND HDR.CHR_ID = H.CHR_ID
AND H.OPN_CODE = 'STS_CHG'
AND STS_REASON.LOOKUP_TYPE(+) = 'OKC_STS_CHG_REASON'
AND STS_REASON.LOOKUP_CODE(+) = H.REASON_CODE
AND STS_REASON.LANGUAGE(+) = USERENV( 'LANG' )
AND HL.LANGUAGE = USERENV( 'LANG' )
AND H.CREATED_BY = FND.USER_ID
AND FND.PERSON_PARTY_ID = HZ.PARTY_ID(+)