DBA Data[Home] [Help]

APPS.GMI_SHIPPING_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 145: mtl_system_items msi

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;
149:

Line 868: mtl_system_items msi

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;
872:

Line 2030: , mtl_system_items mtl

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
2034: and mtl.segment1 = opm.item_no

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 2086: mtl_system_items msi

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;
2090:

Line 2362: From mtl_system_items

2358: l_po_info c_po_info%ROWTYPE;
2359:
2360: Cursor get_item_desc IS
2361: Select description
2362: From mtl_system_items
2363: Where inventory_item_id = p_shipping_line.inventory_item_id
2364: and organization_id = p_shipping_line.organization_id;
2365:
2366: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS

Line 3046: mtl_system_items msi

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;
3050:

Line 3557: , mtl_system_items mtl

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;
3561:

Line 4039: , mtl_system_items mtl

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;
4043:

Line 4329: mtl_system_items msi

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;
4333: