DECLARE 

CURSOR C1 IS 

 	SELECT ORD_DET.ASSIGN_TO,BRANCH.BRANCH_DESC,CUSTOMER.NAME,CATAG.CAT_NAME,
				ORD_DET.REP_NAME, MAST.INQ_DATE,ORD_DET.REP_CONT,ORD_DET.INQ_NO,INQ_ORD_CODE 
				 
				FROM CUSTOMER , MAST , ORD_DET,BRANCH,CATAG
				WHERE CUSTOMER.CODE = MAST.CUST_ID
				AND ORD_DET.INQ_NO = MAST.INQ_NO
				AND BRANCH.CODE=ORD_DET.ASSIGN_TO
				AND CATAG.CAT_CODE=ORD_DET.P_ID
				AND INQ_DATE  <=SYSDATE -1
				AND ORD_DET.STATUS IN ('OPERATION')
			  ---	AND ORD_DET.ASSIGN_TO in ('124','23')
			---- 	AND (ORD_DET.INQ_NO='113553' or ORD_DET.INQ_NO='342136')
				AND P_ID IN (	'013','054','049','018','057','089')
				ORDER BY ORD_DET.ASSIGN_TO,CUSTOMER.NAME,INQ_DATE,CATAG.CAT_NAME;
  l_html long ;

BEGIN
  For M in Inq_Pending
  Loop
    l_html := l_html||'<tr bgcolor="#BED8F7">'||'<TD>'||M.Inq_no||'</TD><TD>'||M.INQ_ORD_CODE||
              '</TD><TD>'||M.inq_date||'</TD><TD>'||M.Name||'</TD ><TD>'||M.Cat_Name||
              '</TD><TD>'||M.REP_NAME||'</TD>'||'<TD>'||M.REP_CONT||'</TD>';
  END LOOP;