APPS.GMI_MSCA_PUB dependencies on IC_ITEM_MST

Line 63: FROM ic_item_mst

59: OPEN x_itemNo_cursor FOR
60: SELECT item_no, item_desc1, item_id
61: , loct_ctl, lot_ctl, sublot_ctl, grade_ctl, status_ctl, dualum_ind
62: , qc_grade, lot_status, lot_indivisible, item_um, item_um2, noninv_ind
63: FROM ic_item_mst
64: WHERE UPPER(item_no) like UPPER(p_item_no)
65: AND delete_mark = 0
66:
67: --- For GTIN support

Line 78: ic_item_mst opi

74: item_um2, noninv_ind
75: FROM
76: mtl_cross_references mcr,
77: mtl_system_items mti,
78: ic_item_mst opi
79: WHERE
80: opi.item_no = mti.segment1
81: AND mti.inventory_item_id = mcr.inventory_item_id
82: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 96: FROM ic_item_mst

92: OPEN x_itemNo_cursor FOR
93: SELECT item_no, item_desc1, item_id
94: , loct_ctl, lot_ctl, sublot_ctl, grade_ctl, status_ctl, dualum_ind
95: , qc_grade, lot_status, lot_indivisible, item_um, item_um2, noninv_ind
96: FROM ic_item_mst
97: WHERE 1=2;
98: END IF;
99:
100: EXCEPTION

Line 186: AND B.item_id IN (SELECT item_id FROM ic_item_mst WHERE item_no = p_item_no)

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
186: AND B.item_id IN (SELECT item_id FROM ic_item_mst WHERE item_no = p_item_no)
187: AND A.item_id = B.item_id
188: AND NVL(p_whse_code, B.whse_code) = B.whse_code
189: AND NVL(p_location, B.location) = B.location
190: UNION

Line 196: AND A.item_id IN (SELECT item_id FROM ic_item_mst WHERE item_no = p_item_no)

192: , A.lot_id, A.item_id, NVL(A.qc_grade, ' '), null
193: FROM ic_lots_mst A
194: WHERE A.lot_no LIKE p_lot
195: AND A.delete_mark = 0
196: AND A.item_id IN (SELECT item_id FROM ic_item_mst WHERE item_no = p_item_no)
197: AND A.lot_id > 0
198: ORDER BY 1, 2;
199:
200:

Line 286: AND A.item_id IN (SELECT item_id FROM ic_item_mst WHERE item_no = p_item_no)

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
286: AND A.item_id IN (SELECT item_id FROM ic_item_mst WHERE item_no = p_item_no)
287: AND B.delete_mark = 0
288: AND A.delete_mark = 0
289: ORDER BY 1, 2;
290:

Line 313: AND i.item_id IN (SELECT item_id FROM ic_item_mst WHERE item_no = p_item_no)

309: FROM sy_uoms_mst u
310: , ic_item_cnv i
311: WHERE i.um_type = u.um_type
312: AND u.uom_code like p_uom
313: AND i.item_id IN (SELECT item_id FROM ic_item_mst WHERE item_no = p_item_no)
314: AND i.delete_mark = 0
315: AND u.delete_mark = 0
316: UNION ALL
317: SELECT item_um

Line 318: FROM ic_item_mst

314: AND i.delete_mark = 0
315: AND u.delete_mark = 0
316: UNION ALL
317: SELECT item_um
318: FROM ic_item_mst
319: WHERE item_no = p_item_no
320: AND item_um like p_uom
321: ORDER BY 1;
322: