PO Internal Requisitions/Deliveries Discrepancy

Description

Categories
Enginatics
Application
Purchasing
Source
Internal Requisitions/Deliveries Discrepancy Report (XML)
Short Name
POXRQSDD_XML
Repository
GitHub
Internal Requisitions/Deliveries Discrepancy Report

SQL 104 lines

Parameters 8

ParameterTypeList of values SQL
Operating UnitLOV
hou.name=:p_operating_unit
Requisition Number FromLOV
prha.segment1>=:p_req_number_from
Requisition Number ToLOV
prha.segment1<=:p_req_number_to
RequesterLOV Oracle
papf.full_name=:p_requestor
Requisition Date FromDate
prla.creation_date>=:p_creation_date_from
Requisition Date ToDate
prla.creation_date<:p_creation_date_to+1
Destination OrganizationLOV
prla.destination_organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:ship_from_warehouse)
Sort ByLOV Oracle