SELECT TA.TRANSACTION_QUANTITY , TA.PRIMARY_QUANTITY , TA.TRANSACTION_ID , TA.REPETITIVE_SCHEDULE_ID , TA.ORGANIZATION_ID , TA.CREATION_DATE , TA.CREATED_BY , TA.LAST_UPDATE_DATE , TA.LAST_UPDATED_BY FROM WIP_REPETITIVE_SCHEDULES RS , WIP_MOVE_TRANSACTIONS MT , WIP_MOVE_TXN_ALLOCATIONS TA WHERE TA.TRANSACTION_ID = MT.TRANSACTION_ID AND TA.REPETITIVE_SCHEDULE_ID = RS.REPETITIVE_SCHEDULE_ID AND '_SEC:TA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY