IGC Purchasing Year End Exception Report- Not Supported: Reserved For Future Use

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Purchasing Year End Exception Report
Application: Contract Commitment
Source: Purchasing Year End Exception Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGCPOYEE_XML
DB package: IGC_IGCPOYEE_XMLP_PKG
Run IGC Purchasing Year End Exception Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT PROC.document_type document_type,
PROC.document_number document_number,
PROC.release_num release_num,
PROC.line_num line_num,
PROC.shipment_num shipment_num,
PROC.distribution_num distribution_num,
PROC.exception_reason exception_reason
FROM IGC_CBC_PO_PROCESS_EXCEPTION_V PROC
WHERE PROC.conc_request_id = :P_REQUEST_ID
AND PROC.process_phase = :P_PROCESS_PHASE
ORDER BY 1,2,3,4,5,6,7
Parameter Name SQL text Validation
Operating Unit
 
LOV
Process Phase
 
LOV Oracle
Year
 
LOV Oracle
Concurrent Request Id
 
Number