Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT

  ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number

FROM fusion.CST_INV_TRANSACTIONS cit,

  fusion.cst_cost_distribution_lines ccdl,

  fusion.cst_cost_distributions ccd,

  fusion.cst_transactions ct,

  fusion.pjc_exp_items_all ex,cst_all_cost_transactions_v cacat

WHERE cit.pjc_project_id = 300000009707820

and ex.project_id = cit.pjc_project_id

  AND ccd.transaction_id = ct.transaction_id

  AND cit.cst_inv_transaction_id = ct.cst_inv_transaction_id

  AND cit.pjc_project_iD IS NOT NULL

  and ccdl.distribution_id = ccd.distribution_id

  and ccdl.distribution_line_id = ex.original_dist_id

  and ccd.transaction_id = cacat.transaction_id