SELECT *
FROM apps.FND_CONC_REQ_SUMMARY_V
WHERE phase_code = 'P'
AND
status_code IN ('I', 'Q')
AND (NVL
(request_type, 'X') != 'S')
AND
requested_start_date >= SYSDATE
ORDER BY program_short_name DESC;
- PHASE_CODE status P stands for Pending
- STATUS_CODE status I stands for Normal & status Q stands of Standby
No comments:
Post a Comment