SELECT crh.task_id, crh.task_assignment_id, max(nvl(crl.arrival_date,crl.creation_date)) from csp_requirement_headers crh, csp_requirement_lines crl where crh.requirement_header_id = crl.requirement_header_id group by crh.task_id, crh.task_assignment_id
SELECT CRH.TASK_ID
, CRH.TASK_ASSIGNMENT_ID
, MAX(NVL(CRL.ARRIVAL_DATE
, CRL.CREATION_DATE))
FROM CSP_REQUIREMENT_HEADERS CRH
, CSP_REQUIREMENT_LINES CRL
WHERE CRH.REQUIREMENT_HEADER_ID = CRL.REQUIREMENT_HEADER_ID GROUP BY CRH.TASK_ID
, CRH.TASK_ASSIGNMENT_ID
|
|
|