You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Get Expenditure item date from back end tables

Received Response
24
Views
1
Comments
edited Jan 22, 2024 12:15PM in Project Management 1 comment

Summary:

Please advise how we can get Expenditure Item Date and Expenditure Type from back end tables.



I have below query as of now it is giving result based on SYSDATE. Want to modify the query to get the result based on Expenditure Item Date

WITH cost_multiplier AS (

 SELECT 

  pj.project_id,

  pj.carrying_out_organization_id,

  pcm.ind_cost_code AS EXP_TYPE,

  pcs.ind_compiled_set_id,

  pcm.MULTIPLIER_NUM AS MULTIPLIER_NUM,

  pir.IND_RATE_SCH_REVISION_ID

 FROM 

  PJF_PROJECTS_ALL_B pj

  JOIN pjf_ind_rate_sch_b pis ON pj.COST_IND_RATE_SCH_ID = pis.IND_RATE_SCH_ID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!