[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select l.po_header_id into l_po_header_id from po_lines_all l where l.po_line_id = p_po_line_id;
select s.po_header_id into l_po_header_id from po_line_locations_all s where s.Line_Location_id = p_po_line_location_id;
select d.po_header_id into l_po_header_id from po_distributions_all d where d.po_distribution_id = p_po_distribution_id;
SELECT 'Y'
INTO l_is_clm_po
FROM po_headers_all h,
po_doc_style_headers pdsh
WHERE h.po_header_id = l_po_header_id
AND h.style_id = pdsh.style_id
AND NVL(pdsh.clm_flag,'N') = 'Y';
SELECT pod.distribution_type,
pll.matching_basis,
pod.accrue_on_receipt_flag,
pod.code_combination_id,
pod.budget_account_id,
pod.partial_funded_flag,
pl.unit_meas_lookup_code,
pod.funded_value,
pod.quantity_funded,
pod.amount_funded,
pll.quantity_received,
pll.amount_received,
pod.quantity_delivered,
pod.amount_delivered,
pod.quantity_billed,
pod.amount_billed,
pod.quantity_cancelled,
pod.amount_cancelled
INTO x_distribution_type,x_matching_basis,x_accrue_on_receipt_flag,x_code_combination_id,
x_budget_account_id,x_partial_funded_flag,x_unit_meas_lookup_code,x_funded_value,
x_quantity_funded,x_amount_funded,x_quantity_received,x_amount_received,
x_quantity_delivered,x_amount_delivered,x_quantity_billed,x_amount_billed,
x_quantity_cancelled, x_amount_cancelled
FROM po_distributions_all pod,
po_line_locations_all pll,
po_lines_all pl
WHERE pll.line_location_id = pod.line_location_id
AND pod.po_distribution_id = p_po_distribution_id
AND pl.po_line_id = pod.po_line_id;
SELECT Sum(pod.funded_value),
Sum(pod.quantity_funded),
Sum(pod.amount_funded),
Sum(pod.quantity_delivered),
Sum(pod.amount_delivered),
Sum(pod.quantity_billed),
Sum(pod.amount_billed),
Min(pod.distribution_type),
Max(pod.distribution_type),
Min(pod.accrue_on_receipt_flag),
Max(pod.accrue_on_receipt_flag),
Min(pod.code_combination_id),
Max(pod.code_combination_id),
Min(pod.budget_account_id),
Max(pod.budget_account_id),
Min(pod.partial_funded_flag),
MAx(pod.partial_funded_flag),
Sum(pod.quantity_cancelled),
Sum(pod.amount_cancelled)
INTO x_funded_value,x_quantity_funded,x_amount_funded,x_quantity_delivered,
x_amount_delivered,x_quantity_billed,x_amount_billed,
l_min_distribution_type,l_max_distribution_type,
l_min_accrue_on_receipt_flag,l_max_accrue_on_receipt_flag,
l_min_code_combination_id,l_max_code_combination_id,
l_min_budget_account_id,l_max_budget_account_id,
l_min_partial_funded_flag,l_max_partial_funded_flag,
x_quantity_cancelled,x_amount_cancelled
FROM po_distributions_all pod
WHERE pod.line_location_id = p_line_location_id;
SELECT pll.unit_meas_lookup_code,
pll.matching_basis,
pll.quantity_received,
pll.amount_received
INTO x_unit_meas_lookup_code,x_matching_basis,x_quantity_received,x_amount_received
FROM po_line_locations_all pll
WHERE pll.line_location_id = p_line_location_id;
SELECT Sum(pod.funded_value),
Sum(pod.quantity_funded),
Sum(pod.amount_funded),
Sum(pod.quantity_delivered),
Sum(pod.amount_delivered),
Sum(pod.quantity_billed),
Sum(pod.amount_billed),
Min(pod.distribution_type),
Max(pod.distribution_type),
Min(pod.accrue_on_receipt_flag),
Max(pod.accrue_on_receipt_flag),
Min(pod.code_combination_id),
Max(pod.code_combination_id),
Min(pod.budget_account_id),
Max(pod.budget_account_id),
Min(pod.partial_funded_flag),
Max(pod.partial_funded_flag)
INTO x_funded_value,x_quantity_funded,x_amount_funded,x_quantity_delivered,
x_amount_delivered,x_quantity_billed,x_amount_billed,
l_min_distribution_type,l_max_distribution_type,
l_min_accrue_on_receipt_flag,l_max_accrue_on_receipt_flag,
l_min_code_combination_id,l_max_code_combination_id,
l_min_budget_account_id,l_max_budget_account_id,
l_min_partial_funded_flag,l_max_partial_funded_flag
FROM po_distributions_all pod
WHERE pod.po_line_id = p_po_line_id;
SELECT Sum(pll.quantity_received),
Sum(pll.amount_received),
Min(pll.unit_meas_lookup_code),
Max(pll.unit_meas_lookup_code),
Min(pll.matching_basis),
Max(pll.matching_basis)
INTO x_quantity_received,x_amount_received,
l_min_unit_meas_lookup_code,l_max_unit_meas_lookup_code,
l_min_matching_basis,l_max_matching_basis
FROM po_line_locations_all pll
WHERE pll.po_line_id = p_po_line_id;
SELECT Sum(pod.funded_value),
Sum(pod.quantity_funded),
Sum(pod.amount_funded),
Sum(pod.quantity_delivered),
Sum(pod.amount_delivered),
Sum(pod.quantity_billed),
Sum(pod.amount_billed),
Min(pod.distribution_type),
Max(pod.distribution_type),
Min(pod.accrue_on_receipt_flag),
Max(pod.accrue_on_receipt_flag),
Min(pod.code_combination_id),
Max(pod.code_combination_id),
Min(pod.budget_account_id),
Max(pod.budget_account_id),
Min(pod.partial_funded_flag),
Max(pod.partial_funded_flag)
INTO x_funded_value,x_quantity_funded,x_amount_funded,x_quantity_delivered,
x_amount_delivered,x_quantity_billed,x_amount_billed,
l_min_distribution_type,l_max_distribution_type,
l_min_accrue_on_receipt_flag,l_max_accrue_on_receipt_flag,
l_min_code_combination_id,l_max_code_combination_id,
l_min_budget_account_id,l_max_budget_account_id,
l_min_partial_funded_flag,l_max_partial_funded_flag
FROM po_distributions_all pod
WHERE pod.po_header_id = p_po_header_id;
SELECT Sum(pll.quantity_received),
Sum(pll.amount_received),
Min(pll.unit_meas_lookup_code),
Max(pll.unit_meas_lookup_code),
Min(pll.matching_basis),
Max(pll.matching_basis)
INTO x_quantity_received,x_amount_received,
l_min_unit_meas_lookup_code,l_max_unit_meas_lookup_code,
l_min_matching_basis,l_max_matching_basis
FROM po_line_locations_all pll
WHERE pll.po_header_id = p_po_header_id;
SELECT NVL(d.funded_value,0)
INTO l_funded
FROM po_req_distributions_all d
WHERE d.distribution_id = p_distribution_id;
SELECT SUM(NVL(d.funded_value,0))
INTO l_funded
FROM po_req_distributions_all d
WHERE d.requisition_line_id = p_line_id;
SELECT SUM(NVL(d.funded_value,0))
INTO l_funded
FROM po_req_distributions_all d,
po_requisition_lines_all l
WHERE d.requisition_line_id = l.requisition_line_id
AND l.requisition_header_id = p_header_id;
SELECT NVL(d.funded_value,0)
INTO l_funded
FROM po_distributions_all d
WHERE d.po_distribution_id = p_distribution_id;
SELECT 1
INTO l_nsp_nc_line
FROM po_lines_all l,
po_distributions_all d
WHERE l.po_line_id = d.po_line_id AND
l.cost_constraint IN ('NSP', 'NC') AND
d.po_distribution_id = p_distribution_id;
SELECT SUM(NVL(d.funded_value,0))
INTO l_funded
FROM po_distributions_all d
WHERE d.line_location_id = p_line_location_id;
SELECT 1
INTO l_nsp_nc_line
FROM po_lines_all l,
po_line_locations_all ll
WHERE l.po_line_id = ll.po_line_id AND
l.cost_constraint IN ('NSP', 'NC') AND
ll.line_location_id = p_line_location_id;
SELECT SUM(NVL(d.funded_value,0))
INTO l_funded
FROM po_distributions_all d
WHERE d.po_line_id = p_line_id;
SELECT 1
INTO l_nsp_nc_line
FROM po_lines_all l
WHERE l.po_line_id = p_line_id AND
l.cost_constraint IN ('NSP', 'NC');
SELECT SUM(NVL(d.funded_value,0))
INTO l_funded
FROM po_distributions_all d
WHERE d.po_header_id = p_header_id;
SELECT 'Y'
INTO l_clm_document
FROM po_requisition_headers_all
WHERE requisition_header_id = p_document_id
AND federal_flag = 'Y';
SELECT 'Y'
INTO l_clm_document
FROM po_headers_all h,
po_doc_style_headers pdsh
WHERE h.po_header_id = p_document_id
AND h.style_id = pdsh.style_id
AND NVL(pdsh.clm_flag,'N') = 'Y';