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

Line 42: FROM wf_notifications wfn,asg_user au

38: CSM_UTIL_PKG.LOG('Entered DOWNLOAD_MULTIPLAT_NFN', 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN', FND_LOG.LEVEL_PROCEDURE);
39: -- set the program update date in jtm_con_request_data to sysdate
40:
41: FOR l_notf_rec IN ( SELECT DISTINCT wfn.notification_id ,au.USER_ID
42: FROM wf_notifications wfn,asg_user au
43: WHERE au.user_name IN (FROM_ROLE,RECIPIENT_ROLE)
44: AND au.enabled='Y' and au.multi_platform='Y'
45: AND wfn.STATUS='OPEN'
46: AND wfn.MESSAGE_TYPE='CSM_MSGS'

Line 136: asg_user au

132: -- get all notifications in which user is a recipient
133: CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS
134: SELECT DISTINCT wfn.notification_id
135: FROM wf_notifications wfn,
136: asg_user au
137: WHERE au.user_id=b_user_id
138: AND au.user_name IN (FROM_ROLE,RECIPIENT_ROLE)
139: AND wfn.STATUS='OPEN'
140: AND wfn.MESSAGE_TYPE='CSM_MSGS'

Line 152: ASG_USER au

148: --12.1
149: CURSOR c_broadcast_notf(b_user_id fnd_user.user_id%TYPE) IS
150: SELECT DISTINCT wfn.notification_id
151: FROM WF_NOTIFICATIONS wfn,
152: ASG_USER au
153: WHERE au.user_id=b_user_id
154: AND wfn.STATUS='OPEN'
155: AND wfn.MESSAGE_TYPE='CSM_MSGS'
156: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'

Line 201: ASG_USER au

197: IS
198: CURSOR c_users(b_nid NUMBER) IS
199: SELECT DISTINCT au.user_id
200: FROM WF_NOTIFICATIONS wfn,
201: ASG_USER au
202: WHERE wfn.NOTIFICATION_ID=b_nid
203: AND wfn.STATUS='OPEN'
204: AND wfn.MESSAGE_TYPE='CSM_MSGS'
205: AND au.user_name IN (WFN.FROM_ROLE,WFN.RECIPIENT_ROLE)

Line 218: ASG_USER au

214: --12.1
215: CURSOR c_broadcast_users(b_nid NUMBER) IS
216: SELECT DISTINCT au.user_id
217: FROM WF_NOTIFICATIONS wfn,
218: ASG_USER au
219: WHERE wfn.NOTIFICATION_ID=b_nid
220: AND wfn.STATUS='OPEN'
221: AND wfn.MESSAGE_TYPE='CSM_MSGS'
222: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'

Line 841: FROM WF_LOCAL_ROLES wf, ASG_USER au

837: l_upd BOOLEAN:=false;
838: BEGIN
839: BEGIN
840: SELECT wf.name,wf.email_address,wf.notification_preference INTO role_name,l_wf_email ,l_pref
841: FROM WF_LOCAL_ROLES wf, ASG_USER au
842: WHERE wf.name ='CSM_'||b_user_name||'_ROLE'
843: AND au.user_name=b_user_name
844: AND au.enabled='Y';
845:

Line 878: FROM FND_USER fu, Asg_user au ,wf_local_roles wf

874: EXCEPTION
875: WHEN no_data_found THEN
876: SELECT 'CSM_'||fu.user_name||'_ROLE',wf.display_name,fu.email_address
877: INTO role_name,role_display_name,l_fnd_email
878: FROM FND_USER fu, Asg_user au ,wf_local_roles wf
879: WHERE fu.user_name=b_user_name
880: AND sysdate between nvl(fu.start_date,sysdate-1) and nvl(fu.end_date,sysdate+1)
881: AND wf.name=fu.USER_NAME AND au.USER_NAME=fu.USER_NAME AND au.ENABLED='Y' ;
882:

Line 1093: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,

1089: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1090: 'HZ_LOCATION',
1091: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1092: ) location_id
1093: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,
1094: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,
1095: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1096: WHERE au.RESOURCE_ID=b.RESOURCE_ID
1097: AND b.TASK_ASSIGNMENT_ID=b_task_ass_id

Line 1121: FROM ASG_USER AU, CSM_TASKS_ACC ACC,

1117: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1118: 'HZ_LOCATION',
1119: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1120: ) location_id
1121: FROM ASG_USER AU, CSM_TASKS_ACC ACC,
1122: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,
1123: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1124: WHERE acc.TASK_ID=b_task_id
1125: AND acc.TASK_ID=tsk.TASK_ID

