VIEW: APPS.ASO_APPROVAL_INSTANCES_ALL_V

Source

View Text - Preformatted

SELECT qha.quote_header_id,qha.quote_number, qha.quote_version, aoa.creation_date,aoa.created_by,aoa.last_update_date, aoa.last_updated_by,aoa.last_update_login, aoa.object_approval_id,aoa.object_id,aoa.object_type, aoa.approval_instance_id,al.meaning, nvl((select source_name from jtf_rs_resource_extns where user_id = requester_userid and sysdate between start_date_active and nvl(end_date_active,sysdate) ), (select full_name from per_all_people_f apf,fnd_user fu where apf.person_id = fu.employee_id and fu.user_id = requester_userid and sysdate between effective_start_date and nvl(effective_end_date,sysdate) and sysdate between fu.start_date and nvl(end_date,sysdate) )) full_name, aoa.requester_comments, aoa.start_date,aoa.end_date ,aoa.approval_status from aso_quote_headers qha, aso_apr_obj_approvals aoa, aso_lookups al WHERE qha.quote_header_id = aoa.object_id and aoa.approval_status = al.lookup_code and al.lookup_type = 'ASO_APPROVAL_INSTANCE_STATUS'

View Text - HTML Formatted

SELECT QHA.QUOTE_HEADER_ID
, QHA.QUOTE_NUMBER
, QHA.QUOTE_VERSION
, AOA.CREATION_DATE
, AOA.CREATED_BY
, AOA.LAST_UPDATE_DATE
, AOA.LAST_UPDATED_BY
, AOA.LAST_UPDATE_LOGIN
, AOA.OBJECT_APPROVAL_ID
, AOA.OBJECT_ID
, AOA.OBJECT_TYPE
, AOA.APPROVAL_INSTANCE_ID
, AL.MEANING
, NVL((SELECT SOURCE_NAME
FROM JTF_RS_RESOURCE_EXTNS
WHERE USER_ID = REQUESTER_USERID
AND SYSDATE BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, SYSDATE) )
, (SELECT FULL_NAME
FROM PER_ALL_PEOPLE_F APF
, FND_USER FU
WHERE APF.PERSON_ID = FU.EMPLOYEE_ID
AND FU.USER_ID = REQUESTER_USERID
AND SYSDATE BETWEEN EFFECTIVE_START_DATE
AND NVL(EFFECTIVE_END_DATE
, SYSDATE)
AND SYSDATE BETWEEN FU.START_DATE
AND NVL(END_DATE
, SYSDATE) )) FULL_NAME
, AOA.REQUESTER_COMMENTS
, AOA.START_DATE
, AOA.END_DATE
, AOA.APPROVAL_STATUS
FROM ASO_QUOTE_HEADERS QHA
, ASO_APR_OBJ_APPROVALS AOA
, ASO_LOOKUPS AL
WHERE QHA.QUOTE_HEADER_ID = AOA.OBJECT_ID
AND AOA.APPROVAL_STATUS = AL.LOOKUP_CODE
AND AL.LOOKUP_TYPE = 'ASO_APPROVAL_INSTANCE_STATUS'