[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT nvl(sum(nonrecoverable_tax), 0)
INTO l_tax_amt
FROM po_requisition_lines rl,
po_req_distributions_all rd --
WHERE rl.requisition_header_id = l_document_id
AND rd.requisition_line_id = rl.requisition_line_id;
SELECT nvl(sum(nonrecoverable_tax), 0)
INTO l_tax_amt
FROM po_requisition_lines rl,
po_req_distributions_all rd --
WHERE rl.requisition_header_id = l_document_id
AND rd.requisition_line_id = rl.requisition_line_id;
SELECT nvl(sum(nonrecoverable_tax), 0)
INTO l_tax_amt
FROM po_requisition_lines rl,
po_req_distributions_all rd --
WHERE rl.requisition_header_id = l_document_id
AND rd.requisition_line_id = rl.requisition_line_id;
SELECT nvl(sum(nonrecoverable_tax), 0)
INTO l_tax_amt
FROM po_requisition_lines rl,
po_req_distributions_all rd --
WHERE rl.requisition_header_id = l_document_id
AND rd.requisition_line_id = rl.requisition_line_id;
SELECT rql.line_num,
msi.concatenated_segments,
rql.item_revision,
rql.item_description,
rql.unit_meas_lookup_code,
rql.quantity,
rql.unit_price,
rql.quantity * rql.unit_price,
rql.need_by_date,
hrt.location_code,
per.full_name,
rql.suggested_vendor_name,
rql.suggested_vendor_location
FROM po_requisition_lines rql,
mtl_system_items_kfv msi,
hr_locations hrt,
per_people_f per
WHERE rql.requisition_header_id = v_document_id
AND hrt.location_id (+) = rql.deliver_to_location_id
AND rql.item_id = msi.inventory_item_id(+)
AND nvl(msi.organization_id, rql.destination_organization_id) =
rql.destination_organization_id
AND rql.to_person_id = per.person_id(+)
AND per.effective_start_date(+) <= trunc(sysdate)
AND per.effective_end_date(+) >= trunc(sysdate)
ORDER BY rql.line_num;
SELECT poh.SEQUENCE_NUM,
per.FULL_NAME,
polc.DISPLAYED_FIELD,
poh.ACTION_DATE,
poh.NOTE,
poh.OBJECT_REVISION_NUM
from po_action_history poh,
per_people_f per,
po_lookup_codes polc
where OBJECT_TYPE_CODE = v_object_type
and poh.action_code = polc.lookup_code
and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')
and per.person_id = poh.employee_id
and trunc(sysdate) between per.effective_start_date
and per.effective_end_date
and OBJECT_ID = v_document_id
UNION ALL
SELECT poh.SEQUENCE_NUM,
per.FULL_NAME,
NULL,
poh.ACTION_DATE,
poh.NOTE,
poh.OBJECT_REVISION_NUM
from po_action_history poh,
per_people_f per
where OBJECT_TYPE_CODE = 'REQUISITION'
and poh.action_code is null
and per.person_id = poh.employee_id
and trunc(sysdate) between per.effective_start_date
and per.effective_end_date
and OBJECT_ID = v_document_id
order by 1 desc;