SLA Data from Sales Order Number.sql

select *
from
	fusion.xla_events
where
	event_id in
	(
		SELECT
			event_id
		FROM
			FUSION.cst_cost_distributions
		Where
			TRANSACTION_ID in
			(
				SELECT
					TRANSACTION_ID
				FROM
					FUSION.CST_TRANSACTIONS
				WHERE
					TXN_SOURCE_REF_DOC_NUMBER='&OM_number'
			)
	)
;

select *
from
	fusion.xla_ae_headers
where
	event_id in
	(
		SELECT
			event_id
		FROM
			FUSION.cst_cost_distributions
		Where
			TRANSACTION_ID in
			(
				SELECT
					TRANSACTION_ID
				FROM
					FUSION.CST_TRANSACTIONS
				WHERE
					TXN_SOURCE_REF_DOC_NUMBER='&OM_number'
			)
	)
;

select *
from
	fusion.xla_ae_lines
where
	ae_header_id in
	(
		select
			ae_header_id
		from
			fusion.xla_ae_headers
		where
			event_id in
			(
				SELECT
					event_id
				FROM
					FUSION.cst_cost_distributions
				Where
					TRANSACTION_ID in
					(
						SELECT
							TRANSACTION_ID
						FROM
							FUSION.CST_TRANSACTIONS
						WHERE
							TXN_SOURCE_REF_DOC_NUMBER='&OM_number'
					)
			)
	)
;