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
