SELECT   APEX_ITEM.CHECKBOX2 (p_idx=>1,p_value=>rownum, p_attributes=>'UNCHECKED')
      || apex_item.hidden  (p_idx=>2,p_value=>rownum)
      || apex_item.hidden  (p_idx=>3,p_value=>A.TEMP_ADV_ACC_REG_BOOK_ID) as CHECKBOX, 
        A.TEMP_ADV_ACC_REG_BOOK_ID,
    	D.BANK_NAME,
        E.BRANCH_NAME,
        C.ACC_NO,
        C.ROUTING_NO,
        C.EMP_NAME,
        A.TOTAL_PAY_AMOUNT,
        C.MOBILE_NO,
        A.REMARKS,
        A.ZONE_ID,
        B.NAME_ENG BRANCH,
        C.BANK_ID,
        C.BANK_BRANCH_ID,
        TO_CHAR(A.CREATED_ON,'DD-MON-YYYY')
   FROM TEMP_ADV_ACC_REG_BOOK A, BRANCHS B, TEMP_ADV_ACC_DTL C, BANK_INFO D, BANK_BRANCH_INFO E, TEMP_ADV_MST F 
  WHERE A.ZONE_ID       = B.ID(+)
  AND   A.MOBILE_ALLOW_MST_ID   = F.MOBILE_ALLOW_MST_ID(+)
  AND   F.MOBILE_ALLOW_MST_ID    = C.MOBILE_ALLOW_ACC_MST_ID
  AND   C.BANK_ID  = D.BANK_ID(+)
  AND   D.BANK_ID       = E.BANK_ID(+)
  AND   C.BANK_BRANCH_ID = E.BANK_BRANCH_ID
  AND   A.TEMP_ADV_ACC_REG_BOOK_ID NOT IN (SELECT TEMP_ADV_ACC_REG_BOOK_ID FROM TEMP_ADV_ACC_REG_BOOK)
  ORDER BY F.CREATED_ON DESC