APPS.JAI_OM_RMA_PKG dependencies on MTL_SYSTEM_ITEMS

Line 83: FROM MTL_SYSTEM_ITEMS

79:
80: CURSOR c_get_shippable_flag(c_inv_item_id NUMBER, c_organization_id NUMBER)
81: IS
82: SELECT SHIPPABLE_ITEM_FLAG
83: FROM MTL_SYSTEM_ITEMS
84: WHERE INVENTORY_ITEM_ID = c_inv_item_id
85: AND ORGANIZATION_ID = c_organization_id;
86: -- added by Allen Yang for bug 9666476 28-apr-2010, end
87:

Line 688: FROM mtl_system_items

684: FROM wsh_delivery_details wdd
685: WHERE wdd.delivery_detail_id = TO_NUMBER(pn_delivery_detail_id)
686: AND (wdd.inventory_item_id IN
687: (SELECT inventory_item_id
688: FROM mtl_system_items
689: WHERE base_item_id = p_inventory_item_id
690: AND bom_item_type = 4) OR
691: wdd.inventory_item_id = p_inventory_item_id)
692: AND wdd.shipped_quantity IS NOT NULL)

Line 708: FROM mtl_system_items

704: AND rctla.inventory_item_id = p_inventory_item_id
705: AND wdd.delivery_detail_id = TO_NUMBER(rctla.interface_line_attribute3)
706: AND (wdd.inventory_item_id IN
707: (SELECT inventory_item_id
708: FROM mtl_system_items
709: WHERE base_item_id = p_inventory_item_id
710: AND bom_item_type = 4) OR
711: wdd.inventory_item_id = p_inventory_item_id)
712: AND wdd.shipped_quantity IS NOT NULL)