eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on ASG_USER

Line 311: , asg_user asg

307: --acc.INSTANCE_ID
308: FROM csm_item_instances_acc acc
309: , csi_item_instances cii
310: , csi_instance_statuses iis
311: , asg_user asg
312: WHERE cii.instance_id = acc.instance_id
313: AND cii.location_type_code = 'INVENTORY'
314: AND cii.instance_status_id = iis.instance_status_id
315: AND asg.user_id = asg.owner_id

Line 315: AND asg.user_id = asg.owner_id

311: , asg_user asg
312: WHERE cii.instance_id = acc.instance_id
313: AND cii.location_type_code = 'INVENTORY'
314: AND cii.instance_status_id = iis.instance_status_id
315: AND asg.user_id = asg.owner_id
316: AND asg.user_id = acc.user_id
317: AND ( NOT (SYSDATE BETWEEN NVL(cii.active_start_date,SYSDATE)
318: AND NVL(cii.active_end_date,SYSDATE))
319: OR (NVL(iis.terminated_flag,'N') = 'Y')

Line 316: AND asg.user_id = acc.user_id

312: WHERE cii.instance_id = acc.instance_id
313: AND cii.location_type_code = 'INVENTORY'
314: AND cii.instance_status_id = iis.instance_status_id
315: AND asg.user_id = asg.owner_id
316: AND asg.user_id = acc.user_id
317: AND ( NOT (SYSDATE BETWEEN NVL(cii.active_start_date,SYSDATE)
318: AND NVL(cii.active_end_date,SYSDATE))
319: OR (NVL(iis.terminated_flag,'N') = 'Y')
320: );

Line 330: , asg_user asg

326: acc.user_ID,
327: acc.INSTANCE_ID
328: FROM csm_item_instances_acc acc
329: , csi_item_instances cii
330: , asg_user asg
331: WHERE cii.instance_id = acc.instance_id
332: AND cii.location_type_code = 'INVENTORY'
333: AND asg.user_id = asg.owner_id
334: AND asg.user_id = acc.user_id

Line 333: AND asg.user_id = asg.owner_id

329: , csi_item_instances cii
330: , asg_user asg
331: WHERE cii.instance_id = acc.instance_id
332: AND cii.location_type_code = 'INVENTORY'
333: AND asg.user_id = asg.owner_id
334: AND asg.user_id = acc.user_id
335: AND NOT EXISTS
336: (SELECT 1
337: FROM csm_mtl_onhand_qty_acc ohqacc

Line 334: AND asg.user_id = acc.user_id

330: , asg_user asg
331: WHERE cii.instance_id = acc.instance_id
332: AND cii.location_type_code = 'INVENTORY'
333: AND asg.user_id = asg.owner_id
334: AND asg.user_id = acc.user_id
335: AND NOT EXISTS
336: (SELECT 1
337: FROM csm_mtl_onhand_qty_acc ohqacc
338: WHERE ohqacc.user_id = acc.user_id

Line 359: asg_user asg

355: --acc.instance_id,
356: acc.access_id
357: FROM csm_item_instances_acc acc,
358: csi_item_instances cii,
359: asg_user asg
360: WHERE cii.instance_id = acc.instance_id
361: AND asg.user_id = asg.owner_id
362: AND asg.user_id = acc.user_id
363: AND asg.ENABLED = 'Y'

Line 361: AND asg.user_id = asg.owner_id

357: FROM csm_item_instances_acc acc,
358: csi_item_instances cii,
359: asg_user asg
360: WHERE cii.instance_id = acc.instance_id
361: AND asg.user_id = asg.owner_id
362: AND asg.user_id = acc.user_id
363: AND asg.ENABLED = 'Y'
364: AND cii.last_update_date >= p_last_run_date;
365:

Line 362: AND asg.user_id = acc.user_id

358: csi_item_instances cii,
359: asg_user asg
360: WHERE cii.instance_id = acc.instance_id
361: AND asg.user_id = asg.owner_id
362: AND asg.user_id = acc.user_id
363: AND asg.ENABLED = 'Y'
364: AND cii.last_update_date >= p_last_run_date;
365:
366: -- get all the trackable items that exists in the csm_mtl_onhand_acc table

Line 379: , asg_user asg

375: CIR.OBJECT_ID
376: FROM csm_mtl_onhand_qty_acc cqa
377: , csi_item_instances cii
378: , csi_instance_statuses iis
379: , asg_user asg
380: , csi_i_version_labels civ
381: , CSI_II_RELATIONSHIPS CIR
382: WHERE cii.inventory_item_id = cqa.inventory_item_id
383: AND cii.inv_organization_id = cqa.organization_id

Line 395: AND asg.user_id = asg.owner_id

391: AND cii.location_type_code = 'INVENTORY'
392: AND SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE)
393: AND cii.INSTANCE_STATUS_ID = iis.instance_status_id
394: AND NVL(iis.terminated_flag,'N') = 'N'
395: AND asg.user_id = asg.owner_id
396: AND asg.user_id = cqa.user_id
397: AND asg.ENABLED = 'Y'
398: AND cii.instance_id = civ.instance_id(+)
399: AND (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(civ.active_start_date,SYSDATE))

Line 396: AND asg.user_id = cqa.user_id

392: AND SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE)
393: AND cii.INSTANCE_STATUS_ID = iis.instance_status_id
394: AND NVL(iis.terminated_flag,'N') = 'N'
395: AND asg.user_id = asg.owner_id
396: AND asg.user_id = cqa.user_id
397: AND asg.ENABLED = 'Y'
398: AND cii.instance_id = civ.instance_id(+)
399: AND (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(civ.active_start_date,SYSDATE))
400: AND TRUNC(NVL(civ.active_end_date,SYSDATE)))