set markup html on;
SET PAGESIZE 375
spool c:\DF_Marys_REPORT_VISUALIZE.html;
SELECT T3.R_Object_ID,T3.Object_Name,T3.Title,T3.R_Object_Type,
DECODE (T3.R_Status,2,'Superseded' ,3,'Retired',4,'Draft',5,'Review Copy',7,'Authorised',8,'Withdrawn') AS R_Status_Doc,
T3.R_version,T0.Object_Name,T0.R_Object_Type,DECODE(T0.R_Status,0,'Draft',1,'Workflow Approval',2,'Workflow Approved',
3,'Workflow Disapproved',4,'Cancelled',5,'Editing',6,'Release Approval',7,'Authorised Pending',8,'Release Disapproved',
9,'Awaiting Pre-Approval',10,'Change Review',11,'Pending Release',12,'Released',13,'Superceded',14,'Edit Complete',
15,'Review',16,'Review Complete',17,'Change Review Complete',18,'Undefined',19,'Workflow Approved',20,'Release Approved',
21,'Authorised') AS R_Status_WF,T0.R_TargetDate,T4.User_Name,T8.User_Name,DECODE(T7.R_Status,
0,'Not Applicable', 1,'Disapproved', 2,'Approved', 3,'Not Required', 4,'Pending', 5,'Withdrawn') AS R_STATUS_Panel,[b][color=red]T9.sysdate - TO_DATE(T7.StartDate,'yyyymmdd')[/color][/b] AgeDays
FROM QM_CHANGEREQUEST_BASE T0 INNER JOIN QM_Changerequest_Base_R T1 ON T0.R_Object_ID = T1.Link_From_ID
                              INNER JOIN QM_CRDocument T2 ON T1.R_Documents = T2.R_Object_ID
                              INNER JOIN QM_Document_BASE T3 ON T2.R_Docid = T3.R_Object_ID
                              INNER JOIN QM_User T4 ON T0.R_Originator = T4.R_Object_ID
                              INNER JOIN QM_Panel T5 ON T0.R_Object_ID = T5.R_OwningObjectID
                              INNER JOIN QM_Panel_R T6 ON T5.R_Object_ID = T6.Link_From_ID
                              INNER JOIN QM_PanelMember T7 ON T6.R_Members = T7.R_Object_ID
                              INNER JOIN QM_USER T8 ON T7.R_UserID = T8.R_Object_ID,DUAL T9
ORDER BY T3.R_Object_ID ASC;
spool off;
set markup html off;

= T7.R_Object_ID
<br>
 16                                INNER JOIN QM_USER T8 ON T7.R_UserID = T8.R_O
bject_ID,DUAL T9
<br>
 17  ORDER BY T3.R_Object_ID ASC;
<br>
<pre>
0,'Not Applicable', 1,'Disapproved', 2,'Approved', 3,'Not Required', 4,'Pending'
, 5,'Withdrawn') AS R_STATUS_Panel,T9.sysdate - TO_DATE(T7.StartDate,'yyyymmdd')
 AgeDays

                                      *
</pre>
ERROR at line 8:
<br>
ORA-01747: invalid user.table.column, table.column, or column specification
<br>


SQL&gt; spool off;
<br>
SQL&gt; set markup html off;
<br>

T9.sysdate 

DUAL T9

SQL> select d.sysdate from dual d;
select d.sysdate from dual d
         *
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or column specification

16:44:56 SQL> select e.ename,d.sysdate
16:45:24   2  from emp e,dual d;
select e.ename,d.sysdate
                 *
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or column specification


16:45:35 SQL> select e.ename,sysdate
16:45:43   2  from emp e;

SMITH      26-NOV-09
ALLEN      26-NOV-09
WARD       26-NOV-09
JONES      26-NOV-09
MARTIN     26-NOV-09
BLAKE      26-NOV-09
CLARK      26-NOV-09
SCOTT      26-NOV-09
KING       26-NOV-09
TURNER     26-NOV-09
ADAMS      26-NOV-09
JAMES      26-NOV-09
FORD       26-NOV-09

MILLER     26-NOV-09

14 rows selected.

16:45:50 SQL>