Line 1142: FROM ASG_USER AU, CSM_TASKS_ACC ACC,

1138: CURSOR c_user_task2(b_task_id NUMBER)
1139: IS
1140: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, acc.TASK_ID,TASK_NAME,TASK_NUMBER,
1141: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id
1142: FROM ASG_USER AU, CSM_TASKS_ACC ACC,
1143: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr
1144: WHERE acc.TASK_ID=b_task_id
1145: AND acc.TASK_ID=tsk.TASK_ID
1146: AND au.USER_ID=acc.USER_ID

Line 1158: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,

1154: CURSOR c_user_task_assigned2(b_task_ass_id NUMBER)
1155: IS
1156: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, b.TASK_ID,TASK_NAME,TASK_NUMBER,
1157: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id
1158: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,
1159: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr
1160: WHERE au.RESOURCE_ID=b.RESOURCE_ID
1161: AND b.TASK_ASSIGNMENT_ID=b_task_ass_id
1162: AND b.TASK_ID=tsk.TASK_ID

Line 1179: FROM ASG_USER AU, CSM_INCIDENTS_ALL_ACC ACC,cs_incidents_all_b INC,

1175: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1176: 'HZ_LOCATION',
1177: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1178: ) location_id
1179: FROM ASG_USER AU, CSM_INCIDENTS_ALL_ACC ACC,cs_incidents_all_b INC,
1180: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1181: WHERE acc.incident_id=b_inc_id
1182: AND au.USER_ID=acc.USER_ID
1183: AND INC.incident_id=acc.incident_id

Line 1196: FND_USER usr,asg_user au

1192: IS
1193: SELECT acc.USER_ID,usr.USER_NAME,usr.email_address,
1194: qry.QUERY_NAME,acc.INSTANCE_NAME
1195: FROM csm_query_b qry,csm_query_instances_acc acc,
1196: FND_USER usr,asg_user au
1197: WHERE acc.QUERY_ID=qry.QUERY_ID
1198: AND acc.INSTANCE_ID=b_inst
1199: AND au.user_id=usr.USER_ID
1200: AND NVL(AU.multi_platform,'N')='N'

Line 1207: FROM mtl_system_items_b b, CSM_MTL_ONHAND_QTY_ACC acc,FND_USER usr ,asg_user au

1203: CURSOR c_parts(b_acc_id NUMBER)
1204: IS
1205: SELECT acc.USER_ID,usr.USER_NAME,usr.email_address,
1206: b.segment1 "ITEM_NAME",b.description,acc.SUBINVENTORY_CODE,acc.QUANTITY, b.primary_uom_code
1207: FROM mtl_system_items_b b, CSM_MTL_ONHAND_QTY_ACC acc,FND_USER usr ,asg_user au
1208: WHERE acc.access_id=b_acc_id
1209: AND b.inventory_item_id=acc.inventory_item_id
1210: AND b.organization_id=acc.organization_id
1211: AND usr.USER_ID=au.USER_ID

Line 1224: , fnd_user usr,asg_user au

1220: nvl(ol.actual_arrival_date,ol.schedule_arrival_date) arrival_date
1221: FROM csm_req_lines_acc acc
1222: , CSP_REQ_LINE_DETAILS crld
1223: , OE_ORDER_LINES_ALL ol, OE_ORDER_HEADERS_ALL oh
1224: , fnd_user usr,asg_user au
1225: WHERE acc.access_id=b_acc_id
1226: AND acc.USER_ID = usr.USER_ID
1227: AND acc.requirement_line_id = crld.requirement_line_id
1228: AND crld.source_id = ol.line_id

Line 1244: FROM ASG_USER

