BI Publisher (MOSC)

MOSC Banner

Query to get Requisition Approval Amount

edited Oct 24, 2023 12:41PM in BI Publisher (MOSC) 1 commentAnswered

We need to build a customer report to get the Requisition Amount and Approval Amount.

select

prha.requisition_number

,sum(prla.amount) "Requistion Amount"

,NULL "Approval Amount"

from

from por_requisition_headers_all prha

,por_requisition_lines_all prla


where 1=1

AND prha.requisition_header_id = prla.requisition_header_id


GROUP BY

prha.requisition_number


We're not able to find the column/table to get requisition approval amount.

How we can get the requisition approval amount ?


Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center