PJC Expenditure Item PJC_EXP_ITEMS_ALL To Its Source

SELECT
	cit.*
	/*3-22834429151*/
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
WHERE
	cit.pjc_project_id               = 1234
	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
-- To Link the PJC with Costing tables you can follow the below steps .
-- for Misc Receipts:
select *
from
	fusion.cst_inv_transactions
where
	EXTERNAL_SYSTEM_REF_ID=
select *
from
	fusion.cst_transactions
where
	CST_INV_TRANSACTION_ID=
select *
from
	fusion.cst_cost_distributions
where
	TRANSACTION_ID in ()
select *
from
	fusion.cst_cost_distribution_lines
where
	DISTRIBUTION_ID in ()
-- and for transfer Order Receipts :
SELECT DISTINCT
	/*req.requisition_number ,
	req.line_group ,
	trf_ord.header_number "Transfer_order_num",
	itrh.request_number "Move Order" ,
	wshd.subinventory ,
	itrl.from_subinventory_code ,
	itrl.to_subinventory_code ,
	pickslip.pick_slip_number ,
	pickslip.delivery_number shipment ,
	*/
	   (
		   SELECT
			   element_number
		   FROM
			   fusion.pjf_proj_elements_b
		   WHERE
			   proj_element_id = ex.task_id
	)
	"Task_number"
  , ex.expenditure_item_id
  , invtxn.transaction_id
  , ex.DOC_REF_ID5
FROM
	/*3-22834429151*/
	fusion.por_requisition_headers_all req
  , fusion.por_requisition_lines_all   reqlin
  , fusion.inv_transfer_order_headers  trf_ord
  , fusion.inv_transfer_order_lines    trf_ord_lin
  , fusion.wsh_delivery_details        wshd
  , fusion.inv_txn_request_lines       itrl
  , fusion.inv_txn_request_headers     itrh
  , fusion.inv_pick_slip_lines_v       pickslip
  , fusion.inv_material_txns           invtxn
  , fusion.cst_inv_transactions        csttxn
  ,
	 -- fusion.cst_transactions ct,
	 fusion.cmr_rcv_events   rcev
  , fusion.pjc_exp_items_all ex
WHERE
	1                                             = 1
	AND req.requisition_header_id                 = reqlin.requisition_header_id
	AND trf_ord.header_id                         = reqlin.to_header_id
	AND trf_ord.header_id                         = trf_ord_lin.header_id
	AND trf_ord_lin.supply_order_reference_number = req.requisition_number
	AND trf_ord_lin.requisition_id                = req.requisition_header_id
	AND trf_ord_lin.requisition_line_id           = reqlin.requisition_line_id
	AND wshd.source_header_number                 = trf_ord.header_number
	AND itrl.line_id                              = wshd.move_order_line_id
	AND itrl.header_id                            = itrh.header_id
	AND pickslip.request_number                   = itrh.request_number
	AND pickslip.move_order_line_id               = itrl.line_id
	AND pickslip.move_order_line_id               = wshd.move_order_line_id
	AND csttxn.external_system_ref_id             = invtxn.transaction_id
	AND csttxn.wsh_delivery_detail_id             = wshd.delivery_detail_id
	-- AND ct.cst_inv_transaction_id = csttxn.cst_inv_transaction_id
	-- AND ct.wsh_delivery_detail_id = wshd.delivery_detail_id
	AND rcev.cst_inv_transaction_id   = csttxn.cst_inv_transaction_id
	AND rcev.transfer_order_header_id = trf_ord.header_id
	AND rcev.transfer_order_line_id   = trf_ord_lin.line_id
	AND ex.original_header_id         = rcev.transaction_id
	AND ex.doc_ref_id2                = csttxn.txn_source_ref_doc_number
	AND ex.project_id                 = 1234
	AND ex.task_id IN ('1234') ) ORDER BY 1,2;