Product: | ASO - Order Capture |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ASO_APPROVER_DETAILS_V |
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'