VIEW: APPS.ASO_APPROVER_DETAILS_V

Source

View Text - Preformatted

SELECT aad.creation_date,aad.created_by,aad.last_update_date, aad.last_updated_by,aad.last_update_login, aad.object_approval_id,aad.approval_det_id, nvl((select full_name from per_all_people_f where person_id = approver_person_id and sysdate between effective_start_date and nvl(effective_end_date,sysdate) ) ,(select source_name from jtf_rs_resource_extns where user_id = approver_user_id and sysdate between start_date_active and nvl(end_date_active,sysdate) )) full_name, aad.approver_person_id,aad.approver_user_id, aad.approver_sequence, al.meaning ,aad.approver_comments,aad.date_sent, aad.date_received,to_char(aad.approval_det_id||'DET') from aso_apr_approval_details aad, aso_lookups al WHERE aad.approver_status = al.lookup_code and al.lookup_type = 'ASO_APPROVER_STATUS'

View Text - HTML Formatted

SELECT AAD.CREATION_DATE
, AAD.CREATED_BY
, AAD.LAST_UPDATE_DATE
, AAD.LAST_UPDATED_BY
, AAD.LAST_UPDATE_LOGIN
, AAD.OBJECT_APPROVAL_ID
, AAD.APPROVAL_DET_ID
, NVL((SELECT FULL_NAME
FROM PER_ALL_PEOPLE_F
WHERE PERSON_ID = APPROVER_PERSON_ID
AND SYSDATE BETWEEN EFFECTIVE_START_DATE
AND NVL(EFFECTIVE_END_DATE
, SYSDATE) )
, (SELECT SOURCE_NAME
FROM JTF_RS_RESOURCE_EXTNS
WHERE USER_ID = APPROVER_USER_ID
AND SYSDATE BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, SYSDATE) )) FULL_NAME
, AAD.APPROVER_PERSON_ID
, AAD.APPROVER_USER_ID
, AAD.APPROVER_SEQUENCE
, AL.MEANING
, AAD.APPROVER_COMMENTS
, AAD.DATE_SENT
, AAD.DATE_RECEIVED
, TO_CHAR(AAD.APPROVAL_DET_ID||'DET')
FROM ASO_APR_APPROVAL_DETAILS AAD
, ASO_LOOKUPS AL
WHERE AAD.APPROVER_STATUS = AL.LOOKUP_CODE
AND AL.LOOKUP_TYPE = 'ASO_APPROVER_STATUS'