Project

General

Profile

Script_Select.txt

Luc Tran Van, 11/01/2022 12:56 PM

 
1
select * from TR_REQ_PAYMENT WHERE REQ_PAY_CODE = ''
2

    
3
select * from TR_REQ_ADVANCE_DT WHERE REQ_PAY_ID = ''
4
select * from TR_REQ_PAY_PERIOD WHERE REQ_PAY_ID = ''
5
select * from TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID = ''
6
select * from TR_REQ_PAYMENT_DT WHERE PAY_ID = ''
7
select * from TR_REQ_PAY_METHOD WHERE REQ_PAY_ID = ''
8
select * from TR_REQ_PAY_ATTACH WHERE REQ_PAY_ID = ''
9
select * from TR_REQ_PAY_INVOICE WHERE REQ_PAY_ID = ''
10
select * from TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID = ''
11
select * from TR_REQ_PAY_SERVICE WHERE REQ_PAY_ID = ''
12
select * from TR_REQ_PAY_JOB WHERE REQ_PAY_ID = ''
13
select * from TR_REQ_PAY_JOB_DT WHERE REQ_PAY_ID = ''
14
select * from TR_REQ_PAY_DRIVE WHERE REQ_PAY_ID = ''
15
select * from TR_REQ_PAY_DRIVE_DT WHERE REQ_PAY_ID = ''
16
select * from PL_PROCESS WHERE REQ_ID = ''
17
select * from TR_REQ_ADVANCE_DT WHERE REQ_PAY_ID = ''
18
select * from TR_REQ_ADVANCE_DT WHERE REQ_PAY_ID = ''