[dbo].[al_aud_rel_sw_allocation

[dbo].[al_aud_rel_sw_allocation_view]

(local) > mdb > Views > dbo.al_aud_rel_sw_allocation_view

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	10:37:23 PM Thursday, February 10, 2011
Last Modified	10:37:23 PM Thursday, February 10, 2011

Columns

Name
relationship_id
object_uuid
ac1ivid
acdatedt
actimetm
accommnt
actext1
acint1
acdate1
secondary_object_uuid
lk2ivid
lkinstnc
lkstrtdt
lkenddt
lkcommnt
creation_user
creation_date
last_update_user
last_update_date
version_number
inactive
tenant
audit_trail_id
audit_trail_user
audit_trail_type
audit_trail_date
audit_trail_product

SQL Script

CREATE VIEW dbo.al_aud_rel_sw_allocation_view AS select audittable.* from dbo.aud_arg_rel_sw_allocation audittable WITH(READPAST) left outer join dbo.al_aud_rel_sw_allocation_potr audpointer on (audittable.relationship_id = audpointer.relationship_id ) where ( audpointer.audit_trail_id is null or ( audittable.audit_trail_id >= audpointer.audit_trail_id and audpointer.is_deleted != 1 ))
GO

Uses

[dbo].[al_aud_rel_sw_allocation_potr]
[dbo].[aud_arg_rel_sw_allocation]
dbo