APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on ASG_USER

Line 547: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi,asg_user au

543:
544: CURSOR c_changed( b_last_date DATE)
545: IS
546: SELECT acc.access_id, acc.user_id
547: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi,asg_user au
548: WHERE msi.inventory_item_id = acc.inventory_item_id
549: AND msi.organization_id = acc.organization_id
550: AND acc.USER_ID > 0
551: AND au.user_id=acc.user_id

Line 1094: ,csp_requirement_lines e ,asg_user au

1090: SELECT csm_mtl_system_items_acc_s.NEXTVAL,inventory_item_id,org_id ,user_id
1091: FROM ( select c.inventory_item_id,d.destination_organization_id org_id ,a.user_id
1092: from csm_req_lines_acc a, csp_req_line_details b ,
1093: oe_order_lines_all c,csp_requirement_headers d
1094: ,csp_requirement_lines e ,asg_user au
1095: where a.requirement_line_id=b.requirement_line_id
1096: and b.source_type= 'IO' and b.source_id=c.line_id
1097: and au.user_id=a.user_id and au.multi_platform='Y'
1098: and d.requirement_header_id=e.requirement_header_id

Line 1102: from csm_req_lines_acc a, csp_req_line_details b , mtl_reservations c,asg_user au

1098: and d.requirement_header_id=e.requirement_header_id
1099: and b.requirement_line_id=e.requirement_line_id
1100: UNION
1101: select c.inventory_item_id,c.organization_id as org_id ,a.user_id
1102: from csm_req_lines_acc a, csp_req_line_details b , mtl_reservations c,asg_user au
1103: where a.requirement_line_id=b.requirement_line_id
1104: and b.source_type= 'RES' and b.source_id=c.reservation_id
1105: and au.user_id=a.user_id and au.multi_platform='Y') d
1106: where not exists(select 1 from csm_mtl_system_items_acc acc

Line 1161: from csm_mtl_system_items_acc a,asg_user au

1157: PROCEDURE process_htm5_user_items(p_run_date DATE)
1158: IS
1159: CURSOR c_get_del_items(b_ret_acty_date DATE) IS
1160: select a.access_id,au.user_id
1161: from csm_mtl_system_items_acc a,asg_user au
1162: where au.user_id=a.user_id
1163: and NVL(au.MULTI_PLATFORM,'N')='Y'
1164: and not exists (select 1
1165: from csf_debrief_lines b

Line 1207: asg_user au

1203: and b.lasT_update_date > b_ret_acty_date
1204: group by inventory_item_id ,nvl(receiving_inventory_org_id,issuing_inventory_org_id)
1205: order by tot desc)
1206: where rownum <= b_max_mtl_items) msi,
1207: asg_user au
1208: where not exists(select 1 from csm_mtl_system_items_acc
1209: WHERE msi.item_id = inventory_item_id
1210: AND msi.org_id = organization_id
1211: AND user_id =au.user_id);

Line 1218: AND EXISTS(SELECT 1 FROM ASG_USER au WHERE AU.USER_ID=acc.USER_ID and NVL(MULTI_PLATFORM,'N')='Y')

1214: SELECT acc.access_id, acc.user_id
1215: FROM csm_mtl_system_items_acc acc, mtl_system_items_b msi
1216: WHERE msi.inventory_item_id = acc.inventory_item_id
1217: AND msi.organization_id = acc.organization_id
1218: AND EXISTS(SELECT 1 FROM ASG_USER au WHERE AU.USER_ID=acc.USER_ID and NVL(MULTI_PLATFORM,'N')='Y')
1219: AND acc.CREATION_DATE <=p_run_date
1220: AND msi.last_update_date > p_run_date;
1221:
1222: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

Line 1369: from asg_user

1365: COMMIT;
1366:
1367: -- Check if there are any non multi platform users to process
1368: select count(*) into l_num_non_multi_users
1369: from asg_user
1370: where enabled = 'Y'
1371: and nvl(multi_platform,'N') = 'N';
1372:
1373: IF(l_num_non_multi_users > 0) THEN