APPS.GMI_MSCA_PUB dependencies on IC_WHSE_MST

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 356: FROM ic_whse_mst w

352: ELSE
353: -- This query forces the return of No Result Found.
354: OPEN x_subInv_cursor FOR
355: SELECT w.whse_code, w.whse_name, w.orgn_code, w.mtl_organization_id, loct_ctl
356: FROM ic_whse_mst w
357: WHERE 1=2;
358: END IF;
359: ELSE
360: IF (length( NVL(p_whse_code, '')) > 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 375: FROM ic_whse_mst w

371: ELSE
372: -- This query forces the return of No Result Found.
373: OPEN x_subInv_cursor FOR
374: SELECT w.whse_code, w.whse_name, w.orgn_code, w.mtl_organization_id, loct_ctl
375: FROM ic_whse_mst w
376: WHERE 1=2;
377: END IF;
378: END IF;
379: EXCEPTION

Line 407: FROM ic_whse_mst w

403: IF (length( NVL(p_whse_code, '')) > 0)
404: THEN
405: OPEN x_subInv_cursor FOR
406: SELECT w.whse_code, w.whse_name, w.orgn_code, w.mtl_organization_id, loct_ctl
407: FROM ic_whse_mst w
408: WHERE w.whse_code like p_whse_code
409: AND w.delete_mark = 0
410: ORDER BY whse_code;
411: ELSE

Line 415: FROM ic_whse_mst w

411: ELSE
412: -- This query forces the return of No Result Found.
413: OPEN x_subInv_cursor FOR
414: SELECT w.whse_code, w.whse_name, w.orgn_code, w.mtl_organization_id, loct_ctl
415: FROM ic_whse_mst w
416: WHERE 1=2;
417: END IF;
418:
419: EXCEPTION