You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

VPD FOR LOCATION

in Transportation Management 6 comments

hi, i would to create VPD location using predicate below

EXISTS(SELECT 1 FROM LOCATION_CORPORATION LC WHERE LC.LOCATION_GID = LOCATION.LOCATION_GID AND lc.CORPORATION_GID IN(SELECT CIP.CORPORATION_GID FROM CORPORATION CO INNER JOIN CORPORATION_INVOLVED_PARTY CIP ON CO.CORPORATION_GID = CIP.CORPORATION_GID WHERE CIP.INVOLVED_PARTY_QUAL_GID = 'PSR'))

but it still appear, when i using SQL execution, it works. any idea?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!