DBA Data[Home] [Help]

APPS.CSL_MTL_ITEM_LOCATIONS_ACC_PKG dependencies on ASG_USER

Line 35: , ASG_USER au

31: CURSOR c_changed( b_last_date DATE ) IS
32: SELECT acc.ACCESS_ID, acc.RESOURCE_ID
33: FROM CSL_MTL_ITEM_LOCATIONS_ACC acc
34: , MTL_ITEM_LOCATIONS b
35: , ASG_USER au
36: WHERE b.INVENTORY_LOCATION_ID = acc.INVENTORY_LOCATION_ID
37: AND b.ORGANIZATION_ID = acc.ORGANIZATION_ID
38: AND au.RESOURCE_ID = acc.RESOURCE_ID
39: AND b.LAST_UPDATE_DATE >= b_last_date;