IGC Purchasing Year End Exception Report- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- 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
Imported from BI Publisher
Purchasing Year End Exception Report
Purchasing Year End Exception Report
SQL 12 lines
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 |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV | |
| Process Phase | LOV Oracle | |
| Year | LOV Oracle | |
| Concurrent Request Id | Number |