[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select cm_customer_trx_id into temp_customer_trx_id from ra_cm_requests where customer_trx_id = p_customer_trx_id
and request_id=x_request_id;
select count(*) into l_count_trx from
ra_customer_trx
where customer_trx_id = p_customer_trx_id;
SELECT ctt.allow_overapplication_flag, ctt.credit_memo_type_id
INTO l_allow_overapplication, l_credit_memo_type_id
FROM ra_cust_trx_types ctt,
ra_customer_trx ct
WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
AND ct.customer_trx_id = p_customer_trx_id;
SELECT SUM(NVL(amount_line_items_remaining,0)),
SUM(NVL(tax_remaining,0)),
SUM(NVL(freight_remaining,0)),
SUM(NVL(amount_line_items_original,0)),
SUM(NVL(tax_original,0))
INTO l_lines_remaining,
l_tax_remaining,
l_freight_remaining,
l_lines_original,
l_tax_original
FROM ar_payment_schedules ct
WHERE ct.customer_trx_id = p_customer_trx_id ;
SELECT
count(*)
INTO
l_count_reason_code
FROM
ar_lookups
WHERE lookup_type ='CREDIT_MEMO_REASON'
AND lookup_code = p_cm_reason_code ;
SELECT count(*)
INTO l_count_trx
FROM ra_customer_trx_lines
WHERE customer_trx_id = p_customer_trx_id
AND customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
SELECT NVL(extended_amount,0)
INTO l_extended_amount
FROM ra_customer_trx_lines
WHERE customer_trx_id = p_customer_trx_id
AND customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
SELECT NVL(extended_amount,0)
INTO l_credited_amount
FROM ra_customer_trx_lines
WHERE previous_customer_trx_id = p_customer_trx_id
AND previous_customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
SELECT trx_date INTO l_trx_date
FROM ra_customer_trx
WHERE customer_trx_id = p_customer_trx_id;
SELECT display_name
FROM wf_users
WHERE orig_system = 'PER'
AND orig_system_id = l_created_by;
SELECT display_name
FROM wf_users
WHERE orig_system = 'FND_USR'
AND orig_system_id = l_created_by;
SELECT customer_trx_line_id,
extended_amount,
quantity,
price
FROM ra_cm_request_lines_all
WHERE request_id = p_request_id;
SELECT to_char(ias.begin_date,'DD-MON-RR HH24:MI:SS') begin_date ,
ap.display_name||'/'||ac.display_name activity_name ,
ias.activity_status status,
ias.activity_result_code result_code,
ias.assigned_user -- user
FROM wf_item_activity_statuses ias,
wf_process_activities pa,
wf_activities_vl ac,
wf_activities_vl ap,
wf_items i
WHERE ias.item_type = 'ARCMREQ'
AND ias.item_key = p_request_id
AND ias.process_activity = pa.instance_id
AND pa.activity_name = ac.name
AND pa.activity_item_type = ac.item_type
AND pa.process_name = ap.name
AND pa.process_item_type = ap.item_type
AND i.item_key = ias.item_key
AND i.begin_date >=ac.begin_date
AND i.begin_date < nvl(ac.end_date, i.begin_date+1)
ORDER BY ias.begin_date,ias.execution_time;
SELECT text
FROM ar_notes
WHERE customer_trx_id = x_customer_trx_id;
SELECT customer_trx_id,
cm_customer_trx_id,
cm_reason_code,
nvl(line_amount,0),
nvl(tax_amount,0),
nvl(freight_amount,0),
line_credits_flag,
created_by,
creation_date,
approval_date,
comments
INTO x_customer_trx_id,
x_cm_customer_trx_id,
l_reason_code,
x_line_amount,
x_tax_amount,
x_freight_amount,
x_line_credits_flag,
l_created_by,
x_creation_date,
x_approval_date,
x_comments
FROM ra_cm_requests
WHERE request_id = p_request_id;
arp_util.debug ('get_request_status: ' || 'Selecting the meaning for the credit memo dispute from ar_lookups');
SELECT meaning
INTO x_reason_meaning
FROM ar_lookups
WHERE lookup_type='CREDIT_MEMO_REASON'
AND lookup_code = l_reason_code;
arp_util.debug ('get_request_status: ' || 'Selecting user information');
arp_util.debug ('get_request_status: ' || 'Selecting line details');
SELECT count(*)
INTO l_line_count
FROM ra_cm_request_lines
WHERE request_id = p_request_id;
SELECT count(*)
INTO l_count_activities
FROM wf_item_activity_statuses ias,
wf_process_activities pa,
wf_activities_vl ac,
wf_activities_vl ap,
wf_items i
WHERE ias.item_type = 'ARCMREQ'
AND ias.item_key = p_request_id
AND ias.process_activity = pa.instance_id
AND pa.activity_name = ac.name
AND pa.activity_item_type = ac.item_type
AND pa.process_name = ap.name
AND pa.process_item_type = ap.item_type
AND i.item_key = ias.item_key
AND i.begin_date >=ac.begin_date
AND i.begin_date < nvl(ac.end_date, i.begin_date+1);
SELECT count(*)
INTO l_count_notes
FROM ar_notes
WHERE customer_trx_id = x_customer_trx_id;
SELECT 'Y' INTO l_trx_no_err
FROM ra_batch_sources b
WHERE b.name = p_batch_source_name
AND ((p_trx_number IS NULL AND
NVL(b.auto_trx_numbering_flag,'N') = 'N')
OR (p_trx_number IS NOT NULL AND
b.auto_trx_numbering_flag = 'Y'));
select * into l_ct_trx from
ra_customer_trx
where customer_trx_id = p_customer_trx_id;
SELECT NVL(COPY_INV_TIDFF_TO_CM_FLAG,'N') into l_copy_inv_tidff_flag
FROM ra_batch_sources where name=p_batch_source_name;
SELECT NVL(COPY_INV_TIDFF_TO_CM_FLAG,'N') into l_copy_inv_tidff_flag
FROM ra_batch_sources where batch_source_id=l_ct_trx.batch_source_id;
SELECT 'Y'
FROM fnd_descriptive_flexs
WHERE application_id = 222
and descriptive_flexfield_name = p_desc_flex_name;
SELECT 'Y'
FROM fnd_descriptive_flexs
WHERE application_id = 222
and descriptive_flexfield_name = p_desc_flex_name;