Requisitions Create and Update

Description
Upload to create and update requisitions.

In the generated Excel, the user can amend the following columns for an existing requisition.
- Header Description
- Quantity
- Unit Price
- Need By Date
- Reference Number
- Supplier Item
- Buyer
- Note To Buyer
- Currency
- Conversion Type
- Conversion Rate
- Conversion Date

Additionally, the user can cre ... 
Upload to create and update requisitions.

In the generated Excel, the user can amend the following columns for an existing requisition.
- Header Description
- Quantity
- Unit Price
- Need By Date
- Reference Number
- Supplier Item
- Buyer
- Note To Buyer
- Currency
- Conversion Type
- Conversion Rate
- Conversion Date

Additionally, the user can create a requisition by entering the below required fields.
- Line Type
- Item Description
- Category
- Unit of Measure
- Quantity
- Need By Date
- Destination Type
- Deliver To Requestor
- Destination Organization
- Deliver To Location
   more
Run Requisitions Create and Update and other Oracle EBS reports with Blitz Report™ on our demo environment
select
--process--
null processing_action,
null processing_status,
null processing_message,
null process_request_id,
to_char(null) row_id,
--header--
prh.requisition_header_id,
prh.segment1 requisition_number,
prh.description header_description,
prl.requisition_line_id,
prl.line_type,
prl.line_num,
msib.segment1 item,
prl.item_description,
prl.item_revision,
mcv.category_concat_segs category,
prl.unit_meas_lookup_code unit_of_measure,
prl.quantity,
prl.unit_price,
to_char(prl.need_by_date,'DD-Mon-YYYY') need_by_date,
prl.reference_num reference_number,
prl.destination_type_code destination_type,
prl.requestor deliver_to_requestor,
mp.organization_code destination_organization,
prl.deliver_to_location,
--source--
prl.suggested_vendor_name supplier,
prl.suggested_vendor_location supplier_site,
prl.suggested_vendor_contact supplier_contact,
prl.suggested_vendor_product_code supplier_item,
--source details--
prl.suggested_buyer buyer,
prl.note_to_agent note_to_buyer,
--currency--
prl.currency_code currency,
prl.rate_type conversion_type,
to_char(prl.rate_date,'DD-Mon-YYYY') conversion_date,
prl.rate conversion_rate,
--distribution accounts--
prd.distribution_id,
prd.distribution_num,
gcc.segment1 charge_account_segment1,
gcc.segment2 charge_account_segment2,
gcc.segment3 charge_account_segment3,
gcc.segment4 charge_account_segment4,
gcc.segment5 charge_account_segment5,
gcc.segment6 charge_account_segment6,
gcc.segment7 charge_account_segment7,
gcc.segment8 charge_account_segment8,
gcc.segment9 charge_account_segment9,
gcc.segment10 charge_account_segment10,
--distribution projects--
case when prd.project_accounting_context='Yes' then 'Y' when prd.project_accounting_context='No' then 'N' end  project_accounting,
ppv.segment1 project_number,
ptv.task_number,
prd.expenditure_type,
hou.name expenditure_organization,
to_char(prd.expenditure_item_date,'DD-Mon-YYYY') expenditure_item_date
from po_requisition_headers_v prh,
po_requisition_lines_v prl,
po_requisition_lines_all prla,
po_req_distributions_v prd,
mtl_categories_v mcv,
gl_code_combinations gcc,
pa_projects_all ppv,
pa_tasks_v ptv,
(select /*+ materialize */  hou.name,hou.organization_id from hr_organization_units hou) hou,
mtl_parameters mp,
mtl_system_items_b msib
where
1=1 and
prh.requisition_header_id=prl.requisition_header_id and
prl.requisition_line_id=prla.requisition_line_id and
prl.requisition_line_id=prd.requisition_line_id and
nvl(prla.transferred_to_oe_flag,'N')<>'Y' and
nvl(prh.closed_code,'!')<>'FINALLY CLOSED' and
prh.authorization_status not in ('CANCELLED','PRE-APPROVED','IN PROCESS','SYSTEM_SAVED')  and
not exists (
select
1
from
po_distributions_all pda,
po_req_distributions_all prda
where pda.req_distribution_id = prda.distribution_id and
prda.requisition_line_id = prl.requisition_line_id
) and
prl.item_id=msib.inventory_item_id(+) and
prl.dest_organization_id=msib.organization_id(+) and
prl.dest_organization_id=mp.organization_id(+) and
prl.category_id=mcv.category_id(+) and
--prl.item_id=micv.inventory_item_id(+) and 
--prl.dest_organization_id=micv.organization_id(+) and
--micv.category_set_name(+)='Purchasing' and
mcv.structure_name(+)='PO Item Category' and
prd.code_combination_id=gcc.code_combination_id(+) and
prd.project_id=ppv.project_id(+) and
prd.task_id=ptv.task_id(+) and
prd.expenditure_organization_id=hou.organization_id(+)
&not_use_first_block
&report_table_select &report_table_name &report_table_where_clause &success_records
&processed_run
order by 6,9,35
Parameter Name SQL text Validation
Requisition Number From
prh.segment1>=:requisition_number_from
LOV
Requisition Number To
prh.segment1<=:requisition_number_to
LOV
Creation Date From
prh.creation_date>=:creation_date_from
Date
Creation Date To
prh.creation_date<:creation_date_to+1
Date
Need By Date From
prl.need_by_date>=:need_by_date_from
Date
Need By Date To
prl.need_by_date<:need_by_date_to+1
Date
Requestor Name
prl.requestor=:requestor_name
LOV
Buyer Name
prl.suggested_buyer=:buyer
LOV
Created By
prh.created_by in (select user_id from fnd_user where user_name=:created_by)
LOV
Authorization Status
prh.authorization_status=:authorization_status
LOV
Blitz Report™