hi guys
I have an applicaation in which govt sector dept user sent file
to another user...
eg. home dept user sent 1 file to defence dept user.
and there is facility that defence user will receive that file by
going to particular page..
if user didnt receive file sent by other user than that will be called as pending file.i have to display that list of pending file of each user .
my query output should be:
Filename , subject, office name, Diaryno,diapatch date
structure of table are as follows:
FILEMASTER:
DEPARTMENT_CODE VARCHAR2(20 BYTE)
SECTION_CODE VARCHAR2(20 BYTE)
FILE_SERIAL_NO VARCHAR2(10 BYTE)
FILE_YEAR VARCHAR2(4 BYTE)
FILE_SUBJECT VARCHAR2(400 BYTE)
CREATION_DATE DATE
OTHER_DETAILS VARCHAR2(80 BYTE)
USER_CODE ...
Go to the complete details ...