Task #394
BCA-DDA-UAT-C006
Status: | Closed - End of life cycle | Start date: | August 16, 2010 | |
---|---|---|---|---|
Priority: | Normal | Due date: | August 25, 2010 | |
Assignee: | Siti Norahayu Mohd Desa | % Done: | 100% | |
Category: | - | Spent time: | 8.00 hours | |
Target version: | - |
Description
IB Ref # 5530 Accepted but not reflected in Application Enquiry screen.
History
#1 Updated by Chang Grace about 14 years ago
- Due date set to August 18, 2010
- Assignee set to Siti Norahayu Mohd Desa
Currently is using SQL below to retrieve remittance application enquiry:
SELECT DISTINCT TBL_A.TRNX_ID, TBL_A.CREATION_DATE, TBL_A.TRNX_TYPE, TBL_A.FROM_ACCOUNT_NO, TBL_A.FROM_CURRENCY, TBL_A.AMOUNT, TBL_A.STATUS FROM IB_TRANSACTION_HISTORY TBL_A, IB_BANKERS_CHEQUE TBL_B, IB_DEMAND_DRAFT TBL_C WHERE TBL_A.USER_ID = 382 AND (TBL_A.TRNX_ID = TBL_B.TRNX_ID OR TBL_A.TRNX_ID = TBL_C.TRNX_ID) AND trunc(TBL_A.CREATION_DATE) > trunc(sysdate - 30)
There is 1 record in IB_BANKERS_CHEQUE table, but no records returned.
Please fix it.
#2 Updated by Chang Grace about 14 years ago
what is the status? Due date suppose is last Wednesday (18/08/2010).
#3 Updated by Chang Grace about 14 years ago
- Due date changed from August 18, 2010 to August 25, 2010
#4 Updated by Siti Norahayu Mohd Desa about 14 years ago
- Status changed from New - Begin Life Cycle to Work Completed-End life cycle
- % Done changed from 0 to 100
Fixed the application enquiry records. data will appear even one of the table is empty
#5 Updated by Latipah Abdul Rashid almost 14 years ago
- Status changed from Work Completed-End life cycle to Closed - End of life cycle
Issue closed by Chooi So Fun on 30.08.10