View: ASO_APPROVAL_INSTANCES_ALL_V

Product:	ASO - Order Capture
Description:
Implementation/DBA Data:	APPS.ASO_APPROVAL_INSTANCES_ALL_V

View Text

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_ALL 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'

Columns