View: ASO_APR_QUOTE_APPROVAL_V

View Text

SELECT A.ASO_APR_OBJ_APPROVAL_ID
, A.APPROVAL_SEQUENCE
, A.APPROVAL_STATUS
, A.DATE_SENT
, A.DATE_RECEIVED
, B.DISPLAY_NAME "REVIEWER"
, B.EMAIL_ADDRESS
, B.TERRITORY
, C.GROUP_NUMBER
FROM ASO_APR_APPROVAL_DET_B A
, WF_ROLES B
, JTF_RS_GROUPS_B C
WHERE C.GROUP_ID = A.JTF_RS_APPROVER_GROUP_ID
AND B.NAME = 'RS_GROUP:' || TO_CHAR(NVL(A.JTF_RS_APPROVER_ID
, A.JTF_RS_APPROVER_GROUP_ID))

Columns