AE_TEMPLOCK_VW - Temp Tbl Lock by Table - PeopleTools Table Reference

AE_TEMPLOCK_VW	index back
Temp Tbl Lock by Table

Tracks how many Locks are currently in effect for a particular Temporary Table.

SELECT RECNAME , COUNT(*) FROM PS_AETEMPTBLMGR WHERE CURTEMPINSTANCE > 0 GROUP BY RECNAME

PeopleSoft Field Name Field Type Column Type Description

RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

TEMPTBLINSTLOCKS Number(4,0) SMALLINT NOT NULL Used to track how many instances of a particular temporary table are locked/in use at the moment.

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
TEMPTBLINSTLOCKS	Number(4,0)	SMALLINT NOT NULL	Used to track how many instances of a particular temporary table are locked/in use at the moment.