1. There does not seem to be anything to link PS_INSTALLATION to the subquery - I suspect there should be.
2. JOINs in subqueries tend to be nested loops, so get rid of them.
SELECT 'X'
FROM PS_INSTALLATION
WHERE EXISTS
(
SELECT *
FROM PS_KK_SOURCE_LN A
WHERE A.<something> = PS_INSTALLATION.<something>
AND A.LINE_NBR = '1'
AND A.SCHED_NBR = '1'
AND A.DISTRIB_LINE_NUM = '1'
AND EXISTS
(
SELECT *
FROM PS_KK_SOURCE_HDR B
WHERE A.KK_TRAN_ID = B.KK_TRAN_ID
AND A.KK_TRAN_DT = B.KK_TRAN_DT
AND B.BUSINESS_UNIT = 'BUS'
AND B.PO_ID = 'PO_NUM'
)
AND EXISTS
(
SELECT *
FROM PS_KK_ACTIVITY_LOG C
WHERE A.KK_TRAN_ID = C.KK_TRAN_ID
AND A.KK_TRAN_DT = C.KK_TRAN_DT
AND A.KK_TRAN_LN = C.KK_TRAN_LN
AND C.ENTRY_EVENT <> ' '
AND C.EE_PROC_STATUS IN ('N', ' ')
)
)