APPS.GMI_MSCA_PUB dependencies on IC_LOCT_MST

Line 116: from ic_loct_mst

112: IS
113:
114: /*
115: select location, loct_desc
116: from ic_loct_mst
117: where whse_code = :ic_adjs_jnl_vw.to_whse_code
118: and delete_mark = 0 and location <> :parameter.default_loct
119: UNION
120: select distinct l.location, '' loct_desc

Line 123: and not exists (select location from ic_loct_mst where location = l.location)

119: UNION
120: select distinct l.location, '' loct_desc
121: from ic_loct_inv l
122: where whse_code = :ic_adjs_jnl_vw.to_whse_code
123: and not exists (select location from ic_loct_mst where location = l.location)
124: and (:ic_adjs_jnl_vw.item_loct_ctl = 2 OR :ic_adjs_jnl_vw.to_whse_loct_ctl = 2) order by 1
125: */
126:
127: BEGIN

Line 131: FROM ic_loct_mst

127: BEGIN
128:
129: OPEN x_loct_cursor FOR
130: SELECT location, loct_desc, whse_code
131: FROM ic_loct_mst
132: WHERE whse_code LIKE p_whse_code
133: AND location <> FND_PROFILE.VALUE('IC$DEFAULT_LOCT')
134: AND location LIKE p_loct
135: AND delete_mark = 0

Line 141: AND NOT EXISTS(select location from ic_loct_mst where location = l.location)

137: SELECT l.location, null, l.whse_code
138: FROM ic_loct_inv l
139: WHERE l.whse_code LIKE p_whse_code
140: AND l.location LIKE p_loct
141: AND NOT EXISTS(select location from ic_loct_mst where location = l.location)
142: ORDER BY 1;
143:
144: EXCEPTION
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 437: from ic_loct_mst

433: IS
434:
435: /*
436: select location, loct_desc
437: from ic_loct_mst
438: where whse_code = :ic_adjs_jnl_vw.to_whse_code
439: and delete_mark = 0 and location <> :parameter.default_loct UNION
440: select distinct l.location, '' loct_desc
441: from ic_loct_inv l

Line 443: and not exists (select location from ic_loct_mst where location = l.location)

439: and delete_mark = 0 and location <> :parameter.default_loct UNION
440: select distinct l.location, '' loct_desc
441: from ic_loct_inv l
442: where whse_code = :ic_adjs_jnl_vw.to_whse_code
443: and not exists (select location from ic_loct_mst where location = l.location)
444: and (:ic_adjs_jnl_vw.item_loct_ctl = 2 OR :ic_adjs_jnl_vw.to_whse_loct_ctl = 2) order by 1
445: */
446:
447: BEGIN

Line 451: FROM ic_loct_mst

447: BEGIN
448:
449: OPEN x_loct_cursor FOR
450: SELECT location, loct_desc, whse_code
451: FROM ic_loct_mst
452: WHERE whse_code LIKE p_whse_code
453: AND location <> FND_PROFILE.VALUE('IC$DEFAULT_LOCT')
454: AND location LIKE p_loct
455: AND ( (location <> p_from_loct AND whse_code = p_from_whse)

Line 465: AND NOT EXISTS(select location from ic_loct_mst where location = l.location)

461: WHERE l.whse_code LIKE p_whse_code
462: AND l.location LIKE p_loct
463: AND ( (l.location <> p_from_loct AND l.whse_code = p_from_whse)
464: OR (l.whse_code <> p_from_whse) )
465: AND NOT EXISTS(select location from ic_loct_mst where location = l.location)
466: ORDER BY 1;
467:
468: EXCEPTION
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR