618: , OPT.TRANSACTION_DATE
619: FROM OKL_POOL_CONTENTS OPC
620: ,OKL_POOL_TRANSACTIONS OPT
621: ,OKL_STRM_ELEMENTS STRM
622: ,FND_LOOKUPS FND
623: ,FND_LOOKUPS FND_REASON
624: ,OKL_POOLS_ALL OPA
625: ,OKC_K_HEADERS_ALL_B OKC
626: WHERE OPT.POL_ID = p_pool_id
619: FROM OKL_POOL_CONTENTS OPC
620: ,OKL_POOL_TRANSACTIONS OPT
621: ,OKL_STRM_ELEMENTS STRM
622: ,FND_LOOKUPS FND
623: ,FND_LOOKUPS FND_REASON
624: ,OKL_POOLS_ALL OPA
625: ,OKC_K_HEADERS_ALL_B OKC
626: WHERE OPT.POL_ID = p_pool_id
627: AND OPT.TRANSACTION_REASON = 'ADJUSTMENTS'