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_SYSTEM_ITEM_EVENT_PKG dependencies on ASG_USER

Line 207: FROM asg_user au,

203: --SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
204: au.user_id,
205: msi.inventory_item_id,
206: msi.organization_id
207: FROM asg_user au,
208: asg_user_pub_resps aupr,
209: mtl_system_items_b msi,
210: CS_BILLING_TYPE_CATEGORIES cbtc
211: WHERE au.user_id = p_user_id

Line 208: asg_user_pub_resps aupr,

204: au.user_id,
205: msi.inventory_item_id,
206: msi.organization_id
207: FROM asg_user au,
208: asg_user_pub_resps aupr,
209: mtl_system_items_b msi,
210: CS_BILLING_TYPE_CATEGORIES cbtc
211: WHERE au.user_id = p_user_id
212: AND au.user_name = aupr.user_name

Line 368: FROM asg_user au,

364: SELECT CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
365: au.user_id,
366: msi.inventory_item_id,
367: msi.organization_id
368: FROM asg_user au,
369: csm_user_inventory_org user_org,
370: mtl_system_items_b msi,
371: CS_BILLING_TYPE_CATEGORIES cbtc
372: WHERE user_org.user_id = au.user_id

Line 425: asg_user au,

421: acc.user_id,
422: msi_tl.inventory_item_id,
423: msi_tl.organization_id
424: FROM csm_system_items_acc acc,
425: asg_user au,
426: mtl_system_items_tl msi_tl
427: WHERE acc.user_id = au.user_id
428: AND acc.inventory_item_id = msi_tl.inventory_item_id
429: AND acc.organization_id = msi_tl.organization_id

Line 789: FROM asg_user au,

785: ohqmv.INVENTORY_ITEM_ID=ohqmv2.INVENTORY_ITEM_ID AND
786: nvl(ohqmv.LOCATOR_ID,-9999)=nvl(ohqmv2.LOCATOR_ID,-9999) AND
787: nvl(ohqmv.REVISION,-9999)=nvl(ohqmv2.REVISION,-9999) AND
788: nvl(ohqmv.LOT_NUMBER,-9999)=nvl(ohqmv2.LOT_NUMBER,-9999))
789: FROM asg_user au,
790: asg_user_pub_resps aupr,
791: mtl_onhand_quantities_detail ohqmv,
792: mtl_system_items_b msi,
793: CS_BILLING_TYPE_CATEGORIES cbtc

Line 790: asg_user_pub_resps aupr,

786: nvl(ohqmv.LOCATOR_ID,-9999)=nvl(ohqmv2.LOCATOR_ID,-9999) AND
787: nvl(ohqmv.REVISION,-9999)=nvl(ohqmv2.REVISION,-9999) AND
788: nvl(ohqmv.LOT_NUMBER,-9999)=nvl(ohqmv2.LOT_NUMBER,-9999))
789: FROM asg_user au,
790: asg_user_pub_resps aupr,
791: mtl_onhand_quantities_detail ohqmv,
792: mtl_system_items_b msi,
793: CS_BILLING_TYPE_CATEGORIES cbtc
794: WHERE au.user_name = aupr.user_name

Line 837: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;

833: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
834: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
835: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
836: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
837: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;
838: TYPE access_idTab IS TABLE OF csm_mtl_onhand_qty_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
839:
840: inv_id inv_idTab;
841: org_id org_idTab;

Line 1135: FROM asg_user au,

1131: SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) */ CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
1132: au.user_id,
1133: msi.inventory_item_id,
1134: msi.organization_id
1135: FROM asg_user au,
1136: asg_user_pub_resps aupr,
1137: mtl_system_items_b msi,
1138: CS_BILLING_TYPE_CATEGORIES cbtc
1139: WHERE au.user_id = p_user_id

Line 1136: asg_user_pub_resps aupr,

1132: au.user_id,
1133: msi.inventory_item_id,
1134: msi.organization_id
1135: FROM asg_user au,
1136: asg_user_pub_resps aupr,
1137: mtl_system_items_b msi,
1138: CS_BILLING_TYPE_CATEGORIES cbtc
1139: WHERE au.user_id = p_user_id
1140: AND au.user_name = aupr.user_name

Line 1424: FROM asg_user au,

1420: ohqmv.INVENTORY_ITEM_ID=ohqmv2.INVENTORY_ITEM_ID AND
1421: nvl(ohqmv.LOCATOR_ID,-9999)=nvl(ohqmv2.LOCATOR_ID,-9999) AND
1422: nvl(ohqmv.REVISION,'-9999')=nvl(ohqmv2.REVISION,'-9999') AND
1423: nvl(ohqmv.LOT_NUMBER,'-9999')=nvl(ohqmv2.LOT_NUMBER,'-9999'))
1424: FROM asg_user au,
1425: mtl_onhand_quantities_detail ohqmv
1426: WHERE ohqmv.inventory_item_id=p_item_id
1427: AND ohqmv.organization_id=p_org_id
1428: AND nvl(ohqmv.subinventory_code,'-999') = nvl(p_subinv_code,'-999')

Line 1456: , asg_user asg

1452: cqa.user_id
1453: FROM csm_mtl_onhand_qty_acc cqa
1454: , csi_item_instances cii
1455: , csi_instance_statuses iis
1456: , asg_user asg
1457: WHERE cqa.inventory_item_id=p_item_id
1458: AND cqa.organization_id=p_org_id
1459: AND nvl(cqa.subinventory_code,'-999') = nvl(p_subinv_code,'-999')
1460: AND cqa.user_id = p_user_id

Line 1471: AND asg.user_id = asg.owner_id AND asg.user_id = cqa.user_id AND asg.ENABLED = 'Y'

1467: AND cii.location_type_code = 'INVENTORY'
1468: AND SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE)
1469: AND cii.INSTANCE_STATUS_ID = iis.instance_status_id
1470: AND NVL(iis.terminated_flag,'N') = 'N'
1471: AND asg.user_id = asg.owner_id AND asg.user_id = cqa.user_id AND asg.ENABLED = 'Y'
1472: AND NOT EXISTS
1473: ( SELECT 1
1474: FROM csm_item_instances_acc cia
1475: WHERE cia.user_id = cqa.user_id

Line 1487: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;

1483: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
1484: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
1485: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
1486: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
1487: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;
1488: TYPE access_idTab IS TABLE OF csm_mtl_onhand_qty_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
1489:
1490: inv_id inv_idTab;
1491: org_id org_idTab;