[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select dtha.transaction_header_id
, dtha.transaction_number
, dtha.ref_document_number
, asp.vendor_name
, assa.vendor_site_code
, dtha.vendor_contact_name SUP_CONTACT_name
, creator.source_first_name || ' ' || creator.source_last_name creator_name
, lkup.meaning
, dtha.creation_date
, dtha.trx_currency
, dtha.contact_phone
, dtha.contact_email_address
, dtha.effective_start_date
, dtha.days_covered,
dtha.transaction_status
from dpp_transaction_headers_all dtha
, ap_suppliers asp
, jtf_rs_resource_extns creator
, dpp_lookups lkup
, ap_supplier_sites_all assa
where dtha.transaction_header_id = pc_header_id
and dtha.vendor_id = asp.vendor_id
and asp.vendor_id = assa.vendor_id
and assa.vendor_site_id = dtha.vendor_site_id
and assa.org_id = dtha.org_id
and dtha.last_updated_by = creator.resource_id (+)
and dtha.transaction_status = lkup.lookup_code
and lkup.lookup_type = 'DPP_TRANSACTION_STATUSES';
select notes_detail
from jtf_notes_vl
where source_object_code = pc_entity_type
AND SOURCE_OBJECT_ID = pc_transaction_header_id
AND NOTE_STATUS in ('E' , 'I') -- only publish notes and also Public
ORDER BY CREATION_DATE DESC;
SELECT res.source_first_name || ' '|| res.source_last_name
FROM jtf_rs_resource_extns res, dpp_approval_access dac
where res.user_id = dac.approver_id
and dac.object_type = pc_entity_type
and dac.object_id = pc_transaction_header_id
and dac.approval_access_id = ( select max(approval_access_id)
from dpp_approval_access
where dac.object_type = pc_entity_type
and dac.object_id = pc_transaction_header_id );
select media_type_name from
ams_media_vl
where media_id = pc_media_id;
select function_id from fnd_form_functions where function_name = pc_func_name ;