[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT header.trx_header_id
, lines.trx_line_id
, lines.customer_trx_id
, header.cust_trx_type_id
, header.trx_date
, lines.vat_tax_id
, lines.line_type
FROM
ar_trx_lines_gt lines,
ar_trx_header_gt header,
ra_batch_sources_all rbs
WHERE
lines.request_id = c_request_id
AND lines.customer_trx_id IS NOT NULL
AND header.trx_header_id = lines.trx_header_id
AND header.batch_source_id = rbs.batch_source_id
ORDER BY header.trx_date;
SELECT TO_NUMBER(cr.argument3)
INTO l_batch_source_id
FROM fnd_concurrent_requests cr
WHERE request_id = p_request_id;
SELECT distinct
lines.trx_line_id,
lines.customer_trx_id,
header.cust_trx_type_id,
header.trx_date,
fnd_date.canonical_to_date(types.global_attribute2) last_issued_date,
to_number(types.global_attribute3) advance_days,
lines.vat_tax_id,
lines.line_type
FROM ar_trx_lines_gt lines,
ar_trx_header_gt header,
ra_batch_sources_all rbs,
ra_cust_trx_types types
WHERE lines.request_id = c_request_id
AND header.trx_header_id = lines.trx_header_id
AND header.batch_source_id = rbs.batch_source_id
AND header.cust_trx_type_id = types.cust_trx_type_id
AND nvl(types.global_attribute1, 'N') = 'Y';
validation3 := ja_zz_validate_invoice_gdf.update_last_issued_date(
t_interface_line_tbl1.customer_trx_id(l_index1),
t_interface_line_tbl1.cust_trx_type_id(l_index1),
t_interface_line_tbl1.trx_date(l_index1),
'RAXTRX');