[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select trx_type_code ,
allow_invoicing_flag ,
enabled_flag
from FUN_TRX_TYPES_VL
where trx_type_id = p_trx_type_id;
select trx_type_id ,
allow_invoicing_flag ,
enabled_flag
from FUN_TRX_TYPES_VL
where trx_type_code = p_trx_type_code;
select manual_approve_flag
from FUN_TRX_TYPES_VL
where trx_type_id = p_trx_type_id;
SELECT INIT_AMOUNT_DR, INIT_AMOUNT_CR
FROM fun_trx_headers
WHERE TRX_ID = p_trx_id;
SELECT m.memo_line_id,
m.name,
ar.cust_trx_type_id,
ar.name ,
Nvl(ar.default_term, 4)
FROM FUN_TRX_TYPE_AR_MAPS tm,
RA_CUST_TRX_TYPES_ALL ar,
AR_MEMO_LINES_ALL_VL m
WHERE tm.trx_type_id = p_trx_type_id AND
tm.org_id = p_org_id AND
tm.ar_trx_type_id = ar.cust_trx_type_id AND
tm.memo_line_id = m.memo_line_id AND
tm.org_id = m.org_id AND
ar.org_id = m.org_id AND
p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date) AND
p_trx_date BETWEEN Nvl(m.start_date, p_trx_date) AND Nvl(m.end_date, p_trx_date);
SELECT m.memo_line_id,
m.name,
ar.cust_trx_type_id,
ar.name ,
null default_term_id
FROM FUN_TRX_TYPE_AR_MAPS tm,
RA_CUST_TRX_TYPES_ALL ar,
AR_MEMO_LINES_ALL_VL m
WHERE tm.trx_type_id = p_trx_type_id AND
tm.org_id = p_org_id AND
tm.ar_cm_trx_type_id = ar.cust_trx_type_id AND
tm.memo_line_id = m.memo_line_id AND
tm.org_id = m.org_id AND
ar.org_id = m.org_id AND
p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date) AND
p_trx_date BETWEEN Nvl(m.start_date, p_trx_date) AND Nvl(m.end_date, p_trx_date);
SELECT m.memo_line_id,
m.name,
ar.cust_trx_type_id,
ar.name,
4 default_term_id
FROM fun_system_options fun,
RA_CUST_TRX_TYPES_ALL ar,
AR_MEMO_LINES_ALL_VL m
WHERE fun.default_memo_line_id = m.memo_line_id
AND fun.default_ar_trx_type_id = ar.cust_trx_type_id
AND ar.org_id = m.org_id
AND ar.org_id = p_org_id
AND p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date)
AND p_trx_date BETWEEN Nvl(m.start_date, p_trx_date) AND Nvl(m.end_date, p_trx_date);
SELECT m.memo_line_id,
m.name,
ar.cust_trx_type_id,
ar.name,
null default_term_id
FROM fun_system_options fun,
RA_CUST_TRX_TYPES_ALL ar,
AR_MEMO_LINES_ALL_VL m
WHERE fun.default_memo_line_id = m.memo_line_id
AND fun.default_cm_trx_type_id = ar.cust_trx_type_id
AND ar.org_id = m.org_id
AND ar.org_id = p_org_id
AND p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date)
AND p_trx_date BETWEEN Nvl(m.start_date, p_trx_date) AND Nvl(m.end_date, p_trx_date);
SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
FROM FUN_TRX_TYPE_AR_MAPS tm,
RA_CUST_TRX_TYPES_ALL ar
WHERE tm.trx_type_id = p_trx_type_id AND
tm.org_id = p_org_id AND
tm.org_id = ar.org_id AND
tm.ar_trx_type_id = ar.cust_trx_type_id AND
p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date);
SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
FROM FUN_TRX_TYPE_AR_MAPS tm,
RA_CUST_TRX_TYPES_ALL ar
WHERE tm.trx_type_id = p_trx_type_id AND
tm.org_id = p_org_id AND
tm.org_id = ar.org_id AND
tm.ar_cm_trx_type_id = ar.cust_trx_type_id AND
p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date);
SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
FROM fun_system_options fun,
RA_CUST_TRX_TYPES_ALL ar
WHERE fun.default_ar_trx_type_id = ar.cust_trx_type_id
AND ar.org_id = p_org_id
AND p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date);
SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
FROM fun_system_options fun,
RA_CUST_TRX_TYPES_ALL ar
WHERE fun.default_cm_trx_type_id = ar.cust_trx_type_id
AND ar.org_id = p_org_id
AND p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date);