Get Expenditure item date from back end tables
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
0