IGC Purchasing Year End Exception - draft

Description
Categories: BI Publisher, Financials
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
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
ORG_ID
 
SOB ID
 
Concurrent Request Id
 
Number
Year
 
LOV Oracle
Process Phase
 
LOV Oracle