SELECT STATEMENT	CHOOSE	4769	7	546					
TABLE ACCESS(BY INDEX ROWID) DCSDBA.APPLICATION_USER	ANALYZED	2	1	27					
INDEX(UNIQUE SCAN) DCSDBA.PK_APPLICATION_USER	ANALYZED	1	482					"AU"."USER_ID"=:B1	
SORT(GROUP BY)		4769	7	546					
NESTED LOOPS		4759	7	546					
NESTED LOOPS		4752	7	371					
TABLE ACCESS(FULL) DCSDBA.INVENTORY_TRANSACTION	ANALYZED	4752	18	684					"SYS_ALIAS_1"."SITE_ID"='COR01' AND TRUNC("SYS_ALIAS_1"."DSTAMP")>=TO_DATE('2007-01-28 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND TRUNC("SYS_ALIAS_1"."DSTAMP")<=TO_DATE('2007-01-29 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND "SYS_ALIAS_1"."FROM_LOC_ID" IS NOT NULL AND "SYS_ALIAS_1"."CODE"='Pick'
INDEX(UNIQUE SCAN) DCSDBA.PK_CLIENT_GROUP_CLIENTS	ANALYZED		1	15				"CLIENT_GROUP_CLIENTS"."CLIENT_GROUP"='CORBY' AND "SYS_ALIAS_1"."CLIENT_ID"="CLIENT_GROUP_CLIENTS"."CLIENT_ID"	
TABLE ACCESS(BY INDEX ROWID) DCSDBA.LOCATION	ANALYZED	1	1	25					"L"."LOC_TYPE"<>'Stage'
INDEX(UNIQUE SCAN) DCSDBA.U_LOCATION_ID	ANALYZED		18					"SYS_ALIAS_1"."FROM_LOC_ID"="L"."LOCATION_ID" AND "L"."SITE_ID"='COR01'