APPS.GMI_SHIPPING_UTIL dependencies on IC_ITEM_MST

Line 144: FROM ic_item_mst iim,

140:
141: GMI_reservation_Util.PrintLn('Find OPM Item ID');
142:
143: SELECT iim.item_id INTO l_item_id
144: FROM ic_item_mst iim,
145: mtl_system_items msi
146: WHERE msi.inventory_item_id = p_shipping_line.inventory_item_id
147: AND msi.organization_id = p_shipping_line.organization_id
148: AND msi.segment1 = iim.item_no;

Line 867: FROM ic_item_mst iim,

863: /* row in ic_tran_pnd. If any of these retrievals fails there is no */
864: /* point in continuing, so let the exception raised take over. */
865:
866: SELECT iim.item_id, iim.lot_ctl, iim.loct_ctl INTO l_item_id,l_lot_ctl, l_loct_ctl
867: FROM ic_item_mst iim,
868: mtl_system_items msi
869: WHERE msi.inventory_item_id = p_shipping_line.inventory_item_id
870: AND msi.organization_id = p_shipping_line.organization_id
871: AND msi.segment1 = iim.item_no;

Line 2029: From ic_item_mst opm

2025: /* CURSOR is_only_default IS
2026: Select opm.lot_ctl
2027: , opm.loct_ctl
2028: , whse.loct_ctl
2029: From ic_item_mst opm
2030: , mtl_system_items mtl
2031: , ic_whse_mst whse
2032: Where mtl.inventory_item_id = p_inventory_item_id
2033: and mtl.organization_id = p_organization_id

Line 2039: From ic_item_mst opm,mtl_system_items mtl

2035: and whse.mtl_organization_id = p_organization_id; */
2036:
2037: CURSOR is_only_default IS
2038: Select noninv_ind
2039: From ic_item_mst opm,mtl_system_items mtl
2040: Where mtl.inventory_item_id = p_inventory_item_id
2041: and mtl.organization_id = p_organization_id
2042: and mtl.segment1 = opm.item_no;
2043:

Line 2085: FROM ic_item_mst iim,

2081:
2082: /* End Enhancement 2320442, 2901317 - Lakshmi Swamy */
2083:
2084: SELECT iim.item_id INTO l_item_id
2085: FROM ic_item_mst iim,
2086: mtl_system_items msi
2087: WHERE msi.inventory_item_id = p_inventory_item_id
2088: AND msi.organization_id = p_organization_id
2089: AND msi.segment1 = iim.item_no;

Line 3045: FROM ic_item_mst iim,

3041:
3042: CURSOR c_get_item_info ( pitem_id in number, porg_id in number)
3043: IS
3044: SELECT iim.item_id
3045: FROM ic_item_mst iim,
3046: mtl_system_items msi
3047: WHERE msi.inventory_item_id = pitem_id
3048: AND msi.organization_id = porg_id
3049: AND msi.segment1 = iim.item_no;

Line 3556: From ic_item_mst ic

3552: Select ic.item_id
3553: , ic.lot_ctl
3554: , ic.loct_ctl
3555: , ic.noninv_ind /* Bug 2901317 */
3556: From ic_item_mst ic
3557: , mtl_system_items mtl
3558: Where ic.item_no = mtl.segment1
3559: and mtl.inventory_item_id = l_inventory_item_id
3560: and mtl.organization_id = l_organization_id;

Line 4038: From ic_item_mst ic

4034: AND trans_qty <> 0;
4035:
4036: Cursor Get_item_info IS
4037: Select ic.noninv_ind
4038: From ic_item_mst ic
4039: , mtl_system_items mtl
4040: Where ic.item_no = mtl.segment1
4041: and mtl.inventory_item_id = l_inventory_item_id
4042: and mtl.organization_id = l_organization_id;

Line 4278: FROM ic_item_mst

4274: l_allow_negative_inv NUMBER ;
4275:
4276: CURSOR Cur_non_inv IS
4277: SELECT noninv_ind
4278: FROM ic_item_mst
4279: WHERE item_id = p_tran_rec.item_id;
4280:
4281: CURSOR Cur_get_onhand_qty(p_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec) IS
4282: SELECT loct_onhand as qty

Line 4328: FROM ic_item_mst iim,

4324: l_whse_ctl NUMBER;
4325:
4326: Cursor Get_item_info IS
4327: SELECT iim.item_id, iim.loct_ctl
4328: FROM ic_item_mst iim,
4329: mtl_system_items msi
4330: WHERE msi.inventory_item_id = p_inventory_item_id
4331: AND msi.organization_id = p_mtl_organization_id
4332: AND msi.segment1 = iim.item_no;