In this article we will see how to get project billing event details in Oracle Fusion, PJB_BILLING_EVENTS is a table that records events that are assigned to a task and generate revenue and/or billing activities that are not directly related to the cost and revenue generated by expenditure items.
Query to get Project Billing Event details in Oracle Fusion
where contract_id in (select id
where contract_number = :P_Contract_Num)
and organization_id= :P_Org_Id
and BILLING_TYPE_CODE =’EX’
and project_id = :P_Project_id ;