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 312: , asg_user asg

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

Line 316: AND asg.user_id = asg.owner_id

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

Line 317: AND asg.user_id = acc.user_id

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

Line 331: , asg_user asg

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

Line 334: AND asg.user_id = asg.owner_id

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

Line 335: AND asg.user_id = acc.user_id

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

Line 360: asg_user asg

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

Line 362: AND asg.user_id = asg.owner_id

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

Line 363: AND asg.user_id = acc.user_id

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

Line 378: , asg_user asg

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

Line 394: AND asg.user_id = asg.owner_id

390: AND cii.location_type_code = 'INVENTORY'
391: AND SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE)
392: AND cii.INSTANCE_STATUS_ID = iis.instance_status_id
393: AND NVL(iis.terminated_flag,'N') = 'N'
394: AND asg.user_id = asg.owner_id
395: AND asg.user_id = cqa.user_id
396: AND asg.ENABLED = 'Y'
397: AND cii.instance_id = civ.instance_id(+)
398: AND civ.version_label_id = (SELECT MAX(version_label_id) FROM csi_i_version_labels --not using sorted desc on lud & rownum=1 as sub query doesn't honor join cond

Line 395: AND asg.user_id = cqa.user_id

391: AND SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE)
392: AND cii.INSTANCE_STATUS_ID = iis.instance_status_id
393: AND NVL(iis.terminated_flag,'N') = 'N'
394: AND asg.user_id = asg.owner_id
395: AND asg.user_id = cqa.user_id
396: AND asg.ENABLED = 'Y'
397: AND cii.instance_id = civ.instance_id(+)
398: AND civ.version_label_id = (SELECT MAX(version_label_id) FROM csi_i_version_labels --not using sorted desc on lud & rownum=1 as sub query doesn't honor join cond
399: WHERE instance_id = civ.instance_id