PO Requisition Distribution Detail
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Requisitions Distribution Detail Report
Application: Purchasing
Source: Requisition Distribution Detail Report (XML)
Short Name: POXRQDDR_XML
DB package: PO_POXRQDDR_XMLP_PKG
Description: Requisitions Distribution Detail Report
Application: Purchasing
Source: Requisition Distribution Detail Report (XML)
Short Name: POXRQDDR_XML
DB package: PO_POXRQDDR_XMLP_PKG
Run
PO Requisition Distribution Detail and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT prh.segment1 Req_Number , trunc(prh.creation_date) Creation_Date , papf.full_name Preparer , prh.description Description , prh.requisition_header_id requisition_header_id_header FROM po_requisition_headers prh , per_all_people_f papf , po_system_parameters_all psp WHERE prh.preparer_id = papf.person_id AND papf.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) AND trunc(sysdate) between papf.effective_start_date and papf.effective_end_date AND decode(hr_security.view_all,'Y','TRUE',hr_security.show_record('PER_ALL_PEOPLE_F',papf.person_id,papf.person_type_id,papf.employee_number,papf.applicant_number ,papf.npw_number ))='TRUE' and decode(hr_general.get_xbg_profile,'Y',papf.business_group_id,hr_general.get_business_group_id)=papf.business_group_id AND trunc(prh.creation_date) BETWEEN nvl(:P_date_from,trunc(prh.creation_date) - 1) AND nvl(:P_date_to,trunc(prh.creation_date) + 1) &C_WHERE_REQ_NUM AND papf.full_name = nvl(:P_preparer, papf.full_name) AND prh.type_lookup_code in ('INTERNAL','PURCHASE') AND psp.ORG_ID = prh.ORG_ID AND EXISTS (SELECT 'requisition line exists' FROM po_req_distributions prd , po_requisition_lines prl , po_lookup_codes plc2 &from_failed_f WHERE prh.requisition_header_id = prl.requisition_header_id AND prl.requisition_line_id = prd.requisition_line_id AND prl.source_type_code = plc2.lookup_code &where_failed_f AND plc2.lookup_type = 'REQUISITION SOURCE TYPE') AND NVL(PRH.contractor_requisition_flag, 'N') <> 'Y' ORDER BY decode(psp.manual_req_num_type,'NUMERIC',decode(rtrim(prh.segment1,'0123456789'),NULL, to_number(prh.segment1),null)), decode(psp.manual_req_num_type,'ALPHANUMERIC',prh.segment1,null) |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV | |
Title |
|
Char | |
Requisition Numbers From |
|
LOV Oracle | |
To |
|
LOV Oracle | |
Requisition Creation Dates From |
|
Date | |
To 2 |
|
Date | |
Preparer |
|
LOV Oracle | |
Failed Funds Only |
|
LOV Oracle | |
Dynamic Precision Option |
|
LOV Oracle |