PS Query - Outer Join and Query Security Views
I have to create a query that has multiple outer joins to various tables. One of these tables (HRS_JO_RPL) is defined with query security view. This table may or may not have rows. I need to join it with HRS_JOB_OPENING. I created outer join using an expression with (+) operator. Outer join works fine with table HRS_JO_RPL but Query manager adds security view HRS_JO_SEC_VW without Outer Join so outer join to HRS_JO_RPL doesn't work as expected. And it doesn't show HRS_JOB_OPENING rows that don't have corresponding rows in HRS_JO_RPL.