APPS.GMI_MSCA_PUB dependencies on SY_ORGN_USR

Line 219: FROM sy_orgn_mst m, sy_orgn_usr u

215: BEGIN
216:
217: OPEN x_orgn_cursor FOR
218: SELECT m.orgn_code, m.orgn_name, m.co_code
219: FROM sy_orgn_mst m, sy_orgn_usr u
220: WHERE u.user_id = p_user_id
221: AND u.orgn_code = m.orgn_code
222: AND m.orgn_code like p_orgn
223: AND m.delete_mark = 0

Line 346: FROM ic_whse_mst w, sy_orgn_usr u

342: IF (length( NVL(p_whse_code, '')) > 0)
343: THEN
344: OPEN x_subInv_cursor FOR
345: SELECT w.whse_code, w.whse_name, w.orgn_code, w.mtl_organization_id, loct_ctl
346: FROM ic_whse_mst w, sy_orgn_usr u
347: WHERE u.orgn_code = w.orgn_code
348: AND u.user_id = p_user_id
349: AND w.whse_code like p_whse_code
350: AND w.delete_mark = 0

Line 364: FROM ic_whse_mst w, sy_orgn_usr u

360: IF (length( NVL(p_whse_code, '')) > 0)
361: THEN
362: OPEN x_subInv_cursor FOR
363: SELECT w.whse_code, w.whse_name, w.orgn_code, w.mtl_organization_id, loct_ctl
364: FROM ic_whse_mst w, sy_orgn_usr u
365: WHERE u.orgn_code = w.orgn_code
366: AND u.orgn_code = p_orgn_code
367: AND u.user_id = p_user_id
368: AND w.whse_code like p_whse_code

Line 398: -- bug 4033866 : replaced sy_orgn_usr

394: BEGIN
395:
396: -- It is possible to transfer into the same whse :
397: -- AND w.whse_code <> p_from_whse_code
398: -- bug 4033866 : replaced sy_orgn_usr
399: -- and removed the user_id restriction.
400: -- WHERE u.orgn_code = w.orgn_code
401: -- AND u.orgn_code = p_orgn_code
402: -- AND u.user_id = p_user_id