1240:
1241:
1242: CURSOR c_get_resp_id(b_user_id NUMBER) IS
1243: SELECT APP_ID,RESPONSIBILITY_ID
1244: FROM ASG_USER
1245: WHERE USER_ID=b_user_id;
1246:
1247: l_task_id NUMBER; l_task_number VARCHAR2(100); l_task_name VARCHAR2(200);
1248: l_sr_id NUMBER; l_sr_number VARCHAR2(100); l_sr_summary VARCHAR2(200);

Line 1630: FROM ASG_USER

1626: AND STATUS='CLOSED';
1627:
1628: CURSOR c_get_resp_id(b_user_name VARCHAR2) IS
1629: SELECT APP_ID,RESPONSIBILITY_ID
1630: FROM ASG_USER
1631: WHERE USER_NAME=b_user_name;
1632:
1633: l_timeout NUMBER;
1634: l_resp_id NUMBER;

Line 1770: from csm_deferred_nfn_info nfn , asg_pub_item pi, asg_user usr, wf_roles wfrl

1766: CURSOR c_get_deferred_data(b_id NUMBER)
1767: IS
1768: select nfn.deferred_tran_id,nfn.sequence, nfn.client_id, DECODE(NVL(usr.multi_platform,'N'),'Y','WEBKIT-Based',NVL(usr.cookie,'WINCE')) as DEVICE_TYPE,
1769: wfrl.display_name, nfn.object_name, pi.primary_key_column, nfn.object_id, nfn.error_msg,nfn.creation_date
1770: from csm_deferred_nfn_info nfn , asg_pub_item pi, asg_user usr, wf_roles wfrl
1771: where tracking_id=b_id
1772: and wfrl.name=nfn.client_id
1773: and nfn.object_name=pi.item_id
1774: and usr.user_name=nfn.client_id;

Line 1789: FROM ASG_USER

1785: l_tran_date date;
1786:
1787: CURSOR c_get_resp_id(b_user_name VARCHAR2) IS
1788: SELECT APP_ID,RESPONSIBILITY_ID
1789: FROM ASG_USER
1790: WHERE USER_NAME=b_user_name;
1791:
1792: l_user_string VARCHAR2(4000);
1793: l_user_list asg_download.pk_list;

Line 1960: FROM ASG_USER

1956: AND LOOKUP_VALUE=b_child;
1957:
1958: CURSOR c_get_resp_id(b_user_name VARCHAR2) IS
1959: SELECT APP_ID,RESPONSIBILITY_ID
1960: FROM ASG_USER
1961: WHERE USER_NAME=b_user_name;
1962:
1963: l_wftimer wf_event_t;
1964: l_timeout NUMBER;

Line 2195: FROM ASG_USER

2191: l_sync_date DATE;
2192:
2193: CURSOR c_get_resp_id(b_user_name VARCHAR2) IS
2194: SELECT APP_ID,RESPONSIBILITY_ID
2195: FROM ASG_USER
2196: WHERE USER_NAME=b_user_name;
2197:
2198: l_user_string VARCHAR2(4000);
2199: l_user_list asg_download.pk_list;

Line 2314: FROM ASG_USER

2310: l_sync_date DATE;
2311:
2312: CURSOR c_get_resp_id(b_user_name VARCHAR2) IS
2313: SELECT APP_ID,RESPONSIBILITY_ID
2314: FROM ASG_USER
2315: WHERE USER_NAME=b_user_name;
2316:
2317: l_user_string VARCHAR2(4000);
2318: l_user_list asg_download.pk_list;

Line 2345: FROM '||asg_base.G_OLITE_SCHEMA||'.c$sync_history HIST , ASG_USER au

2341:
2342:
2343: OPEN cur FOR 'SELECT SESSION_ID,client_id,DECODE(DEVICE_PLATFORM,''WCE'',''WINCE'',''LAPTOP'') as DEVICE_TYPE,
2344: dbms_lob.substr(message,1990,1)||''...'' as ERROR_MSG, START_TIME AS SYNC_DATE
2345: FROM '||asg_base.G_OLITE_SCHEMA||'.c$sync_history HIST , ASG_USER au
2346: WHERE RESULT<>''SUCCESS''
2347: AND trim(CLIENT_ID) IS NOT NULL
2348: AND CLIENT_ID = AU.USER_NAME
2349: AND START_TIME > AU.CREATION_DATE