APPS.GMI_MSCA_PUB dependencies on IC_LOCT_INV

Line 121: from ic_loct_inv l

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
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: */

Line 138: FROM ic_loct_inv l

134: AND location LIKE p_loct
135: AND delete_mark = 0
136: UNION
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;

Line 164: FROM ic_lots_mst A, ic_loct_inv B

160:
161:
162: /* OPM Note : LOT statement in form ICQTYED:
163: SELECT DISTINCT A.lot_no, A.sublot_no
164: FROM ic_lots_mst A, ic_loct_inv B
165: WHERE A.lot_id = B.lot_id AND A.delete_mark = 0 AND B.delete_mark = 0
166: AND B.item_id = :PARAMETER.item_id and a.item_id = b.item_id
167: AND lot_no <> :parameter.default_lot
168: UNION

Line 181: FROM ic_lots_mst A, ic_loct_inv B

177:
178: OPEN x_lot_cursor FOR
179: SELECT DISTINCT A.lot_no, NVL(A.sublot_no, ' '), NVL(A.lot_desc, ' ')
180: , A.lot_id, A.item_id, NVL(A.qc_grade, ' '), B.lot_status
181: FROM ic_lots_mst A, ic_loct_inv B
182: WHERE A.lot_id = B.lot_id
183: AND A.lot_no LIKE p_lot
184: AND A.delete_mark = 0
185: AND B.delete_mark = 0

Line 281: , ic_loct_inv B

277: OPEN x_sublot_cursor FOR
278: SELECT DISTINCT A.lot_no, NVL(A.sublot_no, ' '), NVL(A.lot_desc, ' ')
279: , A.lot_id, A.item_id, NVL(A.qc_grade, ' '), B.lot_status
280: FROM ic_lots_mst A
281: , ic_loct_inv B
282: WHERE B.lot_id = A.lot_id
283: AND B.item_id = A.item_id
284: AND A.sublot_no like p_sublot
285: AND A.lot_no = p_lot

Line 441: from ic_loct_inv l

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
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: */

Line 460: FROM ic_loct_inv l

456: OR (whse_code <> p_from_whse) )
457: AND delete_mark = 0
458: UNION
459: SELECT l.location, null, l.whse_code
460: FROM ic_loct_inv l
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) )

Line 687: , ic_loct_inv ili

683:
684: CURSOR get_lot_stat( item IN NUMBER, whse IN VARCHAR2, loct IN VARCHAR2, lot IN NUMBER, stat IN VARCHAR2) IS
685: SELECT ili.lot_status
686: FROM ic_lots_sts sts
687: , ic_loct_inv ili
688: WHERE ili.lot_status = sts.lot_status
689: AND sts.lot_status LIKE stat
690: AND ili.location = loct
691: AND ili.item_id = item