APPS.CSM_MTL_PARAMETERS_EVENT_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 243: FROM MTL_INTERORG_PARAMETERS mtsn,csp_inv_loc_assignments inv

239: CURSOR c_mtl_parameters_ins_csr(b_user_id NUMBER,b_res_id NUMBER)
240: IS
241: SELECT csm_mtl_parameters_acc_s.nextval as ACCESS_ID,b_user_id as USER_ID, from_organization_id,to_organization_id
242: FROM ( SELECT distinct mtsn.from_organization_id,mtsn.to_organization_id
243: FROM MTL_INTERORG_PARAMETERS mtsn,csp_inv_loc_assignments inv
244: WHERE b_res_id =inv.resource_id
245: AND inv.organization_id in (mtsn.from_organization_id,mtsn.to_organization_id)
246: AND NOT EXISTS (SELECT 1 FROM CSM_INTERORG_PARAMETERS_ACC acc
247: WHERE acc.from_organization_id = mtsn.from_organization_id

Line 273: (SELECT 1 FROM csp_inv_loc_assignments inv,asg_user au

269: )
270: UNION
271: SELECT acc.access_id,acc.user_id FROM CSM_INTERORG_PARAMETERS_ACC acc
272: WHERE NOT EXISTS
273: (SELECT 1 FROM csp_inv_loc_assignments inv,asg_user au
274: WHERE au.resource_id =inv.resource_id AND au.user_id=acc.user_id AND inv.organization_id in (acc.from_organization_id,acc.to_organization_id));
275:
276: BEGIN
277:

Line 436: AND EXISTS(SELECT 1 FROM CSP_INV_LOC_ASSIGNMENTS ass

432: AND oft.organization_id=sm.organization_id(+)
433: AND oft.freight_code=sm.freight_code(+)
434: AND sm.enabled_flag(+) = 'Y'
435: AND sysdate between sm.start_date_active(+) AND nvl(sm.end_date_active(+), sysdate+1)
436: AND EXISTS(SELECT 1 FROM CSP_INV_LOC_ASSIGNMENTS ass
437: WHERE ass.organization_id = oft.organization_id
438: AND ass.RESOURCE_ID=au.resource_id)
439: AND NOT EXISTS(SELECT 1 FROM CSM_INV_ORG_FREIGHTS_ACC acc
440: WHERE acc.organization_id = oft.organization_id

Line 469: WHERE NOT EXISTS (SELECT 1 FROM ORG_FREIGHT_TL oft,CSP_INV_LOC_ASSIGNMENTS ass,asg_user au

465: CURSOR c_inv_org_freights_del_csr
466: IS
467: SELECT acc.access_id,acc.user_id
468: FROM CSM_INV_ORG_FREIGHTS_ACC acc
469: WHERE NOT EXISTS (SELECT 1 FROM ORG_FREIGHT_TL oft,CSP_INV_LOC_ASSIGNMENTS ass,asg_user au
470: WHERE acc.organization_id = oft.organization_id
471: AND acc.freight_code=oft.freight_code
472: AND acc.user_id=au.user_id
473: AND nvl(oft.disable_date,sysdate+1) > sysdate