Oracle Apps R12.1.3
I have Project , Templates form and we need to display only Submitted , Approved Project Status value only, not needed rest of the values.
I am able to see only these values.
Here is the setup.
SELECT project_status_name, NULL project_status_code, NULL project_system_status_code
WHERE project_system_status_code in('SUBMITTED', 'APPROVED')
AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active, TRUNC (SYSDATE))
AND NVL (end_date_active, TRUNC (SYSDATE))
AND status_type = 'PROJECT'
Note: PROJECT_STATUSES_CHANGE LOV is calling from the Change Status Button.
I am not getting any error and not firing.
I am getting above error when i select Submitted.
Can you please help